创建用户/账户

代码示例

1CREATE USER 'username'@'hostname' IDENTIFIED BY'password';

1-- 为本地访问创建用户的示例
2CREATE USER 'new_app'@'localhost' IDENTIFIED BY 'SuperSecret123!';

1-- 为来自特定 IP 的外部报表工具创建用户
2CREATE USER 'report_tool_user'@'10.0.5.20' IDENTIFIED BY 'ReportP@ssw0rdSecure';

1-- 为从内部 192.168.1.x 网络连接的分析师创建用户
2CREATE USER 'store_analyst'@'192.168.1.%' IDENTIFIED BY 'AnalystKey#2025';

1-- 为在本地运行的 OnlineStore Web 应用程序创建用户
2CREATE USER 'onlinestore_app'@'localhost' IDENTIFIED BY 'AppS3cureP@sswOrd!';

1-- 从 mysql.user 表中选择 user 和 host 列
2SELECT user, host FROM mysql.user;

代码示例

1+--------------------+-----------------+
2| user               | host            |
3+--------------------+-----------------+
4| store_analyst      | 192.168.1.%     |
5| mariadb.sys        | localhost       | -- 系统用户
6| mysql.infoschema   | localhost       | -- 系统用户
7| mysql.session      | localhost       | -- 系统用户
8| mysql.sys          | localhost       | -- 系统用户
9| onlinestore_app    | localhost       |
10| report_tool_user   | 10.0.5.20       |
11| root               | localhost       | -- 默认管理员用户
12+--------------------+-----------------+

1-- 选择 user、host 和认证插件
2SELECT user, host, plugin FROM mysql.user;

1ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_strong_password';

1-- 更改 store_analyst 用户的密码
2ALTER USER 'store_analyst'@'192.168.1.%' IDENTIFIED BY 'NewAnalystKey#2026!';

1DROP USER 'username'@'hostname';

1-- 删除 report_tool_user 账户
2DROP USER 'report_tool_user'@'10.0.5.20';