开账号与改密

开账号与改密要点

• 开账号：CREATE USER '用户名'@'主机' IDENTIFIED BY '密码';
• localhost 只允许本机连，% 表示接受任意主机连
• 实例：CREATE USER 'alice'@'localhost' IDENTIFIED BY 'pwd123';
• 改密码：ALTER USER 'alice'@'localhost' IDENTIFIED BY 'new456';
• 删账号：DROP USER 'alice'@'localhost';
• 想换 host 只能先 DROP 再 CREATE 重开，不能直接改
• MySQL 8.0.16+ 开账号时就能顺手 WITH GRANT OPTION 授权

开账号与改密示例

						-- 新建账号
						CREATE USER 'alice'@'localhost' IDENTIFIED BY 'pwd123';

						-- 改密码
						ALTER USER 'alice'@'localhost' IDENTIFIED BY 'new456';

						-- 删账号
						DROP USER 'alice'@'localhost';

MySQL 管理知识点