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' [at] '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--
amir razi [ Do, 09 Juni 2005 16:06 ] [ ID #830826 ]

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' [at] '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 [at] m.gmane.org
artem [ Fr, 10 Juni 2005 10:18 ] [ ID #832436 ]
Datenbanken » gmane.comp.db.mysql.odbc » Establish a DSN to a remote MySQL (Please help-SOS)

Vorheriges Thema: Connecting Applications to Mysql
Nächstes Thema: Tarball for Solaris MyODBC?