Commit 2284fe
2024-12-30 11:06:43 Steven Anderson: init| /dev/null .. ScriptFU/mysql/user_admin.md | |
| @@ 0,0 1,11 @@ | |
| + | # user admin |
| + | |
| + | #### set root password |
| + | UPDATE mysql.user SET password = PASSWORD('newpassword') WHERE user = 'root'; |
| + | |
| + | #### disable auth plugin |
| + | sudo mysql -u root |
| + | [mysql] use mysql; |
| + | [mysql] update user set plugin='' where User='root'; |
| + | [mysql] flush privileges; |
| + | [mysql] \q |