----- 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. 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. __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com