Faka futhi ulungiselele i-MySQL8 ku-CentOS7

Inkomba

Faka ifayela le-REPO

Sebenzisa i-vi noma i-vim ukuhlela ifayili le / /etc/yum.repos.d/mysql-community.repo, ukopishe okuqukethwe okulandelayo kufayela, bese ulondoloza bese uphuma.

            [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
        

Yenza ukufakwa

            yum -y install mysql-community-server
        

Shintsha ifayela lokumisa

Sebenzisa i-vi noma i-vim ukuhlela /etc/my.cnf. Njengoba i-MySQL8 iqhathaniswa nenguqulo yangaphambilini, indlela yokucubungula okuzenzakalelayo yokungena ngemvume, ukuqina kwesitatimende se-SQL nobude bensimu obunganele kushintshile, ngakho-ke uma sidinga ukugcina okufanayo njengakuqala, yenza ukucushwa okulandelayo. Uma ungadingi ukuhambisana nohlelo oludala, ungaluziba. Ekucushweni okulungisiwe kwesibonelo esingezansi, izinto ezintathu zokuqala kufanele zihambisane nemikhuba yokusetshenziswa yenguqulo yakudala, futhi into yokugcina ukuguqula umkhombandlela wesitoreji esizenzakalelayo wedathabheyisi.

            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
        

Qala insiza

            systemctl enable mysqld
systemctl start mysqld
        

Thola iphasiwedi yokuxhuma ezenzakalelayo

Iphasiwedi yokungena ngemvume yezimpande zomdabu ze-MySQL8 igcinwe kufayela lokungena, futhi sidinga ukulibheka kufayela lokungena.

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

Isevisi yokuqinisekisa

Kuze kube manje ukufakwa nokulungiswa kwethu sekuqediwe, sisebenzisa umugqa womyalo ukuxhuma kwinsizakalo ye-MySQL, bese sakha i-database ne-akhawunti.

            mysql -uroot -p