Create a root password for PHPMyAdmin

89

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 phpmyadmin

~ Asked on 2012-09-01 02:29:21

The Best Answer is


142

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.

~ Answered on 2012-09-01 02:40:22


40

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.

enter image description here

Click on root > Edit privileges

enter image description here

Then click on Change password

enter image description here

Enter your desired password -> Go

enter image description here

Logout and log-in again with new password

~ Answered on 2017-02-07 14:45:47


Most Viewed Questions: