File README.SUSE of Package mysql-5.1.59 - j0ke.net Open Build Service

File README.SUSE of Package mysql-5.1.59 (Revision 1a07f36c36d2fa2b0809818e9dc2fd0c)

Currently displaying revision 1a07f36c36d2fa2b0809818e9dc2fd0c, show latest

Release notes for MySQL on SuSE Linux
                     -------------------------------------

Last change: 2004-09-01
Author: Tomas Crhak

Starting MySQL:
^^^^^^^^^^^^^^^
To start up MySQL manually, run the command "rcmysql start", which will
execute the init script /etc/init.d/mysql. During the very first startup,
the init script will create the privilege database files in
/var/lib/mysql/mysql. This is necessary, since they contain the host name of
your machine for access control purposes, which may not be known during the
initial installation.

You are also advised to run the mysql_upgrade program after each upgrade
to fix potential incompatibilities in all tables. See this chapter in the
mysql manual: http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html

If you want to automatically start MySQL at bootup, the init script
/etc/init.d/mysql must have symbolic links pointing to it in the respective
runlevel directory /etc/init.d/rc?. This can easily be accomplished by using
YaST2's runlevel editor or by manually creating the symbolic links by
executing

/sbin/insserv /etc/init.d/mysql

It is not necessary to run SuSEconfig afterwards.

To disable the automatic startup of MySQL on bootup, you can use the YaST2
runlevel editor as well as insserv, using the "-r" parameter:

/sbin/insserv -r /etc/init.d/mysql

(See the insserv(8) and init.d(7) man pages for more info about the SuSE
bootup and initialization scheme)

The packages have been split in a similar fashion to the original RPMs
from MySQL AB.

MySQL consists of six packages:

mysql        - the MySQL Server
 mysql-client - the MySQL Client (including Perl Libraries)
 mysql-devel  - runtime libraries and header files
 mysql-bench  - SQL benchmarks
 mysql-shared - MySQL shared libraries
 mysql-Max    - a server binary compiled with Berkeley DB and Innodb support

MySQL daemon mysqld runs with the user ID "mysql" and the group ID "mysql".
The database and log files are located below /var/lib/mysql
and are owned by mysql:mysql.

Updating from older SUSE Linux:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The previously installed version of MySQL ran as group "daemon" and the
group ID of the database and log files used to be "daemon" (some of them)
and "root" (other files) on SUSE Linux < 9.2. It is changed to "mysql"
during update.

On SUSE Linux < 7.1, the database and log files were located below /var/mysql,
these are moved to /var/lib/mysql during update if necessary to comply FHS.
Also, the packages had the following names:

old         new
 ----------------------------------------------------------
 mysqclnt -> mysql-client 
 mysqldev -> mysql-devel
 mysqbnch -> mysql-bench
 mysqllib -> mysql-shared
 mysqperl -> perl-Msql-Mysql-modules & perl-Data-ShowTable
 ----------------------------------------------------------

Yet older versions of MySQL (SUSE Linux < 6.3) ran as user "root".
The ownerships of your existing database files have been adjusted
accordingly as well during update.

If you are upgrading from a MySQL version <= 3.22.10 you should also
run the script /usr/bin/mysql_fix_privilege_tables. Otherwise you will
not be able to use the new GRANT command!

Benchmarks:
^^^^^^^^^^^
If you like to run some database benchmarks, install package "mysql-bench"
and start the script "run-all-tests" in the directory /usr/share/sql-bench
after starting MySQL. This requires the MySQL Perl modules to be installed.

Have a lot of fun...

Your SUSE-Team