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

Error Analysis and Background

When deploying phpMyAdmin in XAMPP integrated environments, developers frequently encounter MySQL connection error 1045, specifically manifested as: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO). The core issue of this error lies in improper configuration of phpMyAdmin's advanced features control user.

Root Cause Analysis

From the provided configuration file, the problem primarily occurs in the following configuration section:

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

This configures a control user named 'pma' with an empty password. However, this user account does not exist in the MySQL server, or the user lacks appropriate access permissions, resulting in connection refusal.

Solution Implementation

To resolve this issue, action is required at two levels: MySQL user management and phpMyAdmin configuration adjustment.

MySQL User Creation

First, create the corresponding control user in MySQL. This can be done through the MySQL command-line tool by executing the following operations:

CREATE USER 'pma'@'localhost' IDENTIFIED BY 'your_password_here';
GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost';
FLUSH PRIVILEGES;

This creates a local user 'pma' and grants all privileges on the phpmyadmin database. The password should be set to a strong password to ensure security.

Configuration File Modification

In the config.inc.php file, update the control user configuration information:

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'your_password_here';

Ensure the password exactly matches the user password set in MySQL. For XAMPP environments, the configuration file is typically located at xampp\phpMyAdmin\config.inc.php.

Configuration Verification and Testing

After completing the above configuration, restart the MySQL service to make the changes effective. Verify the configuration correctness through the following steps:

1. Restart the MySQL service in XAMPP
2. Re-access the phpMyAdmin interface
3. Check if connection errors still occur
4. Verify whether advanced features (such as relation view, bookmarks, etc.) work properly

Security Considerations

During the configuration process, pay attention to the following security considerations:

• Avoid using empty or weak passwords
• Regularly update passwords
• Limit the permission scope of control users
• Consider using more secure authentication methods in production environments

Alternative Solutions Discussion

Besides creating dedicated control users, other solutions can be considered:

• Using existing root users as control users (security considerations required)
• Checking if MySQL port configuration is correct
• Verifying if MySQL service is running normally
• Checking if firewall settings block connections

Conclusion

phpMyAdmin's 1045 connection error typically originates from control user configuration issues. By properly creating MySQL users and synchronously updating phpMyAdmin configuration files, this problem can be effectively resolved. In practical operations, it's recommended to follow the principle of least privilege, ensuring system security while meeting functional requirements.