mysql 5.0 for linux_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来执行确认