Skip navigation links

MySQL Forums :: Newbie :: Can't remotely connect to MySQL database


Advanced Search

Can't remotely connect to MySQL database
Posted by: Glen Porritt ()
Date: April 11, 2009 10:14AM

Hi,

I am trying to connect to a MySQL database remotely.

I have two ubuntu machines 192.168.0.3 (ubuntu 8.10) and 192.168.0.6 (ubuntu 8.04). I have edited each of their /etc/mysql/my.cnf and changed them to include bind-address = 192.168.0.3 and bind-address = 192.168.0.6 respectively. Neither has the line skip-networking.

I have logged into mysql locally on each machine and entered the following command:
grant all on mythconverg.* to 'mythtv'@'%' identified by 'mythtv';

When I run
mysql -u mythtv -h 192.168.0.3 -p
on the 192.168.0.6 machine I get the following error:
glen@glen-desktop:~$ mysql -u mythtv -h 192.168.0.3 -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.3' (113)

When I run
mysql -u mythtv -h 192.168.0.6 -p
on the 192.168.0.6 machine I get the following error:
glen@glen-desktop:~$ mysql -u mythtv -h 192.168.0.6 -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.6' (111)

Options: ReplyQuote


Subject Written By Posted
Can't remotely connect to MySQL database Glen Porritt 04/11/2009 10:14AM
Re: SOLVED Glen Porritt 04/12/2009 07:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.