phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045):
Access denied for user 'pma'@'localhost' (using password: NO)

In this short blog post, I have shown you how to fix Access denied for user 'pma'@'localhost' (using password: NO) on Windows 10 Operating System. 
Below I have given the practical video to solve this problem easily. I hope you fix your issue.

 Error

 

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
 mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
 Connection for controluser as defined in your configuration failed.
 mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Retry to connect

How to fix Access denied for user 'pma'@'localhost' (using password: NO)


Step1. Go to Xampp Control Panel.

Step2. Now select Config Tab of Apache Service and then do right click.

Step3. Now click on phpMyadmin(config.inc.php)

Step4. After that search the below line and Enter the password.

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'Enter password as "root"';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'Enter you_password here';

Step5. Save and exit.

Step6. Now start the Apache service and check the error.
 
 



Conclusion

Hey you have successfully fixed the mysqli::real_connect(): (hy000/1045): access denied for user 'root'@'localhost' (using password: no) error.

Please let me know if you are facing any issue in the comment box. We will happy to assist you.

Comments

Post a Comment

Popular posts from this blog

Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno

Image
Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno When I successfully Installed latest Anydesk on my local Ubuntu 22.04 Jammy Jellyfish system. And tried to run the Anydesk application, it doesn't launch/start. when I checked the status service, the anydesk service was failed. And got the below error message Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno Error is looks like /usr/bin/anydesk: error while loading shared libraries: libpangox-1.0.so.0: cannot open shared object file: No such file or directory anydesk.service: Failed with result 'exit-code'. libpangox-1.0.so.0 is a library used for text layout and rendering the text. Most of the work on Pango-1.0 was done using the GTK+ widget toolkit as a test platform. Basically what I have done is just installed libpangox library which is used by Anydesk service to launch. Also Read: * Install Anydesk on Ubuntu 22.04 LTS Jammy Jellyfish How to...
Read more

Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.

Image
Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.  Hey readers, In this post  we will share you how to fix " Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. Please check the TLS version settings in the Advanced of the Internet options:- (5029) " error that comes in windows 10 or windows 7 while connecting to VPN. This error generally happens because of the TLS mismatch in the windows machine or client machine. Read Also:-  How to Download and install Windows 11 on Virtual Box | VMware | Laptop Download, install and activate Microsoft Office 2019 for FREE legally How to Download Windows 11 ISO file [Direct Google Drive link] 2021   How to Fix Forticlient TLS 'error 5029': failed to establish the VPN connection ? Step1. Go to Internet Explorer. Step2. Now search for setting and  then select internet option/properties. OR Open run box and type "inetcpl.cpl" Step3. Select...
Read more

To make SSL VPN connection work, please turn off IE security configuration | vetechno

Image
turn off internet explorer enhanced security configuration server 2019   Hello reader, if you are installing and configuring SSL Forticlient VPN on Windows Server 2019, you might got a warning message saying that " To make SSL VPN connection work, please turn off IE security configuration " on Windows server 2019. In this blog, we will fix the warning message and configure the SSL Forticlient VPN on Windows Server 2019. Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. How do you turn off Internet Explorer Enhanced Security Configuration is enabled? If Internet Explorer Enhanced Security Configuration (IE ESC) is turned on, you will receive an error message to disable this setting before you can log on Application. To avoid this problem, follow the below simple steps. To turn off Internet Explorer Enhanced Security Configuration: Step 1. Enter Server Manager in Windows search to start Server manager application. Step 2. Select Lo...
Read more