Search
j0ke.net Open Build Service
>
Projects
>
internetx
:
mysql5
:
5.1.30
>
mysql-5.1.30
> README.SUSE
Sign Up
|
Log In
Username
Password
Cancel
Overview
Repositories
Revisions
Requests
Users
Advanced
Attributes
Meta
File README.SUSE of Package mysql-5.1.30
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