Access Denied for user 'root'@'localhost' phpMyAdmin

Websolutionstuff | Jul-28-2023 | Categories : Other

phpMyAdmin is a valuable web-based tool for managing MySQL databases, simplifying various database tasks. However, running into the frustrating "Access Denied" error for the user 'root'@'localhost' can hinder your progress.

In this article, we'll delve into the causes behind this error and provide practical solutions to overcome it. Whether you're encountering the 'root'@'localhost' access denied issue on Ubuntu or XAMPP, we've got you covered.

When attempting to log in as the root user, you might find yourself locked out of phpMyAdmin, especially when using MySQL 5.7.26 on Ubuntu versions like 18.04, Ubuntu 20.04, or Ubuntu 22.04. The error message you'll encounter is the same

Mysqli_real_connect(): Access denied for user ‘root’@‘localhost’

access_denied_for_user_error

This issue arises from the fact that the Plugin for the root user is auth_socket.

To see this status enter MySQL by

sudo mysql -u root -p

After that, run the following command.

mysql>  SELECT User, Host, plugin FROM mysql.user;

You will see:

mysql-users-list

To fix this issue use this command:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_ROOT_PASSWORD';

Note: YOUR_ROOT_PASSWORD’ which must be your root password.

The status must be finally the same as:

set_mysql_root_password

And again try to log in phpMyAdmin via the root user and your password.

http://example.com/phpmyadmin
or
http://127.0.0.1/phpmyadmin

 


You might also like:

Recommended Post
Featured Post
Reseller Hosting Myths to Know and Unfollow
Reseller Hosting Myths to Know...

If you work in the web hosting sector, you're probably acquainted with the term reseller hosting. Resellers make up...

Read More

Apr-07-2022

Laravel 8 cURL HTTP Request Example
Laravel 8 cURL HTTP Request Ex...

Hello Friends, Today we will see how to make cURL HTTPs request in your laravel 8 application. This tu...

Read More

Apr-28-2021

Laravel 9 Multiple Authentication Using Middleware
Laravel 9 Multiple Authenticat...

In this article, we will see laravel 9 multiple authentications using middleware. Using middleware we authenticate the u...

Read More

Apr-13-2022

How to install TeamViewer in Ubuntu 22.04
How to install TeamViewer in U...

Hey there, Ubuntu users! If you've ever needed a hand troubleshooting your friend's computer from the comfort of...

Read More

Jan-17-2024