You need to create a symbolic link ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock or ln -s /tmp/mysql.sock mysql.sock
Do a search to find where it's at first though<G> locate mysql.sock Mike -----Original Message----- From: Intrex [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 8:14 PM To: MySQL Subject: Re: mysql.sock Well, my MySQL server is not running. I have followed all of the instructions to install, and no matter what commane I run the server does not run, and I get the error I mentioned below. locate mysql.sock provides nothing. I am just about to go back to Win2k and IIS. God the though of that makes me cringe. Running mysqladmin ping provides this message: mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server socket through socket 'tmpmysql.sock' (2) Check that mysql is running ans that the socket: 'tmp/mysql.sock' exists! I take it that when the mysql server is running that this file is created, and that this file is needed to get the server running. Seems like the chicken and the egg routine. Can't have one without the other, and visa versa. I am in a quandry as to how to get this silly thing going. what am I missing. I have gone even to the point of trashing my whole SuSE system and reinstalling. All to no avail. I even installed Red Hat 7.0 and installed the mysql on it and still recieve the same errors. I am sure my problem is not an original one. I do appreciate any help in this, since this is my first experience with mysql, and I am a relative Linux noob. Mark ----- Original Message ----- From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: "Intrex" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 9:33 PM Subject: Re: mysql.sock > First of all, are you sure MySQL is running? The mysql.sock file only > appears when the server is running. Run the following command on the command > line to make sure: > > ps awx | grep mysqld > > You should see one line with "safe_mysqld" in it, and at least a few lines > with "mysqld" in them. If not, you need to start the server. Once the server > is running, if you have superuser privileges on your system, you can run: > > updatedb > > This will take a few seconds and re-index all the files on your system, so > you can run: > > locate mysql.sock > > to find out where the server is creating the socket. This command should > give you the path to the mysql.sock file. Once you have that, look in your > my.cnf file for lines like: > > [client] > port = 3306 > socket = /path/to/mysql.sock > > [mysqld] > port = 3306 > socket = /path/to/mysql.sock > > The "socket" variable is where MySQL *thinks* your mysql.sock should be -- > not necessarily where it is. Change these lines to match the path returned > by the "locate" command and things should work. If you don't have superuser > access and you can't run "updatedb", the most likely places for mysql.sock > are your installation directory (where the data files are stored), and: > > /var/tmp/mysql.sock > /var/lib/mysql/mysql.sock > > At least on RedHat -- I'm not sure about SUSE, but it's worth a look. Check > these places and see if it exists. If you find it, update your my.cnf file > with the correct path. > > Good luck! > > --jeff > > ----- Original Message ----- > From: "Intrex" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, March 02, 2002 5:26 PM > Subject: mysql.sock > > > > Ok here it is. I get that annoying error. ERROR 2002: Can't connect to > > local MySQL server through socket /var/lib/mysql/mysql.sock (111) > > > > Ok now I DO NOT have a mysql.sock anyplace on my system. I have > downloaded > > the "stable" .tar.gz and unzipped it and still do not have a mysql.sock > > > > Somepleaze tell me how to create it, or what to pu in it. Please DO NOT > > tell me about changing paths and stuff, I have done that till i am blue in > > the face. > > > > Or please e-mail me a copy of a mysql.sock. > > > > I am running SuSE 7.3 and mysql version Ver 11.15 Distrib 3.23.41 > > > > I also have the current 3.23.49a. any help would be appreciated. > > > > Mark > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
