If your Macbook gets stuck at the Black Screen of Death (BSOD), you can try this “magical” key combination to attempt to recover. This key combo resets the PRAM and NVRAM on the machine, which store basic things like volume, screen resolution & timezone. Doing this should not cause any loss of your own data …
Macbook Black Screen (BSOD) Recovery Key Combination – Resetting PRAM & NVRAM Read More »
Every once in a while, you may find that the file system you are using is full. Usually this will manifest with a message like: No space left on device When this happens, check if the file system is under Logical Volume Management or LVM. You can do this a number of ways, but a …
Resizing LVM Volumes & File Systems in Linux Via SSH Read More »
We can use the usermod command to add a user to a group. Here I am going to add the user grokman to the group adm: root@myserver:~# sudo usermod -aG adm grokman root@myserver:~# exit Connection to myserver closed. root@myserver:~# ssh myserver Welcome to … root@myserver:~# groups admin adm sudo www-data In Debian / Ubuntu, the …
When using MySQL (or most any DB really), it’s a good idea to understand about collation: the implications, the defaults, and how to change it. Collation determines how data is sorted and compared in the database. Its essentially a set of rules for the DB to follow when making decisions on said sort and comparison. …
MySQL Collation & Case Sensitivity or Insensitivity Read More »
The The MySQL Command-Line Client will show the version as soon as you successfully enter it: admin@server:~$ sudo mysql -u admin -p [sudo] password for admin: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 70589 Server version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu) If you are already in the …
One way to monitor DB activity in MySQL is to enable logging and then tail the log file. mysql -u root -p You can check the status of logging and get the path of the log file with: SHOW VARIABLES LIKE “general_log%”; And then enable logging with: SET GLOBAL general_log = ‘ON’; Finally, tail the …
On some platform / shell combos, you may find Git has gone hog-wild with the paging. I.e., you may find it pages things like logs & diffs when there is not even a single page of information in the first place. In this situation, I have found the following Git global config can resolve the …
In Python, we can use the random library to get a random number like so: from random import * x = randint(1, 100) print(x) or maybe you only want an odd number: from random import * x = randrange(1, 100, 2) print(x) But what if you want an infinite stream of random odd numbers available …
Infinite random number generator expressions in Python Read More »
To login to MySQL / MariaDB as the root user, you will need sudoers perms and then you can issue the following command: /home/grokman grokman@li598-26% sudo mysql -u root -p So, it should go something like this:
In order to list all the configured DB users in a MySQL or MariaDB, you must be logged in as an administrator: /home/grokman grokman@li598-26% sudo mysql -u root -p Then you can issue the command to list all the DB users: select user, Super_priv from mysql.user; So, it should go something like this: Other user …
MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB Read More »