LinuxQuestions.org
Review your favorite Linux distribution.
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 08-01-2006, 12:36 PM   #1
scott.anderson
Member
 
Registered: Mar 2005
Location: Natick, MA
Distribution: Redhat EL 5.2, Fedora 8
Posts: 30

Rep: Reputation: 15
mysql client can't connect to server (5.0.22)


I'm running MySQL on RedHat EL AS Release 3.

I was having trouble resetting the root password in 4.1.9, so I upgraded to 5.0.22, since I recalled there being an explicit step in which the root password was set. However, when I got to that step, the command didn't work. That is: I started the server, and checked that it was running, and then here's what happened:

# mysqladmin -u root password 'blahblah'
mysqladmin: connect to server at 'puma' failed
error: 'Can't connect to MySQL server on 'puma' (4)'
Check that mysqld is running on puma and that the port is 3306.
You can check this by doing 'telnet puma 3306'

I did check that the server was running (using "ps"), and according to "nmap", it's running on port 3306, but the telnet command hangs and eventually (several minutes) times out.

Any ideas why I can't connect to the server? I was able to connect to the server in 4.1.9 (I just couldn't reset the password), so it seems like it's related to the upgrade. I haven't changed the firewall or anything else.

Thanks for any suggestions.

Scott
 
Old 08-01-2006, 03:32 PM   #2
scott.anderson
Member
 
Registered: Mar 2005
Location: Natick, MA
Distribution: Redhat EL 5.2, Fedora 8
Posts: 30

Original Poster
Rep: Reputation: 15
Re: mysql client can't connect to server (5.0.22)

When I tried "telnet localhost 3306" as well as "telnet puma 3306" and the first worked while the second failed, I realized that the problem was with DNS. It turned out there was a mistaken IP address for Puma in /etc/hosts. So, the connection problem is solved. I now need to solve the password problem. :-)

Scott
 
  


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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 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
can not connect to my pureftp server from Linux client, but i can from windows client bonito Suse/Novell 5 03-16-2005 10:45 PM


All times are GMT -5. The time now is 02:32 AM.

Main Menu
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