LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 06-20-2005, 10:48 PM   #1
Joe_Zhu
Member
 
Registered: Dec 2003
Distribution: Debian, RedHat
Posts: 32

Rep: Reputation: 15
Question mysql administrator


I download the mysql administrator windows version. but after i installed it, i found it can't connect to my mysql server in my linux box .... since i can't find any document saying that it can only connect to the local mysql only, i would like to make sure does it really the case .....
thanks!

Joseph
 
Old 06-20-2005, 11:26 PM   #2
stefan_nicolau
Member
 
Registered: Jun 2005
Location: Canada
Distribution: Debian Etch/Sid, Ubuntu
Posts: 529

Rep: Reputation: 32
The MySQL administrator can connect to any MySQL server, local or not.
Make sure that MySQL listens on the correct network interfaces, and that the linux firewall is open on the right port. Can you connect to the server from the Windows machine with another program? Can you connect to the server from another remote host?
 
Old 06-22-2005, 05:08 AM   #3
Joe_Zhu
Member
 
Registered: Dec 2003
Distribution: Debian, RedHat
Posts: 32

Original Poster
Rep: Reputation: 15
what i should do in the my.conf so mysql can be connected from the network ?
thanks!!
 
Old 06-22-2005, 05:23 AM   #4
stefan_nicolau
Member
 
Registered: Jun 2005
Location: Canada
Distribution: Debian Etch/Sid, Ubuntu
Posts: 529

Rep: Reputation: 32
Comment the following line:
Code:
bind-address            = 127.0.0.1
or any other bind-address line
 
Old 06-22-2005, 05:51 AM   #5
Joe_Zhu
Member
 
Registered: Dec 2003
Distribution: Debian, RedHat
Posts: 32

Original Poster
Rep: Reputation: 15
now i can reach the mysqld from the window mysql adminstrator, but i can't login to the server. it result with a error number 1405. i am using the root user to login and in the error mesage, it show the login user is "root@mynotebook" ......
what happend ??
thanks!!
 
Old 06-22-2005, 05:55 AM   #6
stefan_nicolau
Member
 
Registered: Jun 2005
Location: Canada
Distribution: Debian Etch/Sid, Ubuntu
Posts: 529

Rep: Reputation: 32
It is ok. MySQL only allows root login from localhost. You should not disable this, but create a new user instead.
 
  


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
Restoring MySQL backups with mysql-administrator pnellesen Programming 0 04-25-2005 10:53 AM
How access MySQL by MySQL Administrator? treotan Linux - Newbie 5 12-04-2004 11:17 PM
MySQL Administrator eva Linux - Software 3 08-28-2004 11:54 PM
MySQL Administrator vs phpMyAdmin Ice Dragon Linux - Software 1 08-01-2004 05:15 PM


All times are GMT -5. The time now is 01:41 AM.

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