How access MySQL by MySQL Administrator?

treotan · 12-03-2004, 05:39 AM

I installed MySQL-server 4.1.7(.rpm) to my Fedoral machine; and installed MySQL Administrator to my windows 2000, then I connect the MySQL by MySQL Administrator; But it failed to login.

Username: root
Password: mypw
Hostname: 192.168.1.4
Port: 3306

Why it was failed?

wiskic10_4 · 12-03-2004, 05:52 AM

tretan,

Are you sure that 192.168.4.1 is the actual host? Sounds like a gateway address to me... But then, I could be wrong...

Double check the hosts IP address, or even try a hostname, if you've a DNS setup...

-Wiski

treotan · 12-03-2004, 09:05 AM

Yes I sure that the hostname is correct; I tried access by IP / domain name, it still failed! Anything I need config the mysql server first?

j0217995 · 12-03-2004, 09:10 AM

Check in the my.cnf and see if skip-networking is not commented out. MySQL by default in the 4.x.x series, if I recall corectly does not allow network access by default. Change the my.cnf and then restart your mysql server.

Let me know if this works

treotan · 12-03-2004, 09:52 AM

I tried to active(skin-networking) and de-active (#skin-networking) the skip-networking as my.cnf; It still cannot be login sucessful. Anything I can try?

Thks

dominicc · 12-04-2004, 10:17 PM

MySQL doesn't use UNIX users/groups for it's privileges. By default (IIRC), only root can access from the localhost (no password needed). After that you can set up finely grained access rights: (user name, host) -> (global, db, and table rights). Check the MySQL manual for more details.