Common Problems » History » Version 2
Jessie Lee, 11/10/2017 03:38 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 | * stop mysql |
||
| 12 | * start mysql on command line with @ mysqld --skip-grant-tables@ |
||
| 13 | * go into mysql console |
||
| 14 | * type FLUSH PRIVILEGES; |
||
| 15 | * SET PASSWORD FOR root@'localhost' = PASSWORD('password'); |
||
| 16 | h3.Reset method 2 |
||
| 17 | * create file containing line @SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');@ with the new password replacing MYNewPass |
||
| 18 | * start mysql with mysqld --init-file=/path/to/file & |
||
| 19 | * it should be reset! |
||
| 20 | |||
| 21 | 1 | Jessie Lee | h2. fail2ban locked me out |