Hi: Thanx for the response. But yes the "ZEUS.OLYMPUS.LOCAL" host is in the mysql.user database for the user root. There are 2 entries for the root user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and they both have the same global privileges set to ALL. I think that I have to add the IP address as an allowed host though, but I thought that the mySQL server could resolve the IP to the host name? Thanx!
-----Original Message----- From: O'K Web Design [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:06 AM To: Francisco Castellon Subject: Re: ERROR 2003: Can't connect to MySQL server on .... Hi I am not an expert but I would make all root privileges global and make sure you are allowing log in's by root into any host. It just sounds like "ZEUS.OLYMPUS.LOCAL" is not on your allowed list. As far as my understanding goes, if you are resolving an address, then it would try to connect using the 'not' local method. Mike ----- Original Message ----- From: "Francisco Castellon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: June 5, 2003 2:40 AM Subject: ERROR 2003: Can't connect to MySQL server on .... > Hello list: > > Just finished installing mySQL on a Linux Debian system and I have a > question about how the 2 root users that are set up by default. When I > look at my user table there is a root user allowed to log in from > "localhost" and also another root user but this one is only allowed to > log in from "host.mydomain.com" (host being the computer that the mySQL > server is installed in). I understand the difference since localhost is > when you are working on the computer itself (or remotely through ssh) > that has the mySQl server installed and that HOST.MYDOMAIN.COM is the > name of the localhost machine on the LAN. However, if you are accessing > the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same > thing as accessing from localhost? since in order to access the mySQL > server from HOST.MYDOMAIN.COM I would have to be at the machine itself > wouldn't the server just treat that connection as localhost? I have read > on the mysql.com site about how the mySQL server sorts the entries in > the user table at the time the server is started by priority of specific > entries to less specific ones, however if I have a password set for both > [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be > used? Not that it matters since the set of privileges are the same. I am > just really wondering if I need the extra entry of > [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would > I ever connect to the mySQL server using the [EMAIL PROTECTED] > account? > > Also I was trying to access the mySQL server using the root@ > HOST.MYDOMAIN.COM account by using the command below: > > Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p > Enter Password: ******* > > And this is what I get: ERROR 2003: Can't connect to MySQL server on > 'ZEUS.OLYMPUS.LOCAL' (111) > > I also tried using the IP of the server: > Shell> mysql -u root -h 192.168.1.8 -p > Enter Password: ******* > > And I still got: ERROR 2003: Can't connect to MySQL server on > '192.168.1.8' (111) > > What does that mean? I tried searching on the list archives but found > nothing on it. And I did check my /etc/hosts file and this is what is in > it: > > 127.0.0.1 localhost > 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS > > Any help would be appreciated it, thanx! > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]