Home A - Z
Page Index

Blame

2284fe Steven Anderson 2024-12-30 11:06:43
init
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