Bigdata, Hadoop ecosystem, Semantic IoT등의 프로젝트를 진행중에 습득한 내용을 정리하는 곳입니다.
필요한 분을 위해서 공개하고 있습니다.
문의사항은 gooper@gooper.com로 메일을
보내주세요.
1. MariaDB-source 버젼 다운 받기
http://mariadb.org - > https://downloads.mariadb.org/
https://mariadb.com/kb/en/mariadb/source-getting-the-mariadb-source-code/ -> https://github.com/MariaDB/server/tree/10.2
혹은
https://downloads.mariadb.org/mariadb/10.1.17/
2. 업로드및 압축출기
$gzip -d mariadb-10.1.17.tar.gz
$tar -xvf mariadb-10.1.17.tar
3. mariadb폴더로 이동
cd mariadb-10.1.17
5. ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=utf8 --with-mysql-usr=mysql --sysconfdir=/etc --enable-thread-safe-client
./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euckr --with-mysql-usr=mysql --sysconfdir=/etc --enable-thread-safe-client
./configure --prefix=/home/wisenut/sf-1/mysql --localstatedir=/home/wisenut/sf-1/mysql/data --with-charset=utf8 --with-mysql-usr=wisenut --sysconfdir=/etc --enable-thread-safe=client
./configure --prefix=/home/kwisenut/sf-1v4.5/mysql/mysql5 --localstatedir=/home/kwisenut/sf-1v4.5/mysql/mysql5/data --with-charset=utf8 --with-mysql-usr=kwisenut --sysconfdir=/etc --enable-thread-safe=client
./configure --prefix=/home/kwisenut/sf-1v4.5/mysql/mysql-5.1.17 --localstatedir=/home/kwisenut/sf-1v4.5/mysql/mysql-5.1.17/data --with-charset=utf8
6. make
7. make install
8. ./scripts/mysql_install_db
9. cat >> /etc/ld.so.conf
/usr/local/mysql/lib (엔터치고 ctrl+c 입력)
10. ldconfig
11. cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
12. mysql 계정 생성
groupadd mysql
useradd -g mysql mysql
chown root.mysql -R /usr/local/mysql
chown mysql.mysql -R /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql
13. /usr/local/mysql/bin/mysqld_safe --user=mysql &
14. /usr/local/mysql/bin/mysql
use mysql
update user set password=password('root!@')
update user set password=password('root')
where user = 'root';
delete from user where user='';
flush privileges;
15. /usr/local/mysql/bin/mysqladmin -u root -p showdown
16. /usr/local/mysql/bin/msyqld_safe -u root &
*참고 : 위에 내용은 정상적인 경우이고 AIX에서 source로 설치하기는 실패함