Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-03-2004, 05:39 AM   #1
Registered: Jun 2004
Posts: 126

Rep: Reputation: 15
How access MySQL by MySQL Administrator?

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
Port: 3306

Why it was failed?
Old 12-03-2004, 05:52 AM   #2
LQ Newbie
Registered: Oct 2004
Location: Odessa, TX
Distribution: Slackware 10.0, Debian 3.0, FC2, and various Live CD's
Posts: 20

Rep: Reputation: 0

Are you sure that 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...

Old 12-03-2004, 09:05 AM   #3
Registered: Jun 2004
Posts: 126

Original Poster
Rep: Reputation: 15
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?
Old 12-03-2004, 09:10 AM   #4
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Rep: Reputation: 15
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
Old 12-03-2004, 09:52 AM   #5
Registered: Jun 2004
Posts: 126

Original Poster
Rep: Reputation: 15
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?

Old 12-04-2004, 10:17 PM   #6
LQ Newbie
Registered: Nov 2003
Location: Valencia, Spain
Distribution: RedHat 9
Posts: 2

Rep: Reputation: 0
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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Administrator Meabert Linux - Software 6 06-08-2006 03:46 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
mysql administrator Joe_Zhu Linux - Software 5 06-22-2005 04:55 AM
Restoring MySQL backups with mysql-administrator pnellesen Programming 0 04-25-2005 09:53 AM
MySQL Administrator eva Linux - Software 3 08-28-2004 10:54 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:44 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration