can't connect from remote machine

[imryn]

Hi Folks,

I am writing some code in ASP3 on an XP windows machine. I am trying to connect to a linux machine which is Redhat 7.3 that is hosting my MySQL database. I am use this code to connect.

objConn.Open "Driver={mySQL};Server=

http://4.7.165.99;Port=3306;Option=131072;

Stmt=;Database=DB name;Uid=User Id;Pwd=MyPassword;"

This is the Error message I keep getting:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have been looking all over the web, and can't find how to fix this issue, can anyone help me?

Thank You,
Ryan

 

[ericbrunson]

you probably don't want http in your server specification.
try: mysql://4.7.165.99;Port=3306;Database=DBname;Uid=UserId;Pwd=MyPassword;

 

[imryn]

Thank you ericbrunson, that did take care of my issue. Now it seems like a permissions problem. Do you or anyone know how to change the permission on mySQL to allow a specific ip address?

Thank You
Ryan

 

[Menthos]

You need to grant your user access from your client. Check the manual for usage of GRANT. I think it's something like GRANT ALL PRIVELIGES ON <db> TO <user>@<host> IDENTIFIED BY <password>

Cheers,
Menthos

 

[imryn]

Thanks Menthos,

It turns out that I only needed to change the host column in the user table to the incoming ip address for the current "user" in the user table in the mysql database. Thank you .... everyone

Ryan