Some tips for using MySQL. How to get information from a database.
How to use plain text queries in MySQL database to find certain strings in a database instance. This could be very useful.
How to use plain text queries in MySQL database to find certain strings in a database instance. This could be very useful.
Some more very useful Google Dorks for browsing the Internet in 2022. These should be most useful to find interesting things connected to the Internet.
How to set up and use the sudoreplay system on an Ubuntu server and then record all sudo usage for later examination. This could be very useful to a systems admin.
Some more very useful tips for the MPV movie player on Linux. How to play a Youtube video and select the resolution.
Some very useful Google Dorks for 2022. These can find some very interesting files. Like @pwcache files and /etc/passwd files containing Linux passwords…
A very useful SSH client for Windows machines to connect to a remote Linux machine and administer it easily. It even has an RDP function. Very good indeed.
How to use the yt-dlp script to download the subtitles file from a Youtube video. This would be a very useful Youtube trick.
How to mount a directory and access the files as your normal Linux user easily, this is a very useful networking tip when using a Linux server on a LAN.
The Cowsay program is very useful for printing information in your terminal. There are quite a few cow files allowing many useful avatars to print in your terminal. Install this today. jason@Yog-Sothoth » ~ » $ sudo apt install cowsay Then run this command to list all the available *.cow files. jason@Yog-Sothoth » ~ » … Read more
Print some artwork to your terminal with these cool commands. These are excellent ASCII artwork samples that could be very nice to have in your terminal. wget -qO- git.io/burger Here is the output of that one-liner. It looks awesome when printed in the terminal. wget -qO- http://git.io/coffee">git.io/coffee wget -qO- http://git.io/ff5boss">git.io/ff5boss wget -qO- http://git.io/nier2b">git.io/nier2b … Read more
Getting information about how much disk space your Linux installation is taking up is very easy. The du command can print disk usage. This example is used on my WSL2 Kali Linux installation. ┌──(john㉿DESKTOP-PF01IEE)-[~] └─$ sudo du -hl –exclude=/{proc,sys,dev,run,mnt} / | awk ‘END {print $1 " Space used on " $2}’ 6.5G Space used on … Read more
How to download a TikTok video using the command line on Linux. This is very easy to do.
If you executed a command on Ubuntu and messed up your system, there is hope. The apt-file utility can search the package repositories for the missing file and then tell you which package contains it. This is a good way to replace a system file that was accidentally deleted. This is impressive, and a good … Read more
It is possible to list interfaces with Nmap. This is a good way to see all active network devices attached to your computer. Use the –iflist parameter as shown below to show all network interfaces on your machine. jason@jason-Lenovo-H50-55:~$ nmap –iflist Starting Nmap 7.80 ( https://nmap.org ) at 2022-03-18 10:38 AEDT ************************INTERFACES************************ DEV (SHORT) IP/MASK … Read more
The new RISC-V DevTerm is a minicomputer that would be great for programming on the move. Does this machine have an open-source, RISC-V CPU in a regular computer? Yes, it does. This is a machine using the RISC instruction set and not Intel x86. This looks very retro and awesome at the same time. The … Read more
Windows 11 has a very useful feature, the Windows 11 virtual desktop. This allows a user to create virtual desktops and have different applications open on each one. To use this, the shortcuts are listed below. Windows+Tab: Open Task View. Windows+Ctrl+D: Create a new virtual desktop. Windows+Ctrl+Left or Right Arrow: Switch between virtual desktops. Windows+Ctrl+F4: … Read more
Downloading a Youtube video is very useful for archiving interesting videos. But you can also download the Youtube video with metadata as well. The example below will download a Youtube video and the metadata as a json file. This is a great one-liner. yt-dlp –embed-subs –embed-thumbnail –embed-metadata –output "%(uploader)s/%(title)s [%(id)s].%(ext)s" https://www.youtube.com/watch?v=VlvwDLGArzkyt-dlp –embed-subs –embed-thumbnail –embed-metadata –output … Read more
This is a very useful site to monitor radio stations in and around Russia on multi-band radio. http://websdr.78dx.ru:8901/. This is very good if you are Russian and are an ex-pat wanting to keep track of what is actually happening around Russia in this stressful time. it can monitor AM and USB as well as SSB. … Read more
This website will crack Cisco 7 passwords instantly. http://www.ibeast.com/content/tools/ciscopassword/. This shows that this type of “encryption” is useless when an attacker has access to view the configuration of the switch. Better to use more stringent encryption like 4096 bit. But this is the way that Cisco work. If you get access to a Cisco switch … Read more
Adding a new user on Linux is very easy, this can be done with the groupadd and useradd commands. I am adding a new user group to Linux and then adding the new user to it. Firstly, add the new user group. jason@jason-Lenovo-H50-55:~$ sudo groupadd -g 1001 cudauserjason@jason-Lenovo-H50-55:~$ sudo groupadd -g 1001 cudauser Then we … Read more