本文共 1426 字，大约阅读时间需要 4 分钟。

MySQL????????

1. ??MySQL??

?MySQL??????????????????

CREATE USER 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';

• USERNAME???????????
• %???????????????????????????? % ????IP???
• PASSWORD???????????

????????????????

2. ??????

???????????????????????????????????????

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';

• GRANT ALL PRIVILEGES????????
• *.*?????????????
• TO 'USERNAME'@'%'??????????????

???????????????????

FLUSH PRIVILEGES;

3. ??????

???????????????????

SHOW GRANTS FOR "USERNAME"@"%";

• SHOW GRANTS????????????
• "USERNAME"@"%??????????????????

4. ??????

????????????????????

REVOKE CREATE ON *.* FROM "USERNAME"@"localhost";

• REVOKE??????
• CREATE??????????????
• *.*???????????

?????????????

FLUSH PRIVILEGES;

5. ????

???????????????

DROP USER "USERNAME"@"%;

6. ????????????

??1???MySQL???

??MySQL 5.7??????

mysql> USE mysql;mysql> UPDATE user SET authentication_string = PASSWORD('???') WHERE user = "???";mysql> FLUSH PRIVILEGES;

??2???SET PASSWORD??

mysql> SET PASSWORD FOR "???"@"%" = PASSWORD('???');

??3???mysqladmin??

mysqladmin -u root -p??? ???

7. ???????

????MySQL???????????????

mysqld_safe --skip-grant-tables

mysql> USE mysql;mysql> UPDATE user SET password = PASSWORD('???') WHERE user = 'root';mysql> FLUSH PRIVILEGES;

???????????????????MySQL???????????????????????????