centos7 mysql 비밀번호 초기화

[root@localhost ~]# systemctl stop mysqld 

[root@localhost ~]# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 

[root@localhost ~]# systemctl start mysqld 

[root@localhost ~]# mysql -u root 

 

 

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('내가하고싶은비밀번호')

-> WHERE User = 'root' AND Host = 'localhost';

mysql> FLUSH PRIVILEGES;

mysql> quit

 

[root@localhost ~]# systemctl stop mysqld

[root@localhost ~]# systemctl unset-environment MYSQLD_OPTS

[root@localhost ~]# systemctl start mysqld