install mysql on linux

1. Download

http://dev.mysql.com/downloads/mysql/#downloads

2. upload it to linux server and unzip it

tar -zxvf packagename

3. create user and usergroup

mkdir -p /opt/mysql

groupadd mysql

useradd -g mysql -G mysql mysql

passwd mysql

chown -R mysql:mysql /opt/mysql

4. copy my.cnf and setting it

mkdir -p /opt/mysql/mysql5.5/log

cp /opt/mysql/mysql5.5/support-files/my-medium.cnf  /opt/mysql/mysql5.5/my.cnf

vi ./mysql.cnf

[mysqld]

basedir=/opt/mysql/mysql5.5
datadir=/opt/mysql/mysql5.5/data
log_error=/opt/mysql/mysql5.5/log/mysql.err

vi ~./bash_profile

export PATH=/opt/mysql/mysql5.5/bin:$PATH

5. create initial database

use mysql to execute the scripts:

./scripts/mysql_install_db

6. start database

cd /opt/mysql/mysql5.5

./bin/mysqld_safe --defaults-file=/opt/mysql/mysql5.5/my.cnf

check it started: ./bin/msyqladmin ping

7. shutdown database

./bin/mysqladmin shutdown