Method One
Using phpMyAdmin, this is the simplest, modify the MySQL library's user table,
But don't forget to use the password function.
Method Two
Using Mysqladmin, this is a special case of the preceding declaration.
Mysqladmin-u root-p Password mypasswd
After entering this command, you need to enter the root's original password, then the root password will be changed to MYPASSWD.
Change the root of the command to your username, and you can change your own password.
Of course if your mysqladmin is not connected to MySQL server, or you have no way to execute mysqladmin,
Then this method is ineffective.
And mysqladmin can't erase the password.
The following methods are used at the MySQL prompt and must have root privileges for MySQL:
Method Three
Mysql> INSERT into Mysql.user (Host,user,password)
VALUES ('% ', ' Jeffrey ', PASSWORD (' biscuit '));
Mysql> FLUSH Privileges
Specifically, this is the addition of a user named Jeffrey, with a password of biscuit.
There is this example in the MySQL Chinese reference manual, so I wrote it out.
Note that you want to use the password function, and then you also use the flush privileges.
Method Four
As with method Three, just use the Replace statement
Mysql> REPLACE into Mysql.user (Host,user,password)
VALUES ('% ', ' Jeffrey ', PASSWORD (' biscuit '));
Mysql> FLUSH Privileges
Method Five
Using the Set Password statement,
Mysql> SET PASSWORD for jeffrey@ "%" = PASSWORD (' biscuit ');
You must also use the password () function,
However, you do not need to use flush privileges.
Method Six
Use Grant ... Identified by statement
Mysql> GRANT USAGE on * * to jeffrey@ "%" identified by ' biscuit ';
Here the password () function is unnecessary and does not require the use of flush privileges.
Note: PASSWORD () [NOT] Execute password encryption in the same way that the UNIX password is encrypted.
http://www.bkjia.com/PHPjc/318630.html www.bkjia.com true http://www.bkjia.com/PHPjc/318630.html techarticle method one uses phpMyAdmin, which is the simplest of all, modify the MySQL library's user table, but don't forget to use the password function. Method two uses mysqladmin, which is a special case of the preceding declaration. ...
