Faatuina ma configure MySQL8 i le CentOS7

Tusitusiga

Faʻaopopo le faila REPO

Faʻaoga vi pe vim e faʻasaʻo ai le /etc/yum.repos.d/mysql-community.repo faila, kopi le mea lea o loʻo mulimuli mai i le faila, ona sefe lea ma ulufafo.

            [mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
        

Faatino faapipiiina

            yum -y install mysql-community-server
        

Fesuiaʻi le faila faʻatulagaina

Faʻaaoga vi pe vim e faʻasaʻo /etc/my.cnf. E pei o MySQL8 faʻatusatusa i le lomiga talu ai, o le le faʻaogaina o metotia o le ulufale, SQL faʻamatalaga faigata ma le lava le umi o le fanua ua suia, o lea afai tatou te manaʻomia e tausia le tutusa pei muamua, faia le faʻatulagaina lea. Afai e te le manaʻomia e fetaui ma le tuai polokalama, oe mafai ona le amanaiaina. I le toe faʻaleleia fetuʻunaʻiga o le faʻataʻitaʻiga lenei, o mea muamua e tolu e mo le fetaui lelei ma aga masani o le tuai, ae o le mea mulimuli o le suia lea o le faʻamaumauga o le teuina o faʻamatalaga.

            default_authentication_plugin=mysql_native_password
validate_password.policy=LOW
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
datadir=/mysqldata
        

Amata le tautua

            systemctl enable mysqld
systemctl start mysqld
        

Maua le upu pasi fesoʻotaʻiga le aoga

O le MySQL8 root root login password o loʻo teuina i totonu o le faila faila, e tatau ona tatou vaʻaia mai le faila faila.

            grep "password" /var/log/mysqld.log
        

Tautua Faʻamaonia

E oʻo mai i le taimi nei ua maeʻa le matou faʻapipiʻiina, matou te faʻaaogaina le laina laina e fesoʻotaʻi ai i le tautua a MySQL, ona fai ai lea o se database ma teuga tupe.

            mysql -uroot -p