Seperate MySQL server issues

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Jun 06, 2006 9:38 pm    Post subject: Seperate MySQL server issues Reply with quote

I just got another PC and I was going to use it as a dedicated MySQL server but Im having a small problem I cannot figure out (unlike me to not figure it out!).

Server 1: Main webserver
Server 2: Dedicated MySQL server

Whenever I try to connect to the MySQL server on server 2 using server 1 I get the error "#1130 - Host 'WEBSERVER' is not allowed to connect to this MySQL server".

Ive searched high and low for an option to allow external hosts to connect to the server but it simply wont allow it.

Any ideas?
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
richardyork
-


Joined: 22 Jun 2004
Posts: 386
Location: United Kingdom

PostPosted: Tue Jun 06, 2006 9:48 pm    Post subject: Reply with quote

Have you tried: http://www.phpfreaks.com/forums/index.php?showtopic=71738?

Ill keep trying....

EDIT:
Have you allowed access to all hosts, not just localhost?
_________________
Please SEARCH the forums BEFORE asking questions!
Back to top View user's profile Send private message Visit poster's website
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Jun 06, 2006 10:04 pm    Post subject: Reply with quote

I dont know HOW to allow access from all hosts. Thats the problem Im having.

I had a look at that thread but it looks like the command line bit is for linux seeing how most webservers are linux based these days.


EDIT: Managed to sort it out. I added "WEBSERVER" as a host in MySQLAdmin and it seems to work now. I just need to get everything set up as it was when it was on localhost.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
MonkeyNation
-


Joined: 05 Feb 2005
Posts: 921
Location: Cardiff

PostPosted: Wed Jun 07, 2006 3:28 am    Post subject: Reply with quote

Use % as a wildcard for the hostname.

Also most things for MySQL under *nix will work for windows.
_________________
Back to top View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger ICQ Number
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Jun 07, 2006 12:56 pm    Post subject: Reply with quote

Ive managed to sort this problem out now by adding the "Allowed host" to the user using MySQLAdmin. Took me a while to figure out but I got there in the end.

All my MySQL applications are running off the new dedicated SQL server. It seems to be a lot faster now and the main server isnt under as much load.

This could be the start of a number of servers!
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group