Shigar da saita MySQL8 akan CentOS7

Magana

Fileara fayil ɗin REPO

Yi amfani da vi ko vim don shirya fayil ɗin /etc/yum.repos.d/mysql-community.repo, kwafa abubuwan da ke gaba zuwa fayil ɗin, sannan adanawa da fita.

            [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
        

Yi shigarwa

            yum -y install mysql-community-server
        

Gyara fayil ɗin sanyi

Yi amfani da vi ko vim don gyara /etc/my.cnf. Kamar yadda MySQL8 yake idan aka kwatanta shi da na baya, to hanyar da ake bi wajen shigowa, tsayayyar bayanin SQL da rashin isasshen filin ta canza, saboda haka idan muna bukatar mu ci gaba da yadda muke a da, yi tsarin nan mai zuwa. Idan baku buƙatar dacewa da tsohuwar shirin, kuna iya watsi da shi. A cikin gyare-gyaren da aka gyara na misali mai zuwa, abubuwa uku na farko zasu zama masu dacewa da halaye masu amfani na tsohuwar sigar, kuma abu na ƙarshe shine gyara kundin adireshin ajiya na tsoffin bayanan.

            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
        

Fara sabis

            systemctl enable mysqld
systemctl start mysqld
        

Samu kalmar sirri ta tsoho

An adana kalmar shiga ta tushen asalin MySQL8 a cikin fayil ɗin log, kuma muna buƙatar bincika shi daga fayil ɗin log ɗin.

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

Sabis na Tabbatarwa

Ya zuwa yanzu shigowarmu da daidaitawarmu sun kammala, muna amfani da layin umarni don haɗi zuwa sabis ɗin MySQL, sannan ƙirƙirar bayanai da asusun.

            mysql -uroot -p