MySQL—管理

# MySQL管理

-- 创建用户
CREATE USER 'ybj_edu'@'localhost' IDENTIFIED BY '123456'

SELECT * FROM mysql.user

-- 修改密码
UPDATE PASSWORD = PASSWORD('abcde')

-- 该别人密码，需要有修改密码权限
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456')

-- 赋权限
GRANT SELECT,INSERT -- 查找和添加权限
	ON ybj_db01.emp -- 哪个数据库的哪个表
	TO 'ybj_edu'@'localhost'
	
-- 回收权限
REVOKE SELECT,INSERT
	ON ybj_db01.emp 
	TO 'ybj_edu'@'localhost'

REVOKE ALL -- 回收所有权限
	ON ybj_db01.emp 
	TO 'ybj_edu'@'localhost'

-- 删除用户
DROP USER 'ybj_edu'@'localhost' 

# MySQL管理

CREATE USER jack

CREATE USER 'smith'@'192.168.1.%'

DROP USER jack

DROP USER 'smith'@'192.168.1.%'

SELECT `host`,`user` FROM mysql.user