Question 63644 in PhpMyAdmin Question posted in
The official documentation can be found here.

Phpmyadmin. mysqli_real_connect(): (HY000/2002): Permission denied. Connection for controluser as defined in your configuration failed

I have setup my wsl environment, successfully installed Apache, mysql, and php.
I can access mysql in my command line, only by using "sudo -u root -p"

I can’t login to phpmyadmin,even with using the correct username and password.
I’ve attached picture below to give a clear picture.

phpmyadmin website error

ubuntu command line error

Tags:

3

Answers


  1. 0

    In File /etc/phpmyadmin/config-db.php

    change

    $dbserver=’localhost’;

    to

    $dbserver=’127.0.0.1′;

    Restart Apache2 😉

    Login or Signup to reply.
  2. 0

    I was facing the same problem. I’m using ubuntu 20.04 using wsl. Created the lamp server with php7.3. Created new user with full privilege’s. From root & from other user, getting the same error.

    But I got the solution:
    Now first we need to install Selinux. Here are the commands:

    Step 1 – Install Selinux:

    sudo apt install policycoreutils selinux-utils selinux-basics

    Step 2 – Activate:

    sudo selinux-activate

    Step 3 – Activate httpd_can_network_connect_db 1:

    By default, the policy httpd_can_network_connect_db is disabled (meaning that your web server cannot contact a remote DB.)
    Check this via:

    getsebool -a | grep httpd

    If httpd_can_network_connect_db is Off, enable it via:

    setsebool -P httpd_can_network_connect_db 1

    Step 4 – Maybe need to change:
    change localhost to 127.0.0.1 in /etc/phpmyadmin/config.inc.php

    $cfg['Servers'][$i]['host'] = '127.0.0.1';

    Step 6 – Restart mysql & apache:

    sudo service mysql start
sudi service apache2 start.
    Login or Signup to reply.
  3. 0

    In /etc/phpmyadmin/config.inc.php, simply uncomment line $cfg[‘Servers’][$i][‘host’] = ‘localhost’;

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

Back To Top
Search