MySQ help

gabebster · 08-09-2003, 11:16 AM

I get this error when i try to start MySQL.

linux:/usr/share/mysql # ./mysql.server start
linux:/usr/share/mysql # Starting mysqld-max daemon with databases from /var/lib/mysql
030809 11:14:01 mysqld ended

Does anyone have any suggestions

gabebster

david_ross · 08-10-2003, 08:25 AM

See if there is an option to run that script in a more verbose mode:
mysql.server --help
man mysql.server

gabebster · 08-10-2003, 04:53 PM

It gives me this error when sometimes.

No mysqld pid file found. Looked for /var/lib/mysql/linux.pid.

What is the linux.pid ? I don't have one in that folder.

gabebster

captain1 · 08-10-2003, 05:27 PM

The pid file stores the process id of the mysql process. It is also used by mysql to check if it is running or if did not stop gracefully. You may want to check to see if there are any meaningful messages /var/lib/mysql/linux.err.

Also verify that the userid running mysql has read/write authority to /var/lib/mysql/

Hope this helps.