刀刀网
您的当前位置:首页MySQL用户操作命令_MySQL

MySQL用户操作命令_MySQL

来源:刀刀网


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';--删除用户
显示全文