db connecting from everyelse except from the website.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post by lostboy »

have you configged a user to connect to the db from ip in question?
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

Thats what I tried to search in phpinfo. Isn't this kind of info available in phpinfo ? I am not running the webhost so I cannot check out the php.ini values.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

phpinfo() won't contain the configuration info for mysql.. that'd be inside it's user rights/privledges tables..
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

All right. So I got to contact my host and tell him to add the priv ?....Or can I do that in phpmyAdmin ?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

depending on how they set up your phpMyAdmin system, you could be able to do it there. Basically, if you see a privledges link when you first log into phpMyAdmin, you can edit the privs. You may not be able to add a user however.. I'd check with your host once you check that out.
Post Reply