Francisco Castellon schrieb:
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]



Reply via email to