mysql

After installing the Suse 9 rpm, execute the following commands:

sudo /usr/bin/mysql_install_db
(Creating default databases & permissions. Apparently the same can be done by "sudo rcmysql start")

sudo /usr/bin/mysqld_safe --user=mysql &
(Start the server for the first time)
REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with:

/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h hostname password 'new-password'

If you have forgotten your MySQL root password, you can reset it if you have physical access to the machine mysql is running on:

1. Dump the database data mysqldump --host=localhost --user=root -p journal >journal.sql
2. Create the databse on the new machine mysql -u root -p CREATE DATABASE journal;
3. Import the data into the database mysql -p -h localhost journal < journal.sql
4. Create the user 'journal' GRANT ALL PRIVILEGES ON *.* TO 'journal'@'localhost' IDENTIFIED BY 'journal' WITH GRANT OPTION;