How to access the remote database in MYSQL

[Sonasang]

Hi ,

I am develping a web page with MYSQL as backend....
I have installed MYSQL and MYSQL connector to access the datas remotely...

But i am getting the error when i try to access the data ....

In the code for the conn syntax...

If i am giving localhost its working fine...

If i give the IP address of the machine to access the database remotely i am getting error in the server machine itself...

Pls help me...

Also i gave the grant permission for my database but its saying that 0 rows affected and nt working..


Pls help me

[spadmore]

Without seeing the error, My first thought is that it could be a firewall issue.
Myabe you could DMZ the host that you're connecting from. OR check the config of mysqld on the server to see what external connection restrictions may exist

- Shelon Padmore

Hi ,

I am develping a web page with MYSQL as backend....
I have installed MYSQL and MYSQL connector to access the datas remotely...

But i am getting the error when i try to access the data ....

In the code for the conn syntax...

If i am giving localhost its working fine...

If i give the IP address of the machine to access the database remotely i am getting error in the server machine itself...

Pls help me...

Also i gave the grant permission for my database but its saying that 0 rows affected and nt working..


Pls help me

[mwasif]

Also i gave the grant permission for my database but its saying that 0 rows affected and nt working..

Did you allow the user to connect remotely or only the SELECT privileges you have given? To allow remote connections, use such syntax in GRANT statement

GRANT ALL ON database.* TO 'user'@'somehost';

If you don't want to restrict the location from where the use will connect, use % for host

GRANT ALL ON database.* TO 'user'@'%';

Kindly post the error message.

[Sonasang]

Did you allow the user to connect remotely or only the SELECT privileges you have given? To allow remote connections, use such syntax in GRANT statement

GRANT ALL ON database.* TO 'user'@'somehost';

If you don't want to restrict the location from where the use will connect, use % for host

GRANT ALL ON database.* TO 'user'@'%';

Kindly post the error message.

Hi ,

I tried this option.. But in Mysql it is showing 0 rows affected..

Also the ASP pages which are just retrieved from the DB by using submitting option .. all r working fine...

But the pages which has to loaded with the data frm the database r throwing error...

The error is "Error in function() Operation is not allowed when the obj is closed"

This function() involves in getting the values from the DB and dispaly them in the Listbox when the page(ASP) loaded.....