mysql重置权限_MySQL
来源：动视网
责编：小采
时间：2020-11-09 18:07:56
mysql重置权限_MySQL
mysql重置权限_MySQL:bitsCN.com mysql> GRANT ALL PRIVILEGES ON abctest.* TO abctest@% IDENTIFIED BY 'pass123' WITH GRANT OPTION; 备注：abctest为数据库名，pass123为密码 Query OK, 0 rows affected (0.00 s
导读mysql重置权限_MySQL:bitsCN.com mysql> GRANT ALL PRIVILEGES ON abctest.* TO abctest@% IDENTIFIED BY 'pass123' WITH GRANT OPTION; 备注：abctest为数据库名，pass123为密码 Query OK, 0 rows affected (0.00 s
bitsCN.com
mysql> GRANT ALL PRIVILEGES ON abctest.* TO abctest@"%" IDENTIFIED BY 'pass123' WITH GRANT OPTION;
备注：abctest为数据库名，pass123为密码
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
bitsCN.com
mysql重置权限_MySQL
mysql重置权限_MySQL:bitsCN.com mysql> GRANT ALL PRIVILEGES ON abctest.* TO abctest@% IDENTIFIED BY 'pass123' WITH GRANT OPTION; 备注：abctest为数据库名，pass123为密码 Query OK, 0 rows affected (0.00 s
