mysql cannot start...........
 

Dear friends,

I have installed MySQL
MySQL-client-standard-4.1.14-0.rhel4.i386.rpm
MySQL-devel-standard-4.1.14-0.rhel4.i386.rpm
MySQL-server-standard-4.1.14-0.rhel4.i386.rpm
MySQL-shared-standard-4.1.14-0.rhel4.i386.rpm

but i don't know why everytime i start mysql is says
"MySQL Pid could not be found!
MySQL start failed


If i use the default mysql 3.23 it works ok to start, but if i install the MySQL above it doesn't work....always come out with this error.
I have tried everything,format everything and do over again.
There is now MySql pid file in /var/lib/mysql....

actually i have asked this question long time ago but couldnt find the answer to solve the problem....has anyone got any new encounter to solve it?..pls help me...i am really stuck..

thanks for taking time reading my thread..

Regards
Y

Did you start the mysql server? (mysqld, mysql_safe, etc)?
"mysql" only starts the client. It will need a running server to work.
The PID file contains the process ID of the running MySql server, probably. So, no PID file means no running server in most cases.

Hi Timmeke,

thanks for your reply.
I found mysqld in /usr/sbin but when i attempt to start it, it gives me, I still can't start mysql service.

I tried the following commands:
1) /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/sy_shipping1.shinyang.com.my.pid
060805 09:01:49 mysqld ended


And the error file doesn't say much, simply as below:
060805 08:49:31 mysqld started
060805 08:49:31 mysqld ended

060805 08:53:39 mysqld started
060805 08:53:39 mysqld ended

060805 08:55:24 mysqld started
060805 08:55:24 mysqld ended

060805 08:57:39 mysqld started
060805 08:57:39 mysqld ended

If i do service mysql restart, it still give me the same error:
service mysql restart
MySQL PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

there is still no mysql.sock file in /var/lib/mysql, i have got mysql user and group created, changed permission for mysql folder to be owned by mysql user and group.

I have searched through mysql forum, a few people faced the same problem but the thread ended where it started.

.....any more help..? pls help...thanks for taking time reading my cries...

Regards
Y

maybe you need to check in what folder mysql is writing the pid and make sure the mysql user can write to that folder.

hi friends,

finally i have got it working...i don't know what exactly i did to make it work.

I think is one of these:
- I followed the instruction here: http://www.vias.org/linux-knowhow/lnag_09_06.html, i think after i did that i have got the mysql.sock file created in /var/lib/mysql folder.
I am not exactly sure if it was the /usr/bin/mysql_install_db command that created the mysql.sock file, but anyway, after i got that mysql.sock file in there, things were great.
I tried to start it, initially it has a problem, i checked the error file, it was about the innode table thingi, once i clear that error, it starts ok.

Maybe it was because i didn't create mysql user...thats why i couldn't start...but ia m not sure the exact problem. so if anyone have the same problem, maybe you can try the website stated above. the instruction might help. hopefully...

thanks for helping guys!

Regards
Y

Just make sure that you secure your server of that is already secured if you are not behind a firewall, while the server is running port 3306 is opened to connections.

All right. thanks friend!