一. 安装mysql后root shell可以登录但是普通用户不能使用mysql -u root -p登录mysql
解决:
使用root登录 select user,host from mysql.user DROP USER ‘root‘@‘localhost‘; CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘zhuopeng‘; GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION; FLUSH PRIVILEGES;
原文:https://www.cnblogs.com/da-peng/p/11495408.html