Access denied for user 'test'@'ip'(using password: YES)
<p>I have found many posts for this error, tried everything but still getting same error.I am trying to connect to mysql on ubuntu server from my remote app and mysql client. Let me post whatever steps I have taken already :</p>
<ol>
<li>Stop the firewall on ubuntu server : iptables -F. Also tried with sudo service ufw stop.</li>
<li>Commented &quot;bind-address&quot; in /etc/mysql/my.cnf and restarted mysql.</li>
<li>Added user in mysql : CREATE USER 'test'@'%' IDENTIFIED BY 'testpwd';</li>
<li>GRANT ALL PRIVILEGES ON <em>.</em> TO 'test'@'%' IDENTIFIED BY 'testpwd'  WITH GRANT OPTION;</li>
<li>FLUSH PRIVILEGES;</li>
<li>I can see the entry of new user by &quot;Select host, user from mysql.user&quot;;</li>
<li>restarted mysql again. Still the same error!</li>
<li>Now I thought maybe there is some problem still with firewall, so added :iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
Problem still persist.</li>
</ol>