MySQL创建新用户、授权远程连接

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;