On Fri, 20 Dec 2002, Linux World 999 wrote:
Using SuSE 8.1, MySql database server has been installed. The install_db script runs fine. However, Mysql does not startup when booting. In the runlevel editor, MySQL service hangs if it is started. The kill command has to be used to stop mysql return linux back to a normal condition.
I assume you installed the RPMs, then ran the install_db script as root, and finally trid to start MySQL, correct?
To manually start MySql, the command "safe_mysqld --user=root &" works but the standard command "safe_mysqld --user=mysql &" will not start mysql and exists with an error.
This seems to fit with my assumption. It did the same to me in SuSE 7.3 when I ran the install_db script as root. The answer is to not run the install_db script manually. It is run automatically by the startup scripts the first time. Another answer is to modify ownership of the mysql databases. Right now they are only readable and writeable for root (The user that created them), and the mysql user has no access to them. Regards Ole