Mysql8.0不支援grant all privileges on *.* to root@“%“ identified by “.“；

lizz2276發表於2020-12-17
MySqlIDE
https://www.cnblogs.com/Loners/p/12348366.html


MySQL 8.0已經不支援下面這種命令寫法
grant all privileges on *.* to root@"%" identified by ".";

正確的寫法是先建立使用者

CREATE USER 'root'@'%' IDENTIFIED BY 'Hadoop3!';
再給使用者授權
grant all privileges on *.* to 'root'@'%' ;

 

相關文章