is that phpmyadmin root login is for root MySQL database user
in this case you can change root name to any name instead of root
w/o change any privileges for root
after that root login no longer exist, about what will happen to your application eg, forum etc etc.
i sure there none of your database user use root to connect
if it happen you can simply revert back. and about security nobody know
what is root user except you the only one
follow this step
root login to mysql
Code:
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
go to mysql db
Code:
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
replace root user from user root to user dbaroot
or what ever you named it
Code:
mysql> update user set user="dbaroot" where user="root";
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
exit then now try login back
Code:
# mysql -u dbaroot -p
Enter password:
then test with your phpmyadmin,
end-