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

Editor to share with you how to modify and reset the phpMyAdmin password of WAMP, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The following phpmyadmin tutorial column will show you how to modify and reset the phpMyAdmin password of WAMP. I hope it will be helpful to the friends who need it!

WAMP is the Apache+Mysql/MariaDB+Perl/PHP/Python under Windows, which is often used to build open source software for dynamic websites or servers.

1. Download page: there are many http://www.wampserver.com/en/ installation tutorials online, basically all of them are the next step, so I won't introduce you too much here.

two。 It starts after successful installation, and the icon shows that it starts normally in green. Displayed in yellow, the general port 80 is occupied, or MYSQL has been previously installed, there is a conflict. Because xamp has been installed before, it always displays yellow after opening it, and it can be used normally after uninstalling.

3. Change password 1: if you go to phpMyAdmin and modify it directly, you will generally succeed, but there are many unsuccessful ones that are not very reliable.

(1) Click "user" in the phpMyAdmin interface, and change the password of all users named "root" in the user profile to "password to be modified". To modify it, click "Edit permissions" and set the password.

(2) find the [config.inc.php] file under the phpmyadmin folder in the directory wamp\ apps

Modify [$cfg ['Servers'] [$I] [' password'] =']; be [$cfg ['Servers'] [$I] [' password'] = 'password to be changed';].

(3) enter the directory and open the D:/wamp/apps/phpmyadmin3.5.1/libraries/config.default.php file

Modify $cfg ['Servers'] [$I] [' password'] = 'password you modified'

Restart wampserver. At this point, the password has been changed and the service can be restarted successfully.

But many attempts are unsuccessful, and this method is not very reliable. Some people say it goes like this:

Because the password that is modified directly through the Phpmyadminmysql interface is letain encoding, and the login uses utf8 encoding, only the password is set to the user, and then you cannot log in. So when setting the password, you can only set it through the mysql command line, and you need the key command set names utf8; to set the current mode to utf8 and then update the password, and then you can log in with the password.

4. Change password 2: use the MySql console of WAMP to modify.

(1) Open the mysql console of WAMP and prompt for a password. If the start password is empty, press enter directly.

(2) enter [use mysql] and prompt [Database changed] in the console.

(3) enter [update user set password=PASSWORD ('password to be changed') where user='root';]

Baidu usually comes to this command, but it will prompt errors, password unknown and so on.

Reason: after the version is updated, password becomes authentication_string.

Solution: enter [update user set authentication_string=PASSWORD ('password to be changed') where user='root';]

At this point the console prompts [Query OK,XXXXXXXXX]

(4) enter [flush privileges] and enter

(5) enter [quit] and exit.

(6) find the [config.inc.php] file under the phpmyadmin folder in the directory wamp\ apps

Modify [$cfg ['Servers'] [$I] [' password'] =']; be [$cfg ['Servers'] [$I] [' password'] = 'password to be changed';].

5 you need to reset the password after you forget your password:

(1) add [skip-grant-tables] at the bottom of the [mysqlId] field of [my.ini] in the file D:\ wamp\ wamp64\ bin\ mysql\ mysql5.7.9 to restart the mysql service.

(2) go to the mysql console and change the password again.

(3) delete the [skip-grant-tables] added in [my.ini] after changing the password.

(4) restart the service

The above is all the contents of the article "how to change and reset the phpMyAdmin password of WAMP". 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.