[MySql & Mariadb] root 계정 초기 비밀번호 설정하는 법 !!

[MySql & Mariadb] root 계정 초기 비밀번호 설정하는 법 !!

 

우선 mariadb에 접속을 해주세요 !

처음 설치하면 페스워드가 없기 때문에 바로 접속이 됩니다 ㅎ

[root@mariadb-master ~]# sudo mariadb -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.2.32-MariaDB-log MariaDB Server
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]>

 

mysql 로 사용하고 확인해보시면 비밀번호가 없을꺼에요 ~

MariaDB [(none)]> use mysql

MariaDB [mysql]> select host, user, password from user;
+----------------+------+----------+
| host           | user | password |
+----------------+------+----------+
| localhost      | root |          |
+----------------+------+----------+

 

'password' 에 원하는 페스워드 적어주시면 끝 입니다 !

MariaDB [mysql]> update user set password=password('password') where user='root';
MariaDB [mysql]> flush privileges;
 
MariaDB [mysql]> select host, user, password from user;
+----------------+------+-------------------------------------------+
| host           | user | password                                  |
+----------------+------+-------------------------------------------+
| localhost      | root | *FE77F6274099B26A5DD565E9898AA22FF1A714BC |
+----------------+------+-------------------------------------------+