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
How To Check Image Blur Or Not Using Python
How To Check Image Blur Or Not...

In this article, we will see how to check image blur or not using python. For blur image check we are using the OpenCV p...

Read More

May-13-2022

Laravel 9 Toastr Notifications Example
Laravel 9 Toastr Notifications...

In this tutorial, I will show you laravel 9 toastr notifications example. Using toastr.js you can display a success...

Read More

Feb-23-2022

Laravel 8 Import Export CSV/EXCEL File Example
Laravel 8 Import Export CSV/EX...

In this article, we will see the laravel 8 import and export CSV/EXCEL file example. We will simple create imp...

Read More

Oct-01-2020

Jquery Search Filter Example
Jquery Search Filter Example

In this small post i will so you jquery search filter example. here we will see how to search data using jquery filter....

Read More

Aug-25-2021