Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Accessing mysql Publicly
Posted by: Nexis (---.twcny.res.rr.com)
Date: April 13, 2007 03:42AM

I use wamp and mysql to store some data. I own a dot com that I need to access this mysql database but cannot get it to connect from my dot com host. I receive the following error:

Warning: mysql_connect() [function.mysql-connect]: Host 'myaddress' is not allowed to connect to this MySQL server in /site/test.php on line 10
Connection failed: Host 'myaddress' is not allowed to connect to this MySQL server

What steps do I need to take to accessing mysql publicly? Thanks.

Options: Reply•Quote
Re: Accessing mysql Publicly
Posted by: Nexis (---.twcny.res.rr.com)
Date: April 13, 2007 06:22AM

I figured this out. Anyone else that can't seem to connect to the mysql db remotely, all you need to do is enter phpmyadmin and add a new user under the 'privileges' tab. Allow this user only 'select' permissions and make it 'any user', 'any address', and no password. Worked for me.



Post Edited (04-13-07 06:22)

Options: Reply•Quote
Re: Accessing mysql Publicly
Posted by: CyberSpatium (71.237.217.---)
Date: April 13, 2007 08:21AM

to learn how to add users and permissions for mysql using phpmyadmin, check out the phpmyadmin section of my manual.


CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!

Please visit my latest website Clarify Loans:
clarifyloans.com


Like my free support? Help support me by making a donation today!

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login