mysql:reset_root_password
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mysql:reset_root_password [2020/04/02 08:13] – peter | mysql:reset_root_password [2020/07/15 09:30] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| * Stop the mysqld daemon process. | * Stop the mysqld daemon process. | ||
| - | * Start the mysqld daemon process | + | * Start the mysqld daemon process: < |
| --skip-grant-tables | --skip-grant-tables | ||
| - | </ | + | </ |
| - | * Start the mysql client | + | * Start the mysql client < |
| - | -u root | + | -u root |
| - | </ | + | </ |
| * Execute the command < | * Execute the command < | ||
| UPDATE mysql.user SET Password=PASSWORD(' | UPDATE mysql.user SET Password=PASSWORD(' | ||
| </ | </ | ||
| * Execute the command < | * Execute the command < | ||
| - | | + | FLUSH PRIVILEGES; |
| </ | </ | ||
| * Use mysqladmin to shut down the MySQL daemon: < | * Use mysqladmin to shut down the MySQL daemon: < | ||
| - | + | mysqladmin shutdown | |
| - | | + | |
| </ | </ | ||
| - | * Start MySQL server as per normal | + | * Start MySQL server as per normal. |
mysql/reset_root_password.1585815222.txt.gz · Last modified: 2020/07/15 09:30 (external edit)