http://www.mysql.com/downloads/mysql/
source code
Generic Linux (Architecture Independent), Compressed TAR Archive
をダウンロードする

MySQLインストール
# cd /usr/local/src
# tar zxvf mysql-5.0.45.tar.gz
# cd mysql-5.0.45
# useradd mysql
# ./configure --with-charset=utf8 --with-extra-charsets=all --with-mysqld-user=mysql --prefix=/usr/local/mysql
# make
# make install
■MySQL設定
# chown -R mysql:mysql /usr/local/mysql
# cd /usr/local/mysql
# cp share/mysql/my-medium.cnf /etc/my.cnf
# bin/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql:mysql var
起動スクリプトコピー
# cp share/mysql/mysql.server /etc/init.d/mysqld
起動スクリプトより起動
# /etc/init.d/mysqld start
MySQLログイン
# /usr/local/mysql/bin/mysql -u root -p
無名ユーザー削除
mysql> select user, password, host from mysql.user;
mysql> delete from mysql.user where user="";
rootパスワード設定
# set password for root@localhost=password('******');
# set password for root@127.0.0.1=password('******');
※******はパスワード
usernameユーザー作成
mysql> GRANT SELECT,INSERT,DELETE,UPDATE,CREATE,DROP,FILE,ALTER,INDEX,CREATE TEMPORARY TABLES ON *.* TO username@localhost IDENTIFIED BY '******';
※******はパスワード
※「username」は適当に変更してください
mysql> select user, password, host from mysql.user;
+----------+-------------------------------------------+---------------+
| user | password | host |
+----------+-------------------------------------------+---------------+
| root | *F5ED2F42A347CD627XXXXXXXXXXXXXXXXXXXXXXX | localhost |
| root | *E5FD5S42A797GH978XXXXXXXXXXXXXXXXXXXXXXX | 127.0.0.1 |
| username | *A04C8DF7FAE039ED6XXXXXXXXXXXXXXXXXXXXXXX | localhost |
+----------+-------------------------------------------+---------------+
4 rows in set (0.00 sec)
MySQLのパスを通す
# vi /etc/profile
最終行に以下を追加
export PATH=/usr/local/mysql/bin:$PATH