First of all for wampserver this software, is very aspect!
In the use of it will involve the MySQL data management system related to the password modification, this course is very simple modification, then did not think so much, want to add a password for their MySQL, the way is as follows:
Method 1: Use the Set password command
Mysql-u Root
mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');
Method 2: Use Mysqladmin
mysqladmin-u root Password "Newpass"
If Root has already set a password, use the following method
mysqladmin-u root password Oldpass "Newpass"
Method 3: Edit the user table directly with update
Mysql-u Root
mysql> use MySQL;
mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';
mysql> FLUSH privileges;
This can be done when the root password is lost
Mysqld_safe--skip-grant-tables&
Mysql-u Root MySQL
mysql> UPDATE user SET Password=password ("New password") WHERE user= ' root ';
mysql> FLUSH privileges;
After the modification, found to log localhost/phpmyadmin/again, many times will report the following error:
Description login is required password, and here the password is not configured, the configuration file is:
config.inc.php, you can configure the password that is the password you set.
Save the forced Reload page as you like.
In this configuration file, we will see a configuration like this:
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
Perhaps a lot of people's configuration is: $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
This time there must be:
$cfg [' Servers '] [$i] [' user '] = ' root ';
$cfg [' Servers '] [$i] [' password '] = ' root '; these two configurations, because they are the supporting configuration, indispensable;
About: $cfg [' Servers '] [$i] [' auth_type '] This configuration, represented by the means of authentication,
There are four modes to choose from, Cookie,http,http,config
The Config method is to enter the phpMyAdmin access URL directly, do not need to enter the user name and password (because you have configured the default user name and password in the file), is not safe, is not recommended to use.
When the key is set to Cookie,http or HTTP, the login phpMyAdmin needs to enter a username and password for authentication.
Specific use of which authentication method, the specific choice according to the following:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode for CGI, you can use cookies;
In view of the above, I personally recommend the use of cookie mode, so not afraid of the existence of changes to the MySQL database password, not phpmyadmin the situation, and more secure;
Extension: For some time, we modify the relevant configuration to refresh the page, we find that the same error is reported, it is recommended to force the refresh, that is: Ctrl+f5 refresh,
Forced to refresh, directly to the server to re-download, the server's response to the same as the first request, not to read the page in the cache, but directly to get the latest data resources, so as to eliminate the problems caused by the cache, and really detect the correct configuration.
About: In the browser address bar press ENTER, F5, ctrl+f5 refresh the difference between the page, the evening such a lot of explanations, suggestions do not understand which other friends to search.
Wampserver phpMyAdmin Login Error handling method after modifying MySQL password