特牛生活网

MySQL数据库---数据库管理-CSDN博客

网友收藏
文章浏览阅读438次。-- 创建用户,指定明文密码create user 'rose'@'localhost' identified by 'rosepwd';-- 查看用户是否创建成功select user,host from mysql.user;-- 创建用户,不设置密码create user 'rose01'@'localhost';select user,host from mysql...._delete from mysql.user where user = 'rose02'and host='localhost';