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...
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn