1.新建用户
MySQL -u root -p
CREATE USER 'ssh'@'localhost' IDENTIFIED BY 'ssh'; #本地登录
CREATE USER 'ssh'@'%' IDENTIFIED BY 'ssh'; #远程登录
@
后面接ip地址
2.用户授权
- 授权格式
grant 权限 on 数据库.* to 用户名@登录主机 identified by '密码'
权限分为grant all privileges on `test`.* to 'ssh'@'localhost' identified by 'ssh';
select
insert
update
delete
create
drop
alter
等…
3. 删除用户
- 删除用户
mysql -u root -p Delete FROM mysql.user Where User=”test” and Host=”localhost”; flush privileges; drop database testDB;
- 删除账户及其权限
drop user 用户名@’%’; drop user 用户名@ localhost;