학습 // DB // MySQL // install // Linux

업데이트 :: 2018.10.01

---

• MySQl 설치 on 리눅스
• 패스워드변경

MySQl 설치 on 리눅스

CentOS

> yum -y install http://repo.mysql.com/mysql57-community-release-fc22-7.noarch.rpm
> yum -y install mysql-community-server

> wget http://download.hanbit.co.kr/mysql/5.7/mysql57.tar.gz
> chmod 644 mysql57.tar
> tar xf mysql57.tar
> yum -y install *.rpm

> systemctl start mysqld
> systemctl enable mysqld

> firewall-cmd --permanent -- add-port=3306/tcp
> firewall-cmd --reload

패스워드변경

> sudo grep 'temporary password' /var/log/mysqld.log
> mysql -u root -p

mysql> SET GLOBAL validate_password_policy=0; --비빌번호의 복잡도를 OFF
mysql> SET GLOBAL validate_password_length=0; --비빌번호의 길이를 0
mysql> ALERT USER 'root'@'localhost' IDENTIFIED BY '1234' ;

mysql> CREATE USER root@'%' IDENTIFIED BY '1234';
mysql> GRANT ALL ON *.* TO root@'%' WITH GRANT OPTION;
mysql> EXIT;

---

Created by MoonsCoding

e-mail :: jm921106@gmail.com