LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices



Reply
 
Search this Thread
Old 12-03-2004, 06:39 AM   #1
treotan
Member
 
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
Hostname: 192.168.1.4
Port: 3306

Why it was failed?
 
Old 12-03-2004, 06:52 AM   #2
wiskic10_4
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
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
 
Old 12-03-2004, 10:05 AM   #3
treotan
Member
 
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, 10:10 AM   #4
j0217995
Member
 
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, 10:52 AM   #5
treotan
Member
 
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?

Thks
 
Old 12-04-2004, 11:17 PM   #6
dominicc
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.
 
  


Reply


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 04:46 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
mysql administrator Joe_Zhu Linux - Software 5 06-22-2005 05:55 AM
Restoring MySQL backups with mysql-administrator pnellesen Programming 0 04-25-2005 10:53 AM
MySQL Administrator eva Linux - Software 3 08-28-2004 11:54 PM


All times are GMT -5. The time now is 06:51 PM.

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