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!
check it with tcpdump -ilo port 3306 tcpdump -ieth0 port 3306 ... ping 192.168.1.8 telnet 192.168.1.8 3306 nmap -p3306 zeus.olympus.local ...
<hint> $ sed s/" "/""/g endlos.txt >endloslang.txt
Hellolist:
JustfinishedinstallingmySQLonaLinuxDebiansystemandIhavea questionabouthowthe2rootusersthataresetupbydefault.WhenI lookatmyusertablethereisarootuserallowedtologinfrom "localhost"andalsoanotherrootuserbutthisoneisonlyallowedto loginfrom"host.mydomain.com"(hostbeingthecomputerthatthemySQL serverisinstalledin).Iunderstandthedifferencesincelocalhostis whenyouareworkingonthecomputeritself(orremotelythroughssh) thathasthemySQlserverinstalledandthatHOST.MYDOMAIN.COMisthe nameofthelocalhostmachineontheLAN.However,ifyouareaccessing themySQLserverfromHOST.MYDOMAIN.COMisn'tthattechnicallythesame thingasaccessingfromlocalhost?sinceinordertoaccessthemySQL serverfromHOST.MYDOMAIN.COMIwouldhavetobeatthemachineitself wouldn'ttheserverjusttreatthatconnectionaslocalhost?Ihaveread onthemysql.comsiteabouthowthemySQLserversortstheentriesin theusertableatthetimetheserverisstartedbypriorityofspecific entriestolessspecificones,howeverifIhaveapasswordsetforboth [EMAIL PROTECTED]@HOST.MYDOMAIN.COMthenwhichconnectionwouldbe used?Notthatitmatterssincethesetofprivilegesarethesame.Iam justreallywonderingifIneedtheextraentryof [EMAIL PROTECTED]@localhost.Andhowwould [EMAIL PROTECTED] account?
AlsoIwastryingtoaccessthemySQLserverusingtheroot@ HOST.MYDOMAIN.COMaccountbyusingthecommandbelow:
Shell>mysql-uroot-hZEUS.OLYMPUS.LOCAL-p EnterPassword:*******
AndthisiswhatIget:ERROR2003:Can'tconnecttoMySQLserveron 'ZEUS.OLYMPUS.LOCAL'(111)
IalsotriedusingtheIPoftheserver: Shell>mysql-uroot-h192.168.1.8-p EnterPassword:*******
AndIstillgot:ERROR2003:Can'tconnecttoMySQLserveron '192.168.1.8'(111)
Whatdoesthatmean?Itriedsearchingonthelistarchivesbutfound nothingonit.AndIdidcheckmy/etc/hostsfileandthisiswhatisin it:
127.0.0.1localhost 192.168.1.8ZEUS.OLYMPUS.LOCALZEUS
Anyhelpwouldbeappreciatedit,thanx! </hint>
-- shrek-m
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]