File README.SuSE of Package mysql

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

Last change: 2001-07-30
Author: Lenz Grimmer <grimmer@suse.de>

To start up MySQL, 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. If you want to enable MySQL at bootup, set the variable
START_MYSQL in file /etc/rc.config to "yes". This can be accomplished by
using YaSTs rc.config editor or by directly editing the file. It is not
necessary to run SuSEconfig afterwards.

The packages have been splitted in a similar fashion to the original RPMs
from TCX.

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

Starting with SuSE Linux 7.1, these subpackages have been renamed according
to the original MySQL spec file. In previous releases of SuSE Linux, these
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
 ----------------------------------------------------------

Please note, that the former subpackage "mysqperl" is no longer part of the
MySQL source RPMs, it has now been split into two separate packages
"perl-Msql-Mysql-modules" and "perl-Data-ShowTable". The MySQL Perl module
package "perl-Msql-Mysql-modules" does only contain support for MySQL - if
you need mSQL support as well, you have to recompile this module with the
mSQL header files installed. These are not part of SuSE Linux and can be
downloaded seperately from http://www.hughes.com.au/

Starting with SuSE Linux 6.3, MySQL runs with the user ID "mysql" instead of
"root" due to security reasons. If you are upgrading from a previous
version, the database files below /var/mysql will be automatically changed
to user "mysql" group "daemon" by the post-installation routine of the
package.

Beginning with SuSE Linux 7.1, the database and log files are now located
below /var/lib/mysql instead of /var/mysql to comply with the File System
Hierarchy Standard (FHS). If you are updating from a previous version, the
files will be copied to the new location in the postinstall section of the
mysql RPM. You should remove the old database files in /var/mysql afterwards
(if everything runs fine, of course).

In addition to that, the MySQL socket has been moved from /tmp/mysql.sock to
/var/lib/mysql/mysql.sock. Make sure to adjust the paths in /etc/my.cnf to
point to the new location, if you have modified this configuration file
manually (RPM will not remove it in that case, so the new location will not
be taken over).

Starting with MySQL version 3.23.41 (SuSE Linux 7.3), we have enabled TCP
wrapper support as a security enhancement by enabling the "--with-libwrap"
compile option.  Please make sure to adjust /etc/hosts.allow and
/etc/hosts.deny accordingly, if you need to grant access to remote hosts.

Also starting with 3.23.41, there now is an additional package "mysql-Max",
that includes new features and enhancements like BerkeleyDB and InnoDB
support. If you want to use these features, simply install this package in
addition to the normal "mysql" server package - the start script will
automatically start the mysqld-max binary instead of the normal one.

NOTE: 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! See the MySQL documentation
for more info.

A note about the new 3.23.x features like replication and BerkeleyDB: We did
not enable these features in the standard binary yet, because of the
comments on http://www.mysql.com/doc/N/e/News-3.23.x.html:

"The replication code and BerkeleyDB code is still not as tested and as
  the rest of the code, so we will probably need to do a couple of future
  releases of 3.23 with small fixes for this part of the code. As long as
  you don't use these features, you should be quite safe with MySQL 3.23!

Note that the above doesn't mean that replication or Berkeley DB doesn't
  work; We have done a lot of testing of all code, including replication and
  BDB without finding any problems. It only means that not as many users
  uses this code as the rest of the code and because of this we are not yet
  100 % confident in this code."

However, these features can now be used by installing the mysql-Max
package. More info about this packages can be obtained from here:

http://www.mysql.com/downloads/mysql-max-3.23.html

MySQL on SuSE Linux has been compiled and configured with the following
options:

--enable-assembler 
	--enable-large-files 
	--infodir=%{_infodir} 
	--libdir=/usr/lib 
	--libexecdir=/usr/sbin 
	--localstatedir=/var/lib/mysql 
	--mandir=%{_mandir} 
	--prefix=/usr 
	--sysconfdir=/etc 
	--with-mysqld-user=mysql 
	--without-debug 
	--datadir=/usr/share 
	--includedir=/usr/include 
	--with-extra-charsets=complex 
	--with-unix-socket-path=/var/lib/mysql/mysql.sock 
	--with-libwrap

In addition to these common compile flags, the mysqld binaries differ as
follows:

mysqld from package "mysql" has been compiled with these additional flags:

--disable-shared
	--with-mysqld-ldflags='-all-static'
	--with-client-ldflags='-all-static'
	--without-berkeley-db --without-innodb

The mysqld-max binary included in the mysql-Max package as well as the MySQL
shared libraries have been compiled with the following additional compile
flags:

--enable-shared
	--enable-thread-safe-client
	--with-berkeley-db
	--with-innodb
	--with-mysqld-ldflags='-all-static'
	--with-server-suffix='-Max'

MySQL on SuSE Linux uses the following directories:

/var/lib/mysql/					Database and Log files, mysql.sock socket
/usr/bin/						Database tools and programs
/usr/sbin/mysqld				The Server Program
/usr/share/doc/packages/mysql	Documentation
/usr/share/mysql				misc additional files (Language extensions)
/usr/include/mysql				Include Files
/usr/lib/mysql					Static libraries
/usr/lib/mysqlclient.so*		Runtime Libraries
/usr/share/sql-bench			SQL 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