///修改root密码,localhost只允许本机访问,远程访问则是%,写成IP则只能在制定IP访问。
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
///创建ca用户、密码123456
CREATE USER 'ca'@'%' IDENTIFIED BY '123456';
///用户权限,创建表、删除表等操作
GRANT ALL ON *.* TO 'cfca'@'%';
///修改root用户可以远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
///列出当前用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
///刷新表,修改后必须操作
flush privileges;
本文转自 piazini 51CTO博客,原文链接:http://blog.51cto.com/wutou/1744971