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
Check MySQL Version Read More »
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
Monitor MySQL DB Activity Read More »
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 »