update mysql.user set password=old_password('new password') where user='username'
Note that this old_password (MYSQL function) will encrypt the password into 16 digits, and cannot use
password ( ) this function, otherwise it will be encrypted to 40 bits.
Then modify PHPMYADMIN
Copy the code The code is as follows:
$cfg['Servers'][$ i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; / / MySQL user Immediately
put my program in, and then make a blog for Dabin
OK, it’s time to get the VIRTUAL HOST tomorrow
.
http://www.bkjia.com/PHPjc/318633.html
www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/318633.htmlTechArticleupdatemysql.usersetpassword=old_password('new password')whereuser='username' Note this old_password (MYSQL function) In this way, the password is encrypted into 16 digits, and password() cannot be used...