Method one
Uses phpmyadmin, this was the simple, revised mysql the storehouse the user table, but do not forget to use the PASSWORD function.
Method two
Uses mysqladmin, this is an exceptional case which front stated.
mysqladmin - u root - p password mypasswd
After inputting this order, needs to input root the original password, then the root password will change mypasswd.
Changes your user order in root, you might change your password.
Certainly if your mysqladmin connection not on mysql server, or you do not have the means to carry out mysqladmin, then this method is invalid, moreover mysqladmin is unable clear the password spatial.
The following method uses under the mysql prompt symbol, and must have the mysql root jurisdiction:
Method three
mysql> Insert INTO mysql.user (Host, User, Password)
VALUES ('%', 'jeffrey', PASSWORD ('biscuit'));
mysql> FLUSH PRIVILEGES
Exactly said that this is increasing a user, user named jeffrey, the password is biscuit. In has this example in "mysql Chinese Reference manual", the attention must use the PASSWORD function, then must use FLUSH PRIVILEGES.
Method four
Three are the same with the method, has only used the REPLACE sentence
mysql> REPLACE INTO mysql.user (Host, User, Password)
VALUES ('%', 'jeffrey', PASSWORD ('biscuit'));
mysql> FLUSH PRIVILEGES
Method five
Uses SET the PASSWORD sentence
mysql> SET PASSWORD FOR jeffrey@ " % " = PASSWORD ('biscuit');
Plans also to use the PASSWORD() function, but does not need to use FLUSH PRIVILEGES.
Method six
Uses GRANT… IDENTIFIED the BY sentence
mysql> GRANT USAGE ON *.* TO jeffrey@ " % " IDENTIFIED BY 'biscuit';
Here PASSWORD() function is nonessential, also does not need to use FLUSH PRIVILEGES.
Attention: PASSWORD() [is not] by in the Unix password encryption similar method execution password encryption.
MySQL forgets the password the solution
If MySQL is moving, first kills it:
killall - TERM mysqld
Starts MySQL:
bin/safe_mysqld --skip-grant-tables &
Might not need the password to enter MySQL.
Is
>use mysql
>update user set password=password (“new_pass”) where user= " root”;
>flush privileges;
Kills MySQL, starts MySQL with the normal method.
Mysql password clear spatial
Windows
1. uses the system manager to land the system;
2. stops MySQL the service;
3. enters the order window, then enters MySQL to install the table of contents, for instance I install the table of contents am c:\mysql, enters C:\mysql\bin;
4. the jump jurisdiction inspection starts MySQL
c:\mysql\bin >mysqld-nt --skip-grant-tables
5. opens a window, enters c:\mysql\bin table of contents, establishes root the new password
c:\mysql\bin >mysqladmin - u root flush-privileges password “newpassword”
Other pages: : 1 * 2 * 3 * 4 * Next>>
|
You are here: hacking technology
> encryption decipher
> Content
Category: Home
> encryption decipher