进入自己服务器的mysql数据库
[root@iz2zea8athrpi6mpaciiruz bin]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.5.56-log Source distribution
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
执行以下sql语句
GRANT ALL PRIVILEGES ON *.* TO zhangsan@"%" IDENTIFIED BY "lisi";
FLUSH PRIVILEGES;
执行上面两句话。自动创建用户zhangs,密码lisi
格式：grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";
@ 后面是访问mysql的客户端IP地址（或是 主机名） % 代表任意的客户端，如果填写 localhost 为本地访问（那此用户就不能远程访问该mysql数据库了）。
或者执行
GRANTALL PRIVILEGES ON *.*TO 'root'@'%' IDENTIFIEDBY 'root' WITH GRANT OPTION;flush privileges;
FLUSH PRIVILEGES;
授权用户root使用密码root从任意主机连接到mysql服务器