Installing MySQL - Learning MySQL - page 39

4/7: MySQL-common ######...######
5/7: MySQL ######...######
6/7: apache-mod_php ######...######
7/7: php-mysql ######...######
----------------------------------------------------------------------
More information on package MySQL-5.0.23-1mdv2007.0.i586
The initscript used to start mysql has been reverted to use the one shipped by
MySQL AB. This means the following changes:
* The MYSQLD_OPTIONS="--skip-networking" option in the /etc/sysconfig/mysqld
file has been removed, this is now set in the /etc/my.cnf file.
* The MySQL Instance Manager is used by default, set use_mysqld_safe="1" in
the /etc/sysconfig/mysqld file to use the old mysqld_safe script.
The extra MySQL-NDB server package has been merged into the MySQL-Max package
and ndb related pieces has been split into different sub packages as done by
MySQL AB. The MySQL libraries and the MySQL-common sub package uses the
MySQL-Max build so that no functionality required by for example the NDB parts
are lost.
The MySQL-common package now ships with a default /etc/my.cnf file that is
based on the my-medium.cnf file that comes with the source code. The
/etc/my.cnf file is constructed at build time of this package.
To connect to the Instance Manager you need to pass the correct command line
options like in the following examples:
* mysql -u root --password=my_password --port=2273 --protocol=TCP
* mysql -u root --password=my_password
--socket=/var/lib/mysql/mysqlmanager.sock
Please note you also need to add a user in the /etc/mysqlmanager.passwd file
and make sure the file is owned by the user under which the Instance Manager
service is running under.
----------------------------------------------------------------------
Here, urpmi has downloaded the latest versions of the programs from the Internet.
During installation, some packages display messages that you should read; in our ex-
ample, the MySQL package installation routine has described how the configuration
has changed since older versions.
You can also download and install or upgrade the Mandriva RPMs without using
urpmi . For example, you can visit http://rpm.pbone.net and search for mysql ; pick and
download the RPMs for Mandriva with the highest version number. Once you've
downloaded the files, log in as the root user by typing su - , and then install the RPM
packages by running this command (all on one line):
# rpm --upgrade --verbose --hash \
MySQL-5.0.23-1mdv2007.0.i586.rpm \
MySQL-client-5.0.23-1mdv2007.0.i586.rpm \