1. MySQL 설치

린지v 2010. 8. 8. 04:15

# tar -zxvf mysql-5.1.49.tar.gz
# cd mysql-5.1.49
# useradd -M -s /bin/false mysql
(bash: useradd: command not found 가 떴을때 su -l 를 입력해보고 다시 실행해본다)
# ./configure \
> --prefix=/usr/local/server/mysql \
> --with-charset=utf8 \
> --with-extra-charsets=all
# make && make install

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

# cd /usr/local/server/mysql
# bin/mysql_install_db --user=mysql

# chown -R root .
# chown -R mysql var
# chgrp -R mysql .

# vi ~/.bash_profile
PATH = $PATH:$HOME/bin:/usr/local/server/mysql/bin

# cp share/mysql/mysql.server /etc/init.d/mysqld
# chkconfig --add mysqld

(mysqladmin 또는 mysql이 bath 오류가 날 경우 창을 껐다가 다시 켜니 되더군요.)
# /etc/init.d/mysqld start

#mysqladmin -u root password 암호

# mysql -u root -p
Enter password :
mysql >
빠져나오려면 exit 입력.