Phpmyadmin. mysqli_real_connect(): (HY000/2002): Permission denied.
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.
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.
source : https://stackoverflow.com/questions/73502070/phpmyadmin-mysqli-real-connect-hy000-2002-permission-denied-connection-f