LinuxQuestions.org - Change the password for phpMyAdmin on Ubuntu

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- :)