创建公网主机MySQL账户，内网机器远程访问

<h1>需求：</h1> <p>1、212.64.95.174 需要创建只读账户运行 192.168.26.146 远程连接；并给账户授权数据库权限； 2、内网机器 192.168.26.146 需要访问 212.64.95.174 的本地数据库；</p> <h1>创建账户</h1> <pre><code>CREATE USER 'zjjreadonly'@'%' IDENTIFIED BY 'nWlLx9Sy80'; CREATE USER 'zjjreadonly'@'113.108.148.74' IDENTIFIED BY 'nWlLx9Sy80';</code></pre> <h1>数据库所有表授权</h1> <pre><code>GRANT select ON `hw-shiyuesdk-config`.* TO 'zzjreadonly'@'113.108.148.74' IDENTIFIED BY 'nWlLx9Sy80'; flush privileges;</code></pre> <h1>附加</h1> <h2>授权数据库表</h2> <pre><code>GRANT select ON `shiyuesdk`.`app` TO 'zzjreadonly'@'113.108.148.74' IDENTIFIED BY 'nWlLx9Sy80'; GRANT select ON `shiyuesdk`.`channel_master` TO 'zzjreadonly'@'113.108.148.74' IDENTIFIED BY 'nWlLx9Sy80'; GRANT select ON `shiyuesdk`.`order` TO 'zzjreadonly'@'113.108.148.74' IDENTIFIED BY 'nWlLx9Sy80';</code></pre> <h1>查看用户的权限</h1> <pre><code>show grants for 'soa_readonly'@'113.108.148.74';</code></pre> <h1>取消用户的权限</h1> <pre><code>REVOKE SELECT ON `shiyuesdk`.* from 'soa_readonly'@'113.108.148.74';</code></pre> <h1>查看用户的权限（方式二）</h1> <pre><code>select * from mysql.user where user='root' \G</code></pre>