mysql root password 설정방법

mysql root password 설정방법

 

• OS: Ubuntu Server 18.04 LTS
• mysql version: mysql  Ver 14.14 Distrib 5.7.30

 

이전 mysql버전과 비교했을때 mysql 5.7이상에서 password변경방법이

기존변경 방식과 차이가 있다.

 

mysql version 확인

Login

• mysql설치후 root의 Password를 지정하지 않은 상태라면 Password입력부분에서 enter키 입력.

• mysql database로 전환
• User 테이블은 사용자 계정과 관련된 정보를 관리하는 테이블.

mysql> select Host,User,authentication_string,plugin from user;
+-----------+------------------+-------------------------------------------+-----------------------+
| Host      | User             | authentication_string                     | plugin                |
+-----------+------------------+-------------------------------------------+-----------------------+
| localhost | root             | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | mysql_native_password |
| localhost | mysql.session    | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password |
| localhost | mysql.sys        | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password |
| localhost | debian-sys-maint | *7FF84047AC01FF76CF6A0CC459DF299A95CDC95F | mysql_native_password |
+-----------+------------------+-------------------------------------------+-----------------------+
4 rows in set (0.00 sec)

• user table의 관련 field 조회.

 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '12345';
Query OK, 0 rows affected (0.00 sec)

mysql> select Host,User,authentication_string,plugin from user;
+-----------+------------------+-------------------------------------------+-----------------------+
| Host      | User             | authentication_string                     | plugin                |
+-----------+------------------+-------------------------------------------+-----------------------+
| localhost | root             | *A4B6157319038724E3560894F7F932C8886EBFCF | mysql_native_password |
| localhost | mysql.session    | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password |
| localhost | mysql.sys        | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password |
| localhost | debian-sys-maint | *7FF84047AC01FF76CF6A0CC459DF299A95CDC95F | mysql_native_password |
+-----------+------------------+-------------------------------------------+-----------------------+
4 rows in set (0.00 sec)

mysql> 

• 비밀번호 변경 query
  • ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '바꿀Password';

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> 

• DB에 반영

 

mysql공식사이트 참조

https://dev.mysql.com/doc/refman/8.0/en/alter-user.html