Faka kwaye uqwalasele i-MySQL8 kwi-CentOS7

Isalathiso

Yongeza ifayile yeREPO

Sebenzisa i-vi okanye i-vim ukuhlela i /etc/yum.repos.d/mysql-community.repo ifayile, ukope lo mxholo ulandelayo kwifayile, emva koko ugcine kwaye uphume.

            [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 ufakelo

            yum -y install mysql-community-server
        

Guqula ifayile yoqwalaselo

Sebenzisa vi okanye vim ukuhlela /etc/my.cnf. Njengoko i-MySQL8 ithelekiswa nenguqulelo yangaphambili, indlela yokuqhubekeka yokusetyenzwa kokungena, isitatimende se-SQL kunye nobude obungonelanga bentsimi butshintshile, ke ukuba sifuna ukugcina ngokufanayo nangaphambili, yenza loqwalaselo lulandelayo. Ukuba awudingi ukungqinelana nenkqubo endala, ungayihoya. Kuqwalaselo olulungisiweyo lomzekelo ongezantsi, izinto zokuqala ezintathu ziyahambelana nemikhwa yokusetyenziswa kwinguqulelo yakudala, kwaye into yokugqibela kukutshintsha isikhombisi esigciniweyo sedathabheyisi.

            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
        

Qalisa inkonzo

            systemctl enable mysqld
systemctl start mysqld
        

Fumana ipassword yoqhagamshelo olungagqibekanga

Iphasiwedi yokungena ngemvume ye-MySQL8 ingcambu yemveli igcinwe kwifayile yelog, kwaye kufuneka siyijonge kwifayile yelog.

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

Inkonzo yokuqinisekisa

Ukuza kuthi ga ngoku ukufakelwa kunye nokuqwalaselwa kugqityiwe, sisebenzisa umgca wokuyalela ukunxibelelana nenkonzo ye-MySQL, emva koko senze isiseko sedatha kunye neakhawunti.

            mysql -uroot -p