MySQL用户操作命令_MySQL
来源:动视网
责编:小采
时间:2020-11-09 19:21:19
MySQL用户操作命令_MySQL
MySQL用户操作命令_MySQL:create user 'username'@'localhost' identified by 'password';--创建用户set password for 'username'@'localhost'=password('newpassword');
导读MySQL用户操作命令_MySQL:create user 'username'@'localhost' identified by 'password';--创建用户set password for 'username'@'localhost'=password('newpassword');

create user 'username'@'localhost' identified by 'password';--创建用户set password for 'username'@'localhost'=password('newpassword');--修改用户密码grant all on *.* to 'username'@'localhost';--授权revoke all on *.* to 'username'@'localhost';--撤销授权drop user 'username'@'localhost';--删除用户
MySQL用户操作命令_MySQL
MySQL用户操作命令_MySQL:create user 'username'@'localhost' identified by 'password';--创建用户set password for 'username'@'localhost'=password('newpassword');