mysql 创建一个用户,指定一个数据库_MySQL
程序员文章站
2022-05-14 10:04:46
...
bitsCN.com
mysql 创建一个用户 hail,密码 hail,指定一个数据库 haildb 给 hail
mysql -u root -p
password
use mysql;
insert into user(host,user,password) values('localhost','hail',password('hail'));
flush privileges;
create database haildb;
grant all privileges on haildb.* to hail@localhost identified by'hail';
flush privileges;
如果想指定部分权限给用户
grant select,update on haildb.* to hail@localhost identified by'hail';
flush privileges;
删除用户
deletefrom user where user='hail'and host='localhost';
flush privileges;
删除用户数据库
drop database haildb;
修改指定用户密码
update user set password=password('new_password')where user='hail'and host='localhost';
flush privileges;
bitsCN.com上一篇: CentOS下phpMyAdmin安装
下一篇: 如何使用索引提高查询速度_MySQL