Mandriva Spring 2008.1 : Mysql Installation

urpmi mysql phpmyadmin

installing mysql-common-5.0.51a-7mdv2008.1.i586.rpm mysql-client-5.0.51a-7mdv2008.1.i586.rpm apache-mod_php-5.2.5-5mdv2008.1.i586.rpm phpmyadmin-2.11.5-1mdv2008.1.noarch.rpm mysql-5.0.51a-7mdv2008.1.i586.rpm from /var/cache/urpmi/rpms
Preparing... ##########################################################################################
33/37: mysql-client ##########################################################################################
34/37: mysql-common ##########################################################################################
35/37: apache-mod_php ##########################################################################################
36/37: phpmyadmin ##########################################################################################
37/37: mysql ##########################################################################################
----------------------------------------------------------------------


More information on package mysql-5.0.51a-7mdv2008.1.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 generation of the initial system mysql database is now done when mysql
is started from the initscript and only if the /var/lib/mysql/mysql
directory is empty (mysql_install_db). Previousely this was quite hidden and
silently done at (rpm) install time.

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.

[root@box bayu]# /etc/init.d/mysqld start
Initializing MySQL database:
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h box password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL: [ OK ]
[root@box bayu]#

I'm Linux Girl