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

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

How to install Mysql 8.0.29 on Ubuntu 22.04 LTS | vetechno

Image
How to install Mysql 8.0.29 on Ubuntu 22.04 LTS Hey reader, In this tutorial we are going to install mysql 8.0.29, which is the latest version of mysql community.  MySQL is an open-source database management system and free to use. It is commonly installed as part of the most popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack and LEMP (Linux, Nginx, MySQL, PHP) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. It is the most common software stack that comes up with dynamic websites and web applications. Prerequisites:- * Need root user access. * Internet * MySQL 8.0 packages. * Ubuntu 22.04/20.04/18.04 LTS  Also read  How to install Mysql 8.0.28 on Ubuntu 22.04 LTS   How to install MySQL 5.5 on Ubuntu 20.04 LTS    Install mysql 5.6 ubuntu 20.04 LTS    Install Mysql 8.0.29 on Ubuntu 22.04 LTS Jammy Jellyfish. Step1. First we need to add this below MySQL repository to our Ubuntu 22.04 system’s package in sources list; start by downloa
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