MySQL 5.0 for Linux installation manual

Source installation overview
----------------------------------

The basic commands you must execute to install a MySQL Source
Distribution are:

Shell> groupadd MySQL
Shell> useradd-G MySQL
Shell> gunzip | mysql-VERSION.tar.gz | tar-xvf-
Shell> Cd mysql-version
Shell>./configure -- prefix =/usr/local/MySQL
Shell> make
Shell> make install
Shells> CP support-files/my-medium.cnf/etc/My. CNF
Shell> Cd/usr/local/MySQL
Shell> bin/mysql_install_db -- user = MySQL
Shell> chown-r root.
Shell> chown-r MySQL VaR
Shell> chgrp-r MySQL.
Shell> bin/mysqld_safe -- user = MySQL &

If you start from a source rpm, do the following:

Shell> rpmbuild -- rebuild -- clean MySQL-VERSION.src.rpm

Set root password for MySQL
/Usr/local/bin/mysqladmin-u Root Password 'new-password'

Use the grant... identified by statement to grant permissions.
Grant select, insert, delete, update on dbname. * to user @ '%' identified by 'manager ';
Here, the password () function is unnecessary and does not need to be flush privileges for confirmation.