Linux How-Tos

MySQL Collation & Case Sensitivity or Insensitivity

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 »

MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB

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 »

Linux Kernel – Check Installed and Switch Boot Kernel

See Installed Kernels In Debian & Ubuntu, we can see the installed kernels with: % dpkg –list | grep linux-image ii linux-image-3.16.0-4-amd64 3.16.51-3 amd64 Linux 3.16 for 64-bit PCs ii linux-image-3.16.0-6-amd64 3.16.56-1+deb8u1 amd64 Linux 3.16 for 64-bit PCs ii linux-image-4.9.0-11-amd64 4.9.189-3 amd64 Linux 4.9 for 64-bit PCs ii linux-image-amd64 In Fedora / CentOS / RedHat …

Linux Kernel – Check Installed and Switch Boot Kernel Read More »