PHPMyAdmin is giving me a message saying that the user (root) does not have a password.
So, how can I create one?
This question is tagged with
~ Asked on 2012-09-01 02:29:21
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
$cfg['Servers'][$i]['auth_type'] = 'cookie';
To make phpMyAdmin prompts for your MySQL username and password.
~ Answered on 2012-09-01 02:40:22
To create root password in PHPMyAdmin in UI easy way, you can follow simple steps below:
Click on root > Edit privileges
Then click on Change password
Enter your desired password -> Go
Logout and log-in again with new password
~ Answered on 2017-02-07 14:45:47