Login to MySQL
mysql -u root -p
Show Active processes
or to list all the processes use “FULL”
SHOW FULL PROCESSLIST;
Run MySQL optimizer
MySQL tuner should give some recommendations on settings to tweak.
First you’ll need a group that all your disabled clients are going to.
Next add the following lines to the user file “/etc/raddb/users”. Change SQL-Group to Group if your groups are not in a SQL database.
DEFAULT SQL-Group == "disabled", Auth-Type := Reject
Reply-Message = "Your account has been disabled."
Save, exit and test.
This should keep all clients in the disabled group from authorizing.
It looks like MariaDB replaces MySQL on CentOS 7 and Fedora so to install the Server and client install the following two packages.
yum install mariadb mariadb-server
or for Fedora
dnf install mariadb mariadb-server