擅长:python、mysql、java
<p>数据库名称必须是全名,而不仅仅是<code>_ahmed</code>部分。所以它应该是<code>moeemnh_adhmed</code>。对于远程连接,协议应为“TCP”。在</p>
<p>另外,检查您是否为远程连接配置了MySQL。因此,首先尝试使用:<br/>
<code>mysql -u moeenmh_ahmed -h moeenmh.com -p</code></p>
<p>请看下面这个设置特权的答案:<a href="https://stackoverflow.com/a/12844804/1431750">https://stackoverflow.com/a/12844804/1431750</a>。引用:</p>
<blockquote>
<p>You have to put this as root:</p>
<pre><code>GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
</code></pre>
<p>where IP is the IP you want to allow acess and USERNAME is the user you use to connect</p>
<p>If you want to allow access from any IP just put % instead of your IP</p>
<p>and then you only have to put</p>
<pre><code>FLUSH PRIVILEGES
</code></pre>
<p>or restart mysql server and that's it</p>
</blockquote>