Create a root password for PHPMyAdmin

Question

PHPMyAdmin is giving me a message saying that the user (root) does not have a password.

So, how can I create one?

Answer 1

Open phpMyAdmin and select the SQL tab. Then type this command:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your_root_password'); 

Also change to this line in config.inc.php:

$cfg['Servers'][$i]['auth_type'] = 'cookie'; 

To make phpMyAdmin prompts for your MySQL username and password.

Answer 2

To create root password in PHPMyAdmin in UI easy way, you can follow simple steps below:

• Access phpMyAdmin with root account (no password) -> User accounts.

Click on root > Edit privileges

Then click on Change password

Enter your desired password -> Go

Logout and log-in again with new password