SmallKen's Blog

* MySQL 主頁 ( 英文 )：http://www.mysql.com/
* MySQL 主頁下載：http://www.mysql.com/downloads/mysql-3.23.html
* 台灣映設站台：http://ftp.nsysu.edu.tw/Unix/Database/MySql/downloads/
--------------------------------------------------------------------------------
以下是根據官方網站的標準安裝程序

※注意事項

You may see the following error message when you run mysql_install_db:

Sorry, the host 'xxxx' could not be looked up

You can deal with this by executing mysql_install_db --force,
which does not execute the resolveip test in mysql_install_db.
The downside is that you cannot use hostnames in the grant tables:
except for localhost, you must use IP numbers instead. If you are
using an old version of MySQL that does not support --force, you must
manually remove the resolveip test in mysql_install using a text editor

意思是說，如果主機沒有domain name , 把 hostname 改成 127.0.0.1, 或者加入 --force 參數

※開始安裝

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> tar zxvf mysql-standard-5.0.18-linux-i686-glibc23.tar.gz -C /usr/local/
shell> cd /usr/local
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root . // pwd = /usr/local/msyql
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

開機自動啟動在 /etc/rc.local 加入
cd /usr/local/mysql; /usr/local/mysql/bin/safe_mysqld --user=mysql &

vi /etc/profile
PATH="$PATH":/usr/local/mysql/bin // 加 PATH
vi /etc/man.config
MANPATH /usr/local/mysql/man // 加入 man path

建立 mysql 的 root 密碼

方法一：

# /usr/local/mysql/bin/mysqladmin -u root password 'your.password'
# /usr/local/mysql/bin/mysql -u root -p // 登入方法

方法二：

方法一直接在shell中輸入密碼，指令會被系統記錄下來，比較不安全，安全的方法

# /usr/local/mysql/bin/mysql

>use mysql
>update user set password=password("新密碼") where user="root";
>flush privileges;
>exit;

其他文章

• 如何使用 SSH Tunnel 連回在NAT底下的主機?
• 何謂AJAX?
• 自製空英播放器
• 安裝 mplayer & 抓取 mms 串流檔案 for CentOS5
• 吉他自彈自唱 - 周杰倫 楓