mysql帳號和許可權管理

標籤：mysql帳號和許可權管理

#0 修改root密碼

mysqladmin -u root -p password yeqing

#1 刪除無用帳號

select user,hostfrom mysql.user;

delete from mysql.user where user != ‘root‘;

delete from mysql.user where user = ‘root‘ and host=‘127.0.0.1‘;

flush privileges;

#2 誤刪除root帳號怎麼辦?

/etc/init.d/mysqld stop 或者 pkill mysqld

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

mysql

UPDATE mysql.user SET Password=PASSWORD(‘yeqing‘),host=‘localhost‘ where USER=‘root‘;

flush privileges;

pkill mysqld

pkill mysqld

mysql -u root -p

yeqing 進入

#3 先建立帳號再授權（方法一）

create [email protected]‘localhost‘ identified by ‘123456‘;

grant all ondb1.* to [email protected]‘localhost‘;

或者

grant select,insert,update,delete,create,dropon db1.* to ‘yeqing’@’192.168.1.%’ identified by ‘test123’

flushprivileges;

show grants [email protected]‘localhost‘;

#4 建立帳號的同時授權（方法二）

grant all onmysql.* to [email protected]‘localhost‘ identified by ‘123456‘;

grant all on  *.* to  [email protected]’192.168.1.%’  identified by ‘test123’

flushprivileges;

mysql帳號和許可權管理