Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Initial install of MYSQL - cannot connect via IP

Status
Not open for further replies.
Aug 24, 2003
1
US
I just installed mysql on a windows 2000 server with IIS. This server is used for web hosting. I cannot create a database or connect using an IP address. I get the following error:

Host '209.15.xxx.xxx' not allowed to connect to this MySQL server

I have specified the correct credentials and ip and port number. Is there something that I additionally need to configure in order to connect via an IP address?

Any help would be GREATLY appreciated!!!!!
 
On the server, add any entry in the user table of the mysql database to allow connections from Host '209.15.xxx.xxx'
eg. INSERT INTO user VALES ('209.15.%','root',...)
with the privileges you want the user to have.

The above will allow the user to connect from an machine in the 209.15.x.x range. You can narrow that down to just the one IP or the entire range.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top