Starting MySQL as a Service - TechRepublic
General discussion
November 23, 2002 at 09:04 AM
coderoyal

Starting MySQL as a Service

by coderoyal . Updated 23 years, 3 months ago

Hi,

I’ve been having trouble getting MySql to start as a service on my Linux box. When I type in:

service mysql start

I get the following result:

[root@donthyde mysql]# Starting mysql daemon with databases from /var/lib/mysql
021123 19:38:54 mysql ended

For some reason, MySQL suddenly just quits.

I try running MySQL after the above message and get:

ERROR 2002: Can’t connect to local MySQL server through socket’/tmp/mysql.sock’

I am able to start MySQL manually however, by using the command (when in the MySQL root directory)

./bin/mysqld
or the safe_mysqld

Note though…
When I use the service mysql start command, although it says MySQL has ended, the daemon is still loaded in memory, but I can’t quit it or use it. (use a PS -A to see it there)

This means that if I want to start MySQL, I must start it directly using the ./bin/mysqld script

Other than that, MySQL works ok!

I’d appreciate any support anyone can give!

Thanks!
Alan Owen
Student Computer Technician
Hermon School Department

This discussion is locked

All Comments