Hi Francisco, please login to your mysql server and do this:
SHOW GRANTS FOR username; Thats probably the fastes way to troubleshoot this issue. If you really have 2 entries for the same user than t depends on 2 things which one takes precedence 1) which entry is mor specific or 2) which order they come in the mysqls privilege system. There are two reports on devshed which I believe are an excellent source. There is really nothing to add. Print them off read them carefully on your way home and tomorrrow you will be 2 steps further. http://www.devshed.com/Server_Side/MySQL/Access/page1.html http://www.devshed.com/Server_Side/MySQL/Grant_Tables/page1.html http://www.devshed.com/Server_Side/MySQL/Administration/page1.html They also offer printer friendly formats. I hope you dont think ... hmm just another document ;-). They are really worth the time. Please let me know the output of SHOW GRANTS FOR username; I am am confident to be able to help you quickly knowing the ouptut. Best regards Nils Valentin Tokyo/Japan 2003年 6月 6日 金曜日 09:41、Francisco Castellon さんは書きました: > 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! -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
