Use phpmyadmin to change mysql5.0 login password_PHP tutorial

WBOY
Release: 2016-07-21 15:53:37
Original
738 people have browsed it

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...
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template