Mysql 5.0 For Linux 安裝手冊

 Source Installation Overview
----------------------------------

The basic commands you must execute to install a MySQL source
distribution are:

     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
     shell> cd mysql-VERSION
     shell> ./configure --prefix=/usr/local/mysql
     shell> make
     shell> make install
     shell> 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'

使用GRANT ... IDENTIFIED BY語句，來進行授權
GRANT select,insert,delete,update on dbname.* to  user@'%' IDENTIFIED BY 'manager';
這裡PASSWORD()函數是不必要的，也不需要使用FLUSH PRIVILEGES來執行確認