Home > Backend Development > PHP Tutorial > How to Resolve Access Denied Error for \'root\' User in phpMyAdmin?

How to Resolve Access Denied Error for \'root\' User in phpMyAdmin?

Barbara Streisand
Release: 2024-10-19 10:33:29
Original
1069 people have browsed it

How to Resolve Access Denied Error for 'root' User in phpMyAdmin?

Resolving Access Denial Error for 'root' User in phpMyAdmin

In phpMyAdmin, when attempting to connect using the 'localhost' host and 'root' user, you encounter an access denied error. Despite changing the user's password back to blank or modifying the config.inc.php file to no avail, the issue persists.

To rectify this, locate the config.inc file within the path C:wampappsphpmyadmin3.5.1. Within this file, search for the following line:

$cfg['Servers'][$i]['password'] =";
Copy after login

Replace this line with the following, ensuring to replace 'Type your root password here' with your actual root password:

$cfg['Servers'][$i]['password'] = 'Type your root password here';
Copy after login

Once this modification is complete, you should be able to access phpMyAdmin with the root user and 'localhost' host without facing the access denied error.

The above is the detailed content of How to Resolve Access Denied Error for \'root\' User in phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!

source:php
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template