On Mon, 6 Jan 2003, Linux World 999 wrote:
----- Original Message ----- From: "Ole Kofoed Hansen"
On Thu, 2 Jan 2003, Linux World wrote:
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command.
Actually: Don't run mysql_install_db manually. Just start MySQL with "rcmysql start" and it will run mysql_install_db automatically as the proper mysql user, so MySQL does not have to run as root.
This is a "one off" command that does not need running again under normal circumstances. To start mysql use:
"safe_mysqld --user=root &"
This is also included in rcmysql start
When using rcmysql mysql does not start and hangs. Manually issuing the command "safe_mysqld" works.
This is quite likely because you had run mysql_install_db as root. Then MySQL's private databases are owned by root, and cannot be read by the mysql user that SuSE's rpms are set to use.
A better solution is to download the RPMs from MySql's site, install them manually using RPM commmand line and run the "mysql_install_db" once. After that, starting and stopping mysqljis easier. Using SuSE's bundled MySql package has its problems.
I have only had problems with SuSE's MySQL packages once and that was when I manually ran mysql_install_db. Regards Ole