phpmyadmin Question posted in
The official documentation can be found here.

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

the error messages

I am doing an online course from coursera where they tolm me to install phpmyadmin.

NOW I am a total beginner in this thing so I am not able to do much research upon that and now somehow, after I installed MySQL and phpmyadmin, in the localhost, I am getting some errors, is that common? Because the other participants in the course are not getting them. If that’s fatal or will limit some of my obvious abilities, please tell me how to cure it.

BTW If you didn’t noticed the errors are:

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

and

Connection for controluser as defined in your configuration failed.

Some more details:

  1. PHP version is 7.4
  2. Operating System is Ubuntu 20.04
Tags:

4

Answers


  1. 0

    I was using MaridDb solved this issue with the following:

    sudo systemctl stop mariadb
sudo mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root

    You will see a prompt like below:

    Type help; or h for help. Type c to clear the current input statement.

    MariaDB [(none)]> FLUSH PRIVILEGES;

    For MySQL 5.7.6 and newer as well as MariaDB 10.1.20 and newer

    ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

    OR:

    For MySQL 5.7.5 and older as well as MariaDB 10.1.20

    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
    Login or Signup to reply.
  2. 0

    I had a similar issue with mysql 8.0.22 and Ubunutu 20.04.3lts after installation despite setting up the phpmyadmin user during the installation it wouldn’t let me in with the password I set.

    I solved it by logging in at the command line using

    sudo mysql

    Then changed the password by the below and I could then log in

    ALTER USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'new-password-here';
    Login or Signup to reply.
  3. 0

    I’ve just installed LAMP on a new PC, and got the same problem.
    Linux Mint 20 + MariaDB.
    Password for root and phpmyadmin was already ok, but the error was still there.

    Finally I discovered another configuration file, that sets the phpmyadmin password; you have to edit it:

    $ sudo nano /etc/dbconfig-common/phpmyadmin.conf

    set the correct password (= dbc_dbpass) for user dbc_dbuser='phpmyadmin'
    Use ctrl-O to save, then ctrl-X to exit. Then launch the command:

    $ sudo dpkg-reconfigure phpmyadmin

    (Do NOT reinstall the DB).
    In my PC il works!

    Login or Signup to reply.
  4. 0

    I had the same problem by changing the password of the root user and the problem was solved by changing the content of the config.inc.php file inside the xamppphpMyAdmin folder.
    Open the file with Notepad, then enter the defined password in front of the password field and that’s it

    Error image
    —The part where the password must be entered

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search