I have a Ubuntu 8.04 Server VM set up that I'm using for replication for a
WS2003 machine (which is the master).I have used a checksum utility that
someone recommended to check if the tables are in sync, but I don't have a
GUI installed on Ubuntu, so trying to interpret the selected columns that
wrap in the text mysql command prompt is nearly impossible. So, what I'd
like to do is connect to the Ubuntu server from one of my other windows
machines where I do have a GUI, and can get much better output.

So, that being the case, I've made a couple changes to try to get this
working.

First, I've changed the bind-address setting to refer to the ip address of
the machine, not 127.0.0.1.

Second, I've done a "GRANT ALL ON * TO root@ANCHORMAN identified by
'mypassword';

When I try to connect via the mysql command utility in windows, I'm told
"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.128'
(10061)"

The firewall should be an issue in this case, because I'm connecting
directly to the machine, and not going through a firewall. To my knowledge,
there is not a firewall installed on the Ubuntu server, because I have it
connecting to my server for replication, and that appears to be working
fine.

Are there some additional steps I need to take to make this work?

Thanks,
Jesse

> Obvious question: Did you restart MySQL? netstat -l should show you
> what's listening for connections. you'll want to see if its listening on
> port 3306.

Yes. When that didn't work, I re-started the whole server.
netstat -l tells me that 192.168.1.128:mysql is listening. It lists a
foreign address of "*.*"
When I re-issue the command with "-n", I can seee that it is, indeed,
listening on port 3306.

Can you think of any other reasons why the connection would fail?

Jesse

I cannot. Are you trying to connect via the localhost. It may still be
trying to connect to localhost.

You might try changing the bind-address statement to

bind-address = 0.0.0.0 so that it also listens to localhost as well.

Also if you're trying to connect to an ip address instead of a named
host, I've found that you have to code your grant statement to have an
ip address instead of a hostname.



Curtis

Jesse wrote:
>> Obvious question: Did you restart MySQL? netstat -l should show you
>> what's listening for connections. you'll want to see if its
>> listening on port 3306.
>
> Yes. When that didn't work, I re-started the whole server.
> netstat -l tells me that 192.168.1.128:mysql is listening. It lists a
> foreign address of "*.*"
> When I re-issue the command with "-n", I can seee that it is, indeed,
> listening on port 3306.
>
> Can you think of any other reasons why the connection would fail?
>
> Jesse

I was wondering how I get it to listed on all ports. When I try 0.0.0.0,
and try to restart, the restart fails, and when it tries to start again, I
get the error, /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using
password:YES)' This has been happening for a day or so, and I don't know if
it's related to my problem or not.

After changing the grant to use an IP address, I still cannot log in.

Jesse

----- Original Message -----
From: "Curtis Maurand" <curtis@maurand.com>
To: "Jesse" <jc@msdlg.com>
Cc: "MySQL List" <mysql@lists.mysql.com>
Sent: Thursday, July 17, 2008 4:31 PM
Subject: Re: Accessing remote machine (Ubuntu) from Window


>
> I cannot. Are you trying to connect via the localhost. It may still be
> trying to connect to localhost.
>
> You might try changing the bind-address statement to
>
> bind-address = 0.0.0.0 so that it also listens to localhost as well.
>
> Also if you're trying to connect to an ip address instead of a named host,
> I've found that you have to code your grant statement to have an ip
> address instead of a hostname.
>
>
>
> Curtis
>
> Jesse wrote:
>>> Obvious question: Did you restart MySQL? netstat -l should show you
>>> what's listening for connections. you'll want to see if its listening
>>> on port 3306.
>>
>> Yes. When that didn't work, I re-started the whole server.
>> netstat -l tells me that 192.168.1.128:mysql is listening. It lists a
>> foreign address of "*.*"
>> When I re-issue the command with "-n", I can seee that it is, indeed,
>> listening on port 3306.
>>
>> Can you think of any other reasons why the connection would fail?
>>
>> Jesse
>
>