MySQL8 创建用户并能远程登录
MySQL8 开始不能使用GRANT
命令创建用户,要使用CREATE USER
替换
CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
MySQL8 创建用户并能远程登录
https://blog.xiqi.site/archives/mysql8-chuang-jian-yong-hu-bing-neng-yuan-cheng-deng-lu