LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices



Reply
 
Search this Thread
Old 06-10-2007, 04:38 AM   #1
nbf
LQ Newbie
 
Registered: Jun 2007
Posts: 4

Rep: Reputation: 0
mysql pid error


need some help whit mysql
first i get some pid error on boot pid 2
after i have tryed to chance some of the things in this forum
i dont get the error but not sure if its running probely
how to find out ?
if i try in root to type mysql i get error 2002 hy000 cant connect to local mysql server trough socket /var/run/mysql/mysql.sock(2)
if i run a ls in that dir its empty ?????

Last edited by nbf; 06-10-2007 at 04:44 AM.
 
Old 06-10-2007, 05:08 AM   #2
digitalboy74
Member
 
Registered: Aug 2004
Location: Matrix
Distribution: slack currrent
Posts: 61

Rep: Reputation: 16
That implies mysql is not running

What is the output of "ps aux |grep mysqld"

Note that the Readme has instructions on setting up mysql, have you su - mysql and followed the instructions on creating the mysqld tables?
 
Old 06-12-2007, 05:12 AM   #3
cheezmode
LQ Newbie
 
Registered: Feb 2007
Location: Kenya
Distribution: slackware
Posts: 19

Rep: Reputation: 0
The default mysql startup script is crap!!
in the rc.d directory back up the default rc.mysqld and write up a new one with the following contents:
mysql_safe --user root &

the restart teh mysql deamon
 
Old 06-12-2007, 06:22 AM   #4
Alien Bob
Slackware Contributor
 
Registered: Sep 2005
Location: Eindhoven, The Netherlands
Distribution: Slackware
Posts: 5,390

Rep: Reputation: Disabled
Quote:
Originally Posted by cheezmode
The default mysql startup script is crap!!
in the rc.d directory back up the default rc.mysqld and write up a new one with the following contents:
mysql_safe --user root &

the restart teh mysql deamon
This is advice of the worst possible category.

Please ignore this "advice" since using the command "mysql_safe --user root &" is not resolving the issue properly. There is a reason for letting the mysql daemon not run under the root account, and that reason is security. If you don't care about security, that gives you no right to advise other people to toss any sense of security overboard as well.

The instructions in the header of the mysqld startup script (/etc/rc.d/rc.mysqld) are quite clear, and following them to the letter should get you a working mysql daemon.

Eric
 
Old 06-13-2007, 01:19 AM   #5
cheezmode
LQ Newbie
 
Registered: Feb 2007
Location: Kenya
Distribution: slackware
Posts: 19

Rep: Reputation: 0
hey! no need to hate man. it works perfectly for me coz for one i am the only user on my machine. then give us a solution.
 
Old 06-13-2007, 02:05 AM   #6
nbf
LQ Newbie
 
Registered: Jun 2007
Posts: 4

Original Poster
Rep: Reputation: 0
Thumbs up pid error

hey and thanks for the reply.
i tryed a nother kern contos 5 and its working almost as i like i to run, oki have to find some more gui to handle the software.
 
Old 06-13-2007, 02:34 AM   #7
Alien Bob
Slackware Contributor
 
Registered: Sep 2005
Location: Eindhoven, The Netherlands
Distribution: Slackware
Posts: 5,390

Rep: Reputation: Disabled
Quote:
Originally Posted by cheezmode
hey! no need to hate man. it works perfectly for me coz for one i am the only user on my machine. then give us a solution.
I pointed to the solution - it is there, in your Slackware, for all to read:
Quote:
The instructions in the header of the mysqld startup script (/etc/rc.d/rc.mysqld) are quite clear, and following them to the letter should get you a working mysql daemon
I am not going to repeat that instruction here. Go read it. It is not crap.

Eric
 
Old 06-13-2007, 08:45 AM   #8
digitalboy74
Member
 
Registered: Aug 2004
Location: Matrix
Distribution: slack currrent
Posts: 61

Rep: Reputation: 16
Oh my.

RTFM, works for me as well, but I am almost not surprised by the comment to simply run mysql as root. I think some distro's tried using a single user too. wasnt that Lindows?

I had not thought about running slack like that though, actually I find that thought is a bit sad.
 
  


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 error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
ERROR! MySQL PID file could not be found! Niceman2005 Linux - Software 1 06-02-2005 07:29 AM
daemon pid error! zecodela Linux - Software 0 10-23-2004 09:07 AM
/var/run/[XXX].pid - Tcl pid code liguorir Linux - Software 1 05-20-2004 11:32 PM
ERROR: Couldn't write pid to pid file lawrencegoodman Linux - Newbie 2 02-13-2004 09:05 PM


All times are GMT -5. The time now is 11:46 PM.

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