After you setup Cpanel, you have to do few things to secure MySQL on Cpanel server.
1. Delete the test database
This can be done with command
mysqladmin drop test
2. Change MySQL root Password
This can be done through WHM, login to WHM as root
WHM > SQL Services > MySQL Root Password
WHM > SQL Services > Reset Local MySQL Root Password
3. Disable MySQL login with out user and Password
By default mysql allow login to MySQL without entering user name or password.
To disable this, delete the empty user, this can be done with phpMyAdmin
WHM > SQL Services > phpMyAdmin
Select database “mysql”, browse the table “users”, in this you will see a user with no user name, just delete it, after doing this MySQL will now allow login with out user name and password.
On Cpanel Servers, you can just enter mysql to login as root, this is because, /root/.my.cnf contains user name and password.
user = root
password = password