How to change root password for mysql and phpmyadmin
Solution 1
You can change the mysql root password by logging in to the database directly (mysql -h your_host -u root
) then run
SET PASSWORD FOR root@localhost = PASSWORD('yourpassword');
phpmyadmin should use that password so not quite sure what you mean by "for both".
Make sure to set the new password into phpmyadmin's config.inc.php
too, at line
$cfg['Servers'][$i]['password'] = 'yourpassword';Otherwise, phpmyadmin may not work, echoing
Access denied for user 'user'@'localhost' (using password: YES)
Solution 2
It depends on your configuration. Follow the instruction below to reconfigure phpmyadmin, and reset MySQL password.
- Ctrl + Alt + T to launch terminal
sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user:
root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
After all this run following command on terminal to secure your mysql server. sudo mysql_secure_installation
Enter current password for root (enter for none): mysqlsamplepassword
- Change the root password? [Y/n] n
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y
Wish it helps!
Have a nice day!
Solution 3
I recently came across this very same issue Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
Related videos on Youtube
Jon
Updated on September 18, 2022Comments
-
Jon almost 2 years
I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin:
Login without a password is forbidden by configuration (see AllowNoPassword)
I have previously moved the phpmyadmin folder to
/var/www/
I have tried changing the following line
$cfg['Servers'][$i]['AllowNoPassword'] = false;
to
$cfg['Servers'][$i]['AllowNoPassword'] = true;
but still had no success, so i am wondering is there a way i can change the root passwords for both so i can access phpmyadmin and create databases.
-
Jon about 12 yearsThank you, i was unsure if i had to set a password for both as i have only used WAMP in the past.
-
Hrvoje T over 7 yearsWhere can I find config.inc.php?
-
Hrvoje T over 7 yearsOk, I found it, but there is no line `$cfg['Servers'][$i]['password'] = 'yourpassword';
-
Jostino almost 7 yearsusually the config.inc.php is in /etc/phpmyadmin/config.inc.php
-
user2513149 almost 7 yearsMySQL password can be changed using
sudo mysql_secure_installation
as well. -
sig over 2 yearsyour wish has not come true here. The op failed. Even
dpkg-reconfigure mysql-server --force -p low
was of zero use. -
sig over 2 years/etc/ does carry config while /usr/ does not. But the makers of e.g. postfixadmin ignore this valuable convention, creating confusion.