mysql8.0创建(配置)新用户报错ERROR 1064 (42000)

刚开始是用旧版本来创建用户

mysql>GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

会出现一下报错

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'password' WITH GRANT OPTION' at line 1

mysql8.0版本为新版本，需要先创建用户再分配权限，不能和旧版本一样

新版本创建用户或者超级管理员方法：

https://blog.csdn.net/weixin_44783814/article/details/106709165