Hello.
>to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
MySQL tries to create mysqld.pid in /var/run/mysqld ('d' at the end) not
in /var/run/mysql directory.
>Description:
>050628 17:29:14 mysqld started
>050628 17:29:14 InnoDB: Database was not shut down normally!
.....................
>I>InnoDB: Apply batch completed
>050628 17:29:14 InnoDB: Started; log sequence number 0 43655
>050628 17:29:14 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write
>to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
>050628 17:29:14 [ERROR] Can't start server: can't create PID file: No
>such file or directory
>050628 17:29:14 mysqld ended
>
>>How-To-Repeat:
>[EMAIL PROTECTED] log]# cd /usr/local/mysql
>[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql&
>[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
>/var/lib/mysql
>STOPPING server from pid file /var/run/mysqld/mysqld.pid
>050628 17:53:10 mysqld ended
>
>
>>Fix:
> I wish I knew....
>
>#I have verified (chgrp, chown) that mysql is the owner and group of
>/usr/local/mysql/*
>
>[EMAIL PROTECTED] lib]# ll -d /var/lib/mysql
>drwx------ 4 mysql mysql 4096 Jun 28 17:53 /var/lib/mysql
>
>[EMAIL PROTECTED] mysql]# pwd
>/var/lib/mysql
>[EMAIL PROTECTED] mysql]# ll
>total 20532
>-rw-rw---- 1 mysql root 2368 Jun 28 17:53 antest1.err
>-rw-rw---- 1 mysql mysql 10485760 Jun 28 14:03 ibdata1
>-rw-rw---- 1 mysql mysql 5242880 Jun 28 17:53 ib_logfile0
>-rw-rw---- 1 mysql mysql 5242880 Jun 28 14:03 ib_logfile1
>drwx------ 2 mysql mysql 4096 Jun 28 14:00 mysql
>srwxrwxrwx 1 mysql mysql 0 Jun 28 17:53 mysql.sock
>drwx------ 2 mysql mysql 4096 Jun 28 14:00 test
>
>
>[EMAIL PROTECTED] run]# pwd
>/var/run
>[EMAIL PROTECTED] run]# ll -d mysql
>drwxrwxrwx 2 mysql mysql 4096 Jun 28 16:58 mysql
>
>******** NOTE *******
>/var/run/mysql is empty. I tried creating the mysqld.pid
>
>file (with mysql as owner and group) but still get the same pro
"Ralph Jackson" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
