<div>
By default mysql only listen to localhost, verify MySQL is listening on all network interface with command<br><br>run this on mysql server<br><br><pre><code class="code-1 nolinks" id="code-20-43283385-1"><span>netstat -lntp | grep 3306</span>
</code></pre><br>See if mysql port accessable from your client machine.<br><br><pre><code class="code-1 nolinks" id="code-20-43283385-2"><span>telnet IP_OF_MYSQL_SERVER 3306</span>
</code></pre><br>This need to be run on computer that runs MySql Workbench. If you can connect, you will see MySQL prompt.
</div>


<div>
Yujin Boby --MySql server is on Windows 7 machine<br>Was able to pull this info logging in locally<br>mysql&gt; status;<br>mysql &nbsp;Ver 14.14 Distrib 5.5.12, for Win32 (x86)<br>Connection id: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;140<br>Current database:<br>Current user: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; root@ls2<br>SSL: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Not in use<br>Using delimiter: &nbsp; &nbsp; &nbsp; &nbsp;;<br>Server version: &nbsp; &nbsp; &nbsp; &nbsp; 5.5.12 MySQL Community Server (GPL)<br>Protocol version: &nbsp; &nbsp; &nbsp; 10<br>Connection: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 192.168.1.52 via TCP/IP<br>Server characterset: &nbsp; &nbsp;latin1<br>Db &nbsp; &nbsp; characterset: &nbsp; &nbsp;latin1<br>Client characterset: &nbsp; &nbsp;latin1<br>Conn. &nbsp;characterset: &nbsp; &nbsp;latin1<br>TCP port: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3306<br>Uptime: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 hours 36 min 59 sec<br>Threads: 1 &nbsp;Questions: 5150 &nbsp;Slow queries: 0 &nbsp;Opens: 169 &nbsp;Flush tables: 1 &nbsp;Open tables: 0 &nbsp;Queries per second avg: 0.<br>--------------<br>mysql&gt;<br>When i try to telnet using Putty -- get a Network error: connection refused error&nbsp;<br><br><br>
</div>


<div>
MySQL blocks remote access on the 'root' account. &nbsp;You need to create another account for remote access.
</div>


<div>
<blockquote>When i try to telnet using Putty -- get a Network error: connection refused error&nbsp;</blockquote><br>Can you try telnet command from command line ? If you don't have telnet installed, you can install it on windows with following command (run as Administrator)<br><br><pre><code class="code-1 nolinks" id="code-20-43283474-1"><span>dism /online /Enable-Feature /FeatureName:TelnetClient</span>
</code></pre><br>
</div>


<div>
Ok -- have made new user -- granted that user permissions <br>CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';<br>GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';<br>FLUSH PRIVILEGES;<br><br>Then ran telnet command from telnet window. For some reason getting invalid command&nbsp;<br><br>Microsoft Telnet&gt; telnet 192.168.1.52 3306<br>Invalid Command. type ?/help for help<br>Microsoft Telnet&gt;
</div>


<div>
You can not telnet to a MySQL server. &nbsp;MySQL requires a driver that understands the correct protocol and telnet does not. &nbsp;Also, you did not create a user with remote access privileges. &nbsp;This is in addition to the same user at localhost. &nbsp;You need both. &nbsp;Should look like this:<br><pre><code class="code-1 nolinks" id="code-20-43283528-1"><span>CREATE USER 'user'@'%' IDENTIFIED BY 'password';</span>
<span>GRANT ALL PRIVILEGES ON * . * TO 'user'@'%';</span>
<span>FLUSH PRIVILEGES;</span>
</code></pre>See '%' on this page: &nbsp;<a href="https://dev.mysql.com/doc/refman/5.6/en/account-names.html" rel="ugc">https://dev.mysql.com/doc/refman/5.6/en/account-names.html</a>
</div>


<div>
Telnet is only to test connectivity to the server on that port. &nbsp;It doesn't do anything with MySQL.<br />
<br />

<blockquote>
Microsoft Telnet&gt; telnet 192.168.1.52 3306<br />
Invalid Command. type ?/help for help
</blockquote>
<br />
You are already running telnet thus the &quot;Microsoft Telnet&gt;&quot; prompt.<br />
<br />
The correct command then is: &nbsp;open 192.168.1.52 3306<br />
<a href="https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/telnet-open" rel="ugc">https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/telnet-open</a><br />
<br />
&gt;&gt;When i try to telnet using Putty -- get a Network error: connection refused error <br />
<br />
This means the server doesn't have anything listening on that server and port to accept connections. &nbsp;This means that MySQL isn't accepting connections on that server and port.<br />
<br />
I'm not a MySQL Expert which is why I haven't posted until now but it appears you need to configure MySQL to &quot;listen&quot; for connections coming in from the outside.<br />
<br />
A quick Google provided this but I cannot confirm if it still relevant:<br />
<a href="https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql" rel="ugc">https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql</a>
</div>


<div>
@Dan Kuzdas<br><br>Run telnet command from Command promt.&nbsp;
</div>


<div>
Thanks All -- will give this a try&nbsp;
</div>


Systems Admin

KzKrew

<div>
Hi Dan,<br><br>Do you need more help with this?<br><br>Regards,<br>&nbsp; &nbsp; &nbsp;Tomas Helgi
</div>


<div>
<div class="content wysiwyg-content fr-view">
Team Experts<br>I am trying to connect to a remote legacy MySql Database that resides on a Windows 7 32Bit machine.<br>Legacy system is 10+ year old.<br>Have no idea how the database was setup but have been able to connect locally using<br>mysql -h 192.168.x.x -P 3306 -u root -p<br>Have run the following commands<br>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;<br>FLUSH PRIVILEGES;<br>Then restarted MySql&nbsp;<br>Have shut off the Firewall<br>When I try to connect using MySql Workbench I get a<br>Failed to Connect to MySql at 192.168.x.x:3306 with user root<br>Access denied for user root@192.168.x.x (using password:YES)<br>Let me know if you have any thoughts on how to connect<br>Dan<br><br><br>
</div>
</div>



Team Experts
I am trying to connect to a remote legacy MySql Database that resides on a Windows 7 32Bit machine.
Legacy system is 10+ year old.
Have no idea how the database was setup but have been able to connect locally using
mysql -h 192.168.x.x -P 3306 -u root -p
Have run the following commands
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Then restarted MySql 
Have shut off the Firewall
When I try to connect using MySql Workbench I get a
Failed to Connect to MySql at 192.168.x.x:3306 with user root
Access denied for user root@192.168.x.x (using password:YES)
Let me know if you have any thoughts on how to connect
Dan

Connect to remote MySql Database using MySql Workbench

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.