我知道命令的意思
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTIONGRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4, 5.6.7.8' IDENTIFIED BY 'PASSWORD' WITH GRANT<
所有这些都失败了:ERROR 1193 (HY000): Unknown system variable 'PASSWORD'
mysqlERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntax to use
在update user set host='%' where user='root之后,我失去了MySQL根用户的一些特权。所以我停止了服务器,用跳过的授权表启动它。msqld --skip-grant-tablesmysql>update mysql.user set grant_priv = 'Y' where user = 'root';<
当我使用命令“”(键入"python“)时,它抛出了这个manage.py,然后我检查了用户的权限。代码和结果就像荧光一样。mysql> select host,user from mysql.user;| host | user |ALL PRIVILEGES ON *.* TO 'zhuxin'@'%' WITH GRANT OPTION |
| GRANT</em