Common Problems » History » Version 6
Jessie Lee, 11/10/2017 03:59 PM
| 1 | 1 | Jessie Lee | h1. Common Problems |
|---|---|---|---|
| 2 | |||
| 3 | {{lastupdated_at}} by {{lastupdated_by}} |
||
| 4 | |||
| 5 | {{>toc}} |
||
| 6 | |||
| 7 | |||
| 8 | h2. Lost Mysql root password |
||
| 9 | |||
| 10 | 2 | Jessie Lee | h3. Reset method 1 |
| 11 | 3 | Jessie Lee | |
| 12 | 2 | Jessie Lee | * stop mysql |
| 13 | * start mysql on command line with @ mysqld --skip-grant-tables@ |
||
| 14 | * go into mysql console |
||
| 15 | * type FLUSH PRIVILEGES; |
||
| 16 | * SET PASSWORD FOR root@'localhost' = PASSWORD('password'); |
||
| 17 | 3 | Jessie Lee | |
| 18 | 6 | Jessie Lee | h3. Reset method 2 |
| 19 | 1 | Jessie Lee | |
| 20 | 6 | Jessie Lee | * create file containing the following: |
| 21 | <pre>UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; |
||
| 22 | FLUSH PRIVILEGES;</pre> |
||
| 23 | * start mysql with mysqld_safe --init-file=/path/to/file & |
||
| 24 | 2 | Jessie Lee | * it should be reset! |
| 25 | |||
| 26 | 1 | Jessie Lee | h2. fail2ban locked me out |