一.MySQL用户管理
元数据数据库:mysql
用户账号:
'USERNAME'@'HOST'
用户管理
创建用户:CREATE USER
CREATE USER ‘USERNAME’@‘HOST’ [IDENTIFIED BY 'password']
;
IDENTIFIED BY ‘password’ 指定用户密码
创建一个用户可以远程登录 ,并且密码为centos
默认权限:USAGE
用户重命名:rename user
RENAME USER old_user_name TO new_user_name;
删除用户:
DROP USER ‘USERNAME’@'HOST‘
示例:删除默认的空用户
DROP USER ''@'localhost';
查看用户列表
select user,host,password from mysql.user;
修改密码:
mysql>SET PASSWORD FOR 'user'@'host' = PASSWORD(‘password');
mysql> flush privileges;
mysql> UPDATE mysql.user SET password=PASSWORD