mysql 打开客户端连接设置
当你使用客户端连接linux主机的mysql数据库，当不允许你连接时。进行如下设置，客户端即可正常连接。
?
必须在mysql中修改
即 mysql>
?
将下面的‘ServerIP’改为交互系统部署的服务器ip
将下面的‘youIP’改为您电脑的ip
nisuser表示要连接的数据库登陆名称
nis表示要连接的数据库登陆密码
?
GRANT ALL PRIVILEGES ON *.* TO nisuser@ServerIP
IDENTIFIED BY 'nis' WITH GRANT OPTION;
?
GRANT ALL PRIVILEGES ON *.* TO nisuser@youIP
IDENTIFIED BY 'nis' WITH GRANT OPTION;
?
FLUSH PRIVILEGES;
?
?
样例：
GRANT ALL PRIVILEGES ON *.* TO root@10.1.2.141
IDENTIFIED BY 'founder123' WITH GRANT OPTION;
?
GRANT ALL PRIVILEGES ON *.* TO root@10.1.8.4
IDENTIFIED BY 'founder123' WITH GRANT OPTION;
?
FLUSH PRIVILEGES;
