Home  >  Article  >  Backend Development  >  Use phpmyadmin to change mysql5.0 login password_PHP tutorial

Use phpmyadmin to change mysql5.0 login password_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 15:53:37693browse

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