If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-27-04, 00:48
mikeb_usmc mikeb_usmc is offline
Registered User
 
Join Date: Apr 2004
Posts: 2
Angry 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

I've been working on this for 3 days now and have about had it. Can someone please help me!? I've installed 3 versions of MySQL from both rpm and binary. Currently working with the binary distro 'mysql-standard-4.1.1-alpha-pc-linux-i686'. No matter which version I get the same error messages:

<snip>

[root@localhost mysql_root]# ./bin/mysqld_safe --user=mysql &
[1] 18876
[root@localhost mysql_root]# Starting mysqld daemon with databases from /var/lib/mysql
040426 21:15:05 mysqld ended

[1]+ Done ./bin/safe_mysqld
[root@localhost mysql_root]# ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

</snip>

Some FAQ's:

No, the mysqld is not running. (and as you can see, it won't start)
No, the /tmp/mysql.sock file does not exist.
Yes, I read the manual (too many times maybe?)
O/S: Redhat AS

Which log file would give me an idea of what's going on?

I've installed MySQL many times over the years and have never had this much trouble before. I'm about to bag the whole thing and just install Oracle, which I think is just overkill (besides, it's HUGE!). Any suggestions?

Thanks,

-M
Reply With Quote
  #2 (permalink)  
Old 04-29-04, 08:39
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
What the error log says? (Obviously you didn't read enough because documentation reffers to messages in error log when error has occured)
Reply With Quote
  #3 (permalink)  
Old 04-29-04, 10:35
mikeb_usmc mikeb_usmc is offline
Registered User
 
Join Date: Apr 2004
Posts: 2
The error log said nearly the same error that's why I didn't post it here.

I have since solved the problem by compiling and installing from the source files and have not had any trouble. I guess sometimes you just have to start from scratch!

-M
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On