I have a root user in mysql-server on the Ubuntu server. I am unable to login to phpmyadmin with the root user and password. I was trying to find the configuration file but could not locate it. Help would be appreciated.

Thanks in advance

  • Did you ever find the answer to this problem? I'm having problems myself as well.
    – chrisjlee
    Oct 10, 2011 at 2:03

10 Answers 10


You have to reconfigure phpmyadmin, reset MySQL password.

  1. Reconfigure phpmyadmin
  2. Ctrl + Alt + T to launch terminal
  3. sudo dpkg-reconfigure phpmyadmin
  4. Connection method for MySQL database for phpmyadmin: unix socket
  5. Name of the database's administrative user: root
  6. Password of the database's administrative user: mysqlsamplepassword
  7. MySQL username for phpmyadmin: root
  8. MySQL database name for phpmyadmin: phpmyadmin
  9. Web server to reconfigure automatically: apache2
  10. ERROR 1045
  11. ignore
  12. sudo dpkg-reconfigure mysql-server-5.5
  13. New password for the MySQL "root" user: mysqlsamplepassword
  14. Repeat password for the MySQL "root" user: mysqlsamplepassword

Wish it helps!

Have a nice day!

  • After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
    – Jostino
    Apr 13, 2018 at 0:20

I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.

mysql -u root -p

Entered the root password Created a new user using the following command:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';

Granted all permissions to newuser:

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.

  • I had the same problem with my Raspberry Pi. I was about to complain that it was giving me the same access denied error when I remembered sudo. Thank you for this shorter workaround
    – dmeehan
    Mar 6, 2020 at 22:39

To log in as root in phpmyadmin:

echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p

Found at the end of this tutorial

Worked for me :)

  • Thank you for actually posting the answer to this question, unlike the other replies.
    – cantsay
    Dec 28, 2019 at 21:30
  • sudo bash before the above stuff for some ubuntu based distros ;)
    – Eric
    Feb 22, 2020 at 3:12
  • this is the ONLY solution that worked for me. i tried everything, this is the only. THANKS! Sep 3, 2021 at 8:05

By "rootuser" you mean the MySQL root user, not the system root user, right?

During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.

The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.

  • Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
    – user14010
    Apr 10, 2011 at 19:30
  • @user14010: Does the command-line mysql version work? E.g. mysql -hlocalhost -uroot -p ?
    – Lekensteyn
    Apr 10, 2011 at 20:57
  • Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
    – user14010
    Apr 10, 2011 at 21:11
  • @user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
    – Lekensteyn
    Apr 11, 2011 at 12:50
  • I had to use debian-sys-maint user to login in phpmyadmin, for some reason mysql root user cannot login in phpmyadmin. debian-sys-maint has the rights to create databases, create users, grant privileges, etc., so it can be used for administrative tasks. debian-sys-maint credentials are generated automatically when installing mysql-server and are saved in /etc/mysql/debian.cnf. Mar 30, 2019 at 10:13

I installed MySQL using synaptic manager. Didn't have to enter a root password. The command:

mysqladmin -u root password NEWPASSWORD

worked. I was able to login into PhpMyAdmin immediately.


Might for some reason the AllowRoot option be set to False? See the documentation.


I recently came across a very similar issue with 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.


I believe the first is the debian local config file, which will override the usr version.


well , hello first download the phpmyadmin from here : https://www.phpmyadmin.net/downloads/

then extract the downloaded (rar,zip) to : {INSTILLATION_PATH }\laragon\etc\apps rename the folder to phpmyadmin .

now go to http://localhost/phpmyadmin

and your there :) .

if you want to login to the phpmyadmin you need to search in the phpmyadmin folder for a file called config.sample.inc and duplicate it and rename it to config.inc open the file and search for : $cfg['Servers'][$i]['AllowNoPassword'] = false; and set it to true : $cfg['Servers'][$i]['AllowNoPassword'] = true; save the file and DONE you can login using username of : root


It seemed logical to me to keep things at the simplest level possible:

mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;

Thus phpmyadmin user which was created during the installation manages everything, including create databases.


Me too,

echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p

This is good

  • 1
    Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation) Jan 15, 2019 at 15:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.