PHPMyAdmin and MySQL server complement each other very well. In most situations you have installed mysql server and phpmyadmin.
By default the mysql root password is blank and this is a big security issue and you have change the mysql password as soon as possible. If that is not done anybody could login with phpmyadmin with username root and password blank. You also must avoid to login phpmyadmin with mysql root password. Instead you must create a new user (to phpmyadmin) with same privileges as mysql root.
First change the mysql root password
mysql > update user set password=password('XXXXX') where user='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql > FLUSH PRIVILEGES;
Thats all! you have changed your mysql root password. All you have to do is login to phpmyadmin with username as root and password as new password.
Create a new phpmyadmin user
Now we will create a new administrator login (say sysadmin) for phpmyadmin which will have same privileges as mysql root.
Its just one line command;
mysql> GRANT ALL ON *.* TO 'sysadmin'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
then
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Now you can login to phpmyadmin as new administrator and avoid using root logins. You can create databases, change or insert or edit tables or do whatever you want!
