다운로드

# groupadd mysql

# useradd -g mysql mysql

# ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --without-debug --with-charset=euckr --with-language=korean

# make

# make install

# ./scripts/mysql_install_db

# chown -R root /usr/local/mysql

# chown -R mysql /usr/local/mysql/var

# chgrp -R mysql /usr/local/mysql

# cp support-files/my-large.cnf /etc/my.cnf

my-huge.cnf : 1GB RAM 이상

my-large.cnf : 512 ~ 1GB RAM

my-medium.cnf : 128 ~ 256 RAM

# /usr/local/mysql/bin/mysqld_safe --user=mysql &

# /usr/local/mysql/bin/mysqladmin shutdown

mysql> use mysql;

mysql> update user set password=password('pwd') where user = 'root';

mysql> delete from user where user = '';

mysql> flush privileges;

ln -s /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 3 mysqld on

# vi .bash_profile

PATH=$PATH:/usr/local/mysql/bin

# source .bash_profile

[설정추가]
/etc/my.cnf
[mysqld]
 skip-name-resolve

[방화벽추가]
/etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
/etc/rc.d/init.d/iptables restart