[리눅스] Mysql 설치(최종본)

* 의존성 패키지 설치

yum -y install zlib curl

yum -y install gcc g++ cpp gcc-c++

yum -y install openssl openssl-devel

yum -y install ncurses-devel

yum -y install bzip2-devel

yum -y install libtermcap-devl libc-client-devel

yum -y install bison

yum -y install perl

yum -y install make cmake

groupadd mysql

useradd -M -c "MySQL" -d /usr/local/mysql -g mysql -s /bin/nologin mysql

* 압축 푸는 것은 소스에 불과함 컴파일을 해서 새로운 디렉토리를 생성해야함. 

  압축 푼 소스 디렉토리와 컴파일 해서 새로 만들 디렉토리는 달라야함.

소스 있는 디렉토리 들어가서

cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \

-DSYSCONFDIR=/etc \

-DMYSQL_TCP_PORT=3306 \

-DMYSQL_USER=mysql \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS=all \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

make && make install

ln -s /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump

ln -s /usr/local/mysql/bin/mysql_config /usr/sbin/mysql_config

ln -s /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin

ln -s /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

chown -R mysql:mysql /usr/local/mysql/

chkconfig --add mysql

echo "/usr/local/mysql/lib" >> /etc/ld.so.conf

ldconfig

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/usr/local/mysql/my.cnf --user=mysql  --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --explicit_defaults_for_timestamp=on

service mysql start

* Starting MySQL. ERROR! The server quit without updating PID file 에러 뜰시에 

./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data

./bin/mysqladmin -u root password 'password'

mysql -u root -p

show databases;