Modify MySQL and pureftpd passwords

"1" Modify the password of the MySQL user

The first step:

syntax for changing passwords before ①mysql5.7

Update Mysql.user set Password=password (' 123 ') where user= ' root ' and Host = ' localhost ';

The syntax for changing passwords after ②mysql5.7,

Update Mysql.user set Authentication_string=password (' 123qwe ') where user= ' root ' and Host = ' localhost ';

5.7 Before using the password field to store the password, 5.7 use the Authentication_string field to store the password

Step Two:

Flush privileges;

"2" Modify pureftpd Password

principle:pureftpd the login account and password in the MySQL database, pureftpd need to read/ect/pure-ftpd/ pureftpd-mysql.conf the user name and password of the MySQL database inside the configuration file to connect to the database and obtain the login account and password in the corresponding table.

First step: If you need to modify the user and password that PUREFTPD connects to the database

① viewing the connection to a user name in the pureftpd-mysql.conf configuration file, password

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/9F/14/wKioL1mbk2HRFMpsAACVa657PSo012.png "title=" 2017-08-22_095125.png "alt=" Wkiol1mbk2hrfmpsaacva657pso012.png "/>

in the in MySQL, perform the following actions

Update Mysql.user set Authentication_string=password (' 123qwe ') where user= ' pureftpd '

② Replace the value of Mysqlpassword in pureftpd-mysql.conf with a modified password

Step Two: Modify pureftpd login name and password, from the above figure can be seen,ftp is from the PUREFTPD database ftpd Read the password for the corresponding login name in the table

in the in MySQL, perform the following actions

Update pureftpd.ftpd set PASSWORD=MD5 (' 123 ') where user= ' pureftpd ';

Note: From the configuration file, the Mysqlcrypt field can see that the MD5 encryption algorithm is used, so the MD5 () function must be encrypted, not using password () function Encryption

This article is from the "Technology" blog, so be sure to keep this source http://hywds.blog.51cto.com/13158032/1958246

Modify MySQL and pureftpd passwords