LinuxQuestions.org
Help answer threads with 0 replies.
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 10-12-2003, 05:47 PM   #1
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
mysql --mysql.sock not found


Hello everybody,

The problem Iím having has been discussed many times over but I havenít been able to locate a conclusive answer to resolve my issue..

The error message I get starting mysql t ŗ error 2002: Canít connect to local mysql server through socket Ď/tmp/mysql.sockí(2).

Before I installed mysql, I looked at several different installation methods and was able to successfully install mysql. The instructions I installed from: http://www.dmxzone.com/ShowDetail.asp?NewsId=1215.

-Redhat 9
-downloaded the source code and compiled and installed mysql v4.
-only thing I havenít done is change the password but thatís another problem Iím having..
I looked in /tem/mysql.sock and nothing there to be found.. Iím new so Iím assuming this file gets created at Mysql startup.
did a search for mysql.sock and itís no where to be found.
-mysql is installed under /wwwroot/mysql
tried the following commands to start the mysql serverÖ/wwwroot/mysql/bin/mysql start( displays the above message). Ö/wwwroot/mysql/bin/mysqld_safe Ėuser=mysql &(msg=command not found), /wwwroot/mysql/lib/mysql start still no goÖalos tried mysql.server.

my.cnf Ėport is pointing to 3306

-my research, also pointed to this folder /var/lib/mysql/mysql.sock but mysql.sock isnít there either..

3 days of reading and figuring out whats wrong with mysql hasnít produced any results.
What am I missing other then my hair that I lost trying to figure this outÖ

Help
Robin
 
Old 10-12-2003, 06:13 PM   #2
nakkaya
Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
did you start the mysql deamon before looking for the sock file it has to be running to accept connections if not do /sbin/service mysql start (it could be mysqld) that should start it and then u can connect to it
 
Old 11-12-2003, 12:17 PM   #3
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
Also type hostname at a prompt, if it is not localhost, then type hostname localhost....and then go and start the mySQL service.
 
  


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
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-08-2008 12:48 AM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 01:46 AM
can't connect to mysql through socket '/tmp/mysql.sock' Boby Programming 2 05-23-2004 02:32 PM
MySQL server problem after linking (mysql.sock) ewijaya Linux - General 4 01-19-2004 10:46 AM


All times are GMT -5. The time now is 03:42 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