Shulou(Shulou.com)05/31 Report--

Editor to share with you the solution to the denial of phpMyAdmin access, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's learn about it!

1. Environment:

XAMPP + PhpStorm

2. PhpMyAdmin configuration file path:

/ Applications/XAMPP/xamppfiles/phpmyadmin/libraries/config.default.php

3. The cause of the problem:

When the terminal enters the mysql command line mode for the first time, it is prompted to set the password, and access to phpMyAdmin is denied in the browser after setting.

4. Solution: (clear password)

(1) enter mysql terminal command mode:

/ Applications/XAMPP/xamppfiles/bin/mysql-u root-p

Enter your password and press enter. Enter mysql command mode

(2) clear the password:

> SET PASSWORD = PASSWORD ('')

(my version is shown in the picture. Another modification method mentioned elsewhere on the Internet does not work for my version. If my method here does not work for you, you can try this one: > UPDATE mysql.user SET authentication_string=PASSWORD (') WHERE User='root'; other steps are the same.)

(3) refresh permissions to make the configuration effective

> FLUSH PRIVILEGES

(4) exit mysql command mode:

> exit

(5) close mysqld

$sudo / Applications/XAMPP/xamppfiles/bin/mysqladmin-u root-p shutdown

As the password is cleared in (2), you can enter directly at the place where you are prompted to enter the password. Without any output, the shutdown is successful.

(6) repeat step (1) to test whether the password is cleared:

$/ Applications/XAMPP/xamppfiles/bin/mysql-u root-p

Enter directly, if prompted by Welcome to the. The password is cleared successfully.

Start the mysql server (I'm using XAMPP), as shown in figure 1:

(7) enter: localhost/phpmyadmin in the browser to access it successfully.

The above is all the contents of the article "phpMyAdmin access denied solution". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.