mysql administrator problem

[imsDave]

I am trying to connect to mysql database remotely via mysql administrator gui. I am able to connect locally (localhost) but when i try connect remotely i get the following error:

Code: Select all

Could not connect to the specified instance.

MySQL Error Number 2003
Can't connect to MySql server on '[i]ipaddress[/i]' (10065)

If you want to check the network connection, please click the Ping button.


MySql is hosted on a linux machine. And my remote client is a windows os. Does anyone know why this doesn't work?

Thanks

[Xardas der Dunkle]

Some MySQL-Servers block remote connections, for limiting the traffic.

[imsDave]

Some MySQL-Servers block remote connections.

How do i find one that doesn't?

[Xardas der Dunkle]

Where you host your MySQL-Database?

[imsDave]

Where you host your MySQL-Database?

On RHEL 5.0. It's just a virtual machine on the same computer that runs windows.

[Xardas der Dunkle]

On a virtual Machine?

First you shoult test if the network connection of the virtual machine ist alive.

The mysql-user need the permissions to deal with remote-connections. For that you have to change the value of the field 'host' in the table user (on database 'mysql') to '%'.

Sorry my english is not very well .__.

[imsDave]

On a virtual Machine?

First you shoult test if the network connection of the virtual machine ist alive.

The mysql-user need the permissions to deal with remote-connections. For that you have to change the value of the field 'host' in the table user (on database 'mysql') to '%'.

Sorry my english is not very well .__.

The connection is alive. I can ping the Linux machine.

I don't have any 'mysql-user' in this table. I installed Lampp using the root user. Is that a problem? I have 5 records in this table.

[Xardas der Dunkle]

The root-user is in taht table too. And the host of him, can also be 'localhost'. You have to change it to: '%' for connection by remote.

[imsDave]

The root-user is in taht table too. And the host of him, can also be 'localhost'. You have to change it to: '%' for connection by remote.

Ok. So I have a record that looks like this:

localhost root ...

I changed it to look like:

% root ...

This didn't work. Is this what you were talking about?

[Xardas der Dunkle]

Yes thats it. Have you restartet the mysql-server?

[imsDave]

Yes thats it. Have you restartet the mysql-server?

didn't work. Also, now i can't see my database when i connect on the localhost.

[sari42]

some installations need both :
localhost | root
and
% | root

btw, I'd suggest a special
% | remoteadmin
instead of root - YMMV

[imsDave]

some installations need both :
localhost | root
and
% | root

btw, I'd suggest a special
% | remoteadmin
instead of root - YMMV

That didn't work either Is there a configuration setting in my.cnf that im missing maybe?

BTW, I appreciate all the help.