how to install mariadb on centos7

2019. 11. 4. 11:10OS/리눅스

반응형

#> yum install -y vim 
#> yum install -y net-tools vim
#> yum -y install cmake gcc* curses-devel bison libxml* libtool* openssl* crypto-utils ncurses-devel
#> yum install libjpeg* libpng* freetype* gd-* gdbm-devel libtermcap-devel -y
#> groupadd -g 400 mysql
#> useradd -u400 -g400 -d /usr/local/mysql -s /bin/false mysql
#> cd /usr/local/src
#> yum install -y wget
#> wget http://ftp.hosteurope.de/mirror/archive.mariadb.org/mariadb-10.1.28/source/mariadb-10.1.28.tar.gz

        (링크 주소는 변동이 될 수 있습니다.)

#> tar xvzf mariadb-10.1.28.tar.gz 
#> cd mariadb-10.1.28

#> cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DMYSQL_DATADIR=/usr/local/mariadb/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_SSH=bundled -DWITH_ZLIB=system -DWITH_EXTRA_CHARSETS=all -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_PREFSCHEMA_STORAGE_ENGINE=1

       (이부분은 이어서 써주세요)

 

#> make
#> make install
#> cp /usr/local/mariadb/support-files/mysql.server /etc/init.d/mysqld
#> chmod 700 /etc/init.d/mysqld
#> chkconfig --add mysqld
#> vi /etc/init.d/mysqld

       basedir=/usr/local/mariadb

       datadir=/usr/local/mariadb/data

 

#> cp /usr/local/mariadb/support-files/my-huge.cnf /etc/my.cnf
#> chown -R mysql.mysql /usr/local/mariadb/
#> chmod 711 /usr/local/mariadb/
#> chmod 700 /usr/local/mariadb/data/
#> chmod 751 /usr/local/mariadb/bin
#> chmod 750 /usr/local/mariadb/bin/*
#> chmod 755 /usr/local/mariadb/bin/mysql
#> chmod 755 /usr/local/mariadb/bin/mysqldump

     (만약 mysqldump 가 없다고 나온다면 yum install mariadb-client 를 진행해주세요)


#> /usr/local/mariadb/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mariadb/ --datadir=/usr/local/mariadb/data/

 

#> systemctl daemon-reload
#> service mysqld start
#> /usr/local/mariadb/bin/mysqladmin -u root password '패스워드'
#> ln -s /var/lib/mysql/msyql.sock /tmp/mysql.sock

반응형