Jumat, 10 Juli 2020

Cara Install MySQL 8 di Centos 7

Install MySQL 8 (Centos 7)


#yum update

#wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

#rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

#yum install mysql-server

#systemctl start mysqld

#systemctl status mysqld


RESET PASSWORD MySQL 8

secara default MySQL 8 mempunyai password default untuk root. Kita harus meresetnya dulu

#systemctl stop mysql   

#mysqld --skip-grant-tables --user=mysql &

#mysql

>SET GLOBAL validate_password.length = 6;
>SET GLOBAL validate_password.number_count = 0;
>SET GLOBAL validate_password.policy = LOW;
>ALTER USER 'root'@'localhost' IDENTIFIED BY 'password_baru';
>FLUSH PRIVILEGES;

#systemctl start mysqld
#mysql -uroot -p

masukan password baru


DONE !!