Unable to connect mySQL from a remote machine

Unable to connect mySQL from a remote machine

am 30.10.2006 04:13:00 von Aiza Norazreen Zainal Abidin

--------------060503060808040407070702
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I installed MySQL driver 3.51 on my local machine and tested
successfully to connect to our new helpdesk system.
However, I am unable to connect to the same database from other PC.
The error message is " *Request returned with SQL_ERROR*."

And the details found from the diagnostics is *"Host 'XYBASE SABA" is
not allowed to connect to this MySQL Server*".

For your information, 'XYBASE SABA' is the remote machine name.

Please advice.



Thank You and Regards,

Aiza Norazreen
Xybase Sdn Bhd, Malaysia
Website: www.xybase.com



--------------060503060808040407070702--

RE: Unable to connect mySQL from a remote machine

am 31.10.2006 22:46:10 von John.Bonnett

The MySQL GRANT statement, among other things, restricts the hosts from
which a client can connect. Whatever user name you are logging in with
from that other machine may not have the right to access the server from
that other machine. Read about the GRANT statement in the MySQL manual.

John Bonnett=20

-----Original Message-----
From: Aiza Norazreen Zainal Abidin [mailto:aazreen@xybase.com]=20
Sent: Monday, 30 October 2006 1:43 PM
To: myodbc@lists.mysql.com
Cc: aazreen@xybase.com; syaatira@xybase.com
Subject: Unable to connect mySQL from a remote machine

Hi,

I installed MySQL driver 3.51 on my local machine and tested
successfully to connect to our new helpdesk system.
However, I am unable to connect to the same database from other PC.
The error message is " *Request returned with SQL_ERROR*."

And the details found from the diagnostics is *"Host 'XYBASE SABA" is
not allowed to connect to this MySQL Server*".

For your information, 'XYBASE SABA' is the remote machine name.

Please advice.



Thank You and Regards,

Aiza Norazreen
Xybase Sdn Bhd, Malaysia
Website: www.xybase.com



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg