MySQL install

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'

Give all privileges to root and user:

/usr/bin/mysql -u root -p Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 4.0.15 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'Password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'Password' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)
mysql> quit Bye


/usr/bin/mysqladmin version
(later "/usr/bin/mysqladmin -u root -p version" is necessary)

/usr/bin/mysqladmin variables
(later "/usr/bin/mysqladmin -u root -p variables" is necessary)

/usr/bin/mysqladmin -u root -p shutdown
(can you shutdown the server?)

sudo /usr/bin/mysqld_safe --log &
(can you start the server?)

ps -A | grep mysql
(check whether the server process is running)

/usr/bin/mysqlshow -u root -p
(show all databases)

/usr/bin/mysqlshow -u root -p mysql
(show the tables of database "mysql")

To start the mysql daemon at system startup, you should go to the runlevel editor (advanced mode) and toggle the status for the mysql entry of init.d