;//remove table;
查看mysql的端口号 show global variables like ‘port’
show warnings; show erros;
mysql 5.7 创建用户 CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;
{ 注意：host通配所有ip的字符是 % ,不是 * }
授权 GRANT privileges ON databasename.tablename TO ‘username’@‘host’
e.g. GRANT SELECT, INSERT ON . TO ‘dog’@‘localhost’
查询所有用户 select Host,User from mysql.user;
查看MySQL用户权限： show grants for 你的用户