By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,742 Members | 793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,742 IT Pros & Developers. It's quick & easy.

How to access the remote database in MYSQL

P: 27
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
Dec 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: 4
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
Dec 14 '07 #2

mwasif
Expert 100+
P: 801
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
Expand|Select|Wrap|Line Numbers
  1. 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
Expand|Select|Wrap|Line Numbers
  1. GRANT ALL ON database.* TO 'user'@'%';
Kindly post the error message.
Dec 14 '07 #3

P: 27
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
Expand|Select|Wrap|Line Numbers
  1. 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
Expand|Select|Wrap|Line Numbers
  1. 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.....
Dec 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.