一、场景描述:
mac新安装的数据库,/usr/local/mysql/bin下用root用户居然不让连接登录,不了解Mysql的基础权限前真是一脸懵的
二、操作详情
看到这里我们知道root用户应该是缺少localhost连接权限
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
看到查询结果,确定猜想
CREATE USER 'root'@'localhost' IDENTIFIED BY 'root';
ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
fack,查半天,依次执行下面三条语句
drop user 'root'@'localhost';
FLUSH PRIVILEGES
CREATE USER 'root'@'localhost' IDENTIFIED BY 'root';
成功了。
三、附命令:
查看用户连接权限
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
设置用户所有库表权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
查看mysql安装目录
show variables like "%char%";
四、优秀博客: