#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';
pkill mysqld
mysql -u root -p
yeqing 進入
#3 先建立賬号再授權(方法一)
create useryeqing@'localhost' identified by '123456';
grant all on db1.* 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’
本文轉自cloves 51CTO部落格,原文連結:http://blog.51cto.com/yeqing/1589883