«   2018/06   »
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
Archives
Today
343
Total
1,112,203
안정적인 DNS서비스 DNSEver
관리 메뉴

Blue Breeze

centos7 mysql5.7 본문

DB&NoSQL/MySQL

centos7 mysql5.7

푸른바람 C/H 2017.02.24 08:30

centos7 mysql5.7 Install

# 5.7 appnend repo
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm && yum localinstall mysql57-community-release-el7-7.noarch.rpm -y

yum repolist enabled | grep "mysql.*-community.*"
yum install mysql-server mysql-devel -y

systemctl status mysqld.service
mysql --version

systemctl enable mysqld.service
systemctl start mysqld.service
mysql -u root -p

# root password temporary set
mysql_secure_installation

# check temporary password
grep 'temporary password' /var/log/mysqld.log
2017-02-20T07:32:32.983446Z 1 [Note] A temporary password is generated for root@localhost: password

삭제 후 재 설치

# remove mysql, reinstall
systemctl stop mysqld.service
yum remove mysql* -y
mv /var/lib/mysql /var/lib/mysql_old_backup
rm -fvR /var/lib/mysql
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm && yum localinstall mysql57-community-release-el7-7.noarch.rpm -y
yum install mysql-server mysql-devel -y
systemctl start mysqld
mysql_secure_installation
grep 'temporary password' /var/log/mysqld.log

root password setting

mysql u root -p mysql
# <= 5.7.7
update mysql.user set password=password('password') where user='root';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
# >= 5.7.8
update user set authentication_string=password('password') where user='root';
# Error
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
# root password setting
SET PASSWORD = PASSWORD('password');
SET PASSWORD = 'password';   # validate-password=off 설정 시
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
# 비밀번호 정책을 변경 하거나 정책에 맞는 비밀번호로 변경
# my.cnf 추가/수정
# 미 사용 : validate-password=off
# 정책 변경 : validate_password_policy=LOW|MEDIUM|STRONG
# validate_password_policy=LOW  8자 이상
# validate_password_policy=MEDIUM  8자이상,숫자,소문자,대문자,특수문자
# validate_password_policy=STRONG  8자이상,숫자,소문자,대문자,특수문자,사전단어 포함
# 에러가 발생하지 않는다면 아래 쿼리로 root 비밀번호를 업데이트 한다.

update user set authentication_string=password('password') where user='root';
select host, user, authentication_string from user;

'DB&NoSQL > MySQL' 카테고리의 다른 글

Centos7 Mariadb datadir change  (0) 2018.03.07
mysql cmd query  (0) 2017.04.20
centos7 mysql5.7  (0) 2017.02.24
mysqladmin 퍼포먼스 정보 확인  (0) 2017.02.03
Shell 에서 MySQL 용량확인  (0) 2017.01.31
MySQL 5.7 update after my.conf  (0) 2016.11.18
0 Comments
댓글쓰기 폼