MySQL modified password method Encyclopedia:
The code is as follows |
Copy Code |
mysql> Update user Set Password=password (' NewPassword ') where user= ' root '; mysql> flush Privileges; Mysqladmin-u root-p PASSWORD mypasswd can modify My.ini files in the MySQL folder Mysql> SET PASSWORD for myuser@localhost = PASSWORD (' mypasswd '); Mysql> GRANT USAGE on *.* to Myuser@localhost identified by ' MyPassword ';
|
The above related content is the MySQL forgets the password solution Introduction, hoped you can have the harvest.
Skip-grant-tables Operation Method:
1, kill the original MySQL:
The code is as follows |
Copy Code |
Rcmysqld stop Or: Service Mysqld Stop Or: Kill-term mysqld
|
2. Start MySQL with command line parameters:
The code is as follows |
Copy Code |
/usr/bin/mysqld_safe--skip-grant-tables &
|
3. Modify Admin Password:
The code is as follows |
Copy Code |
Use MySQL; Update user set Password=password (' Yournewpasswordhere ') where user= ' root '; Flush privileges; Exit
|
4, kill MySQL, restart MySQL