Establish a DSN to a remote MySQL (Please help-SOS)

--0-1851966119-1118325982=:77615
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit




I have problem trying to establish a DSN from a client Windows XP to a remote MySQL server runing on Windows. I have created an acount in MySQL server, and the same acount to login to the computer. MyODBC 3.51 driver is refered for creating the DSN.



I have also granted the following previlage for the client computer.



GRANT ALL ON *.* to 'myuser'@'64.49.155.13' IDENTIFIED BY 'mypassword';



And also granted one previlage with the host name instead of the IP.





I have not have any progress and I get the error 10060 from the Administrative Tools\ODBC Data Source configuration.


I need to access to a remote MySQL from MS Access. Please, someone explain what steps I need to proceed to get ride of problem.


---------------------------------
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news & more. Check it out!
--0-1851966119-1118325982=:77615--

Re: Establish a DSN to a remote MySQL (Please help-SOS)

Hello amir,

Thursday, June 9, 2005, 5:06:22 PM, you wrote:


> I have problem trying to establish a DSN from a client Windows XP
> to a remote MySQL server runing on Windows. I have created an acount
> in MySQL server, and the same acount to login to the computer.
> MyODBC 3.51 driver is refered for creating the DSN.

> I have also granted the following previlage for the client computer.


> GRANT ALL ON *.* to 'myuser'@'64.49.155.13' IDENTIFIED BY 'mypassword';

try OLD_PASSWORD()


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