Create a root password for PHPMyAdmin

phpmyadmin
Daniel Montenegro picture Daniel Montenegro · Sep 1, 2012 · Viewed 389.6k times · Source

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

So, how can I create one?

Answer

flowfree picture flowfree · Sep 1, 2012

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.

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
PHPMyAdmin Default login password

I have done a fresh installation of Fedora 14 and installed the phpMyAdmin module. When I run phpMyAdmin, it asks me for a username and password. What is the default username and password for phpMyAdmin?

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More