我更新到 MySQL 8.3,并希望将其设置为允许远程连接。
我正在使用 $PASSWORD 是密码的地方,但收到以下错误并且有点困惑。知道应该是什么吗?
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '$PASSWORD';
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 ''' at line 1
mysql>
您应该先创建用户然后添加权限