Blame
| 2284fe | Steven Anderson | 2024-12-30 11:06:43 | 1 | # user admin |
| 2 | ||||
| 3 | #### set root password |
|||
| 4 | UPDATE mysql.user SET password = PASSWORD('newpassword') WHERE user = 'root'; |
|||
| 5 | ||||
| 6 | #### disable auth plugin |
|||
| 7 | sudo mysql -u root |
|||
| 8 | [mysql] use mysql; |
|||
| 9 | [mysql] update user set plugin='' where User='root'; |
|||
| 10 | [mysql] flush privileges; |
|||
| 11 | [mysql] \q |