LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Slackware (https://www.linuxquestions.org/questions/slackware-14/)
-   -   mysql pid error (https://www.linuxquestions.org/questions/slackware-14/mysql-pid-error-560596/)

nbf 06-10-2007 03:38 AM

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 ?????

digitalboy74 06-10-2007 04:08 AM

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?

cheezmode 06-12-2007 04:12 AM

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

Alien Bob 06-12-2007 05:22 AM

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

cheezmode 06-13-2007 12:19 AM

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.

nbf 06-13-2007 01:05 AM

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.

Alien Bob 06-13-2007 01:34 AM

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

digitalboy74 06-13-2007 07:45 AM

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.


All times are GMT -5. The time now is 06:21 AM.