mysql账号和权限管理
#0 修改root密码
mysqladmin -u root -p password yeqing
#1 删除无用账号
select user,hostfrom mysql.user;
delete from mysql.user where user != ‘root‘;
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 useryeqing@‘localhost‘ identified by ‘123456‘;
grant all ondb1.* to yeqing@‘localhost‘;
或者
grant select,insert,update,delete,create,dropon db1.* to ‘yeqing’@’192.168.1.%’ identified by ‘test123’
flushprivileges;
show grants foryeqing@‘localhost‘;
#4 创建账号的同时授权（方法二）
grant all onmysql.* to yeqing@‘localhost‘ identified by ‘123456‘;
grant all on *.* to test@’192.168.1.%’ identified by ‘test123’
flushprivileges;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
