Nruab thiab teeb tsa MySQL8 ntawm CentOS7

Kev siv

Ntxiv REPO ntawv

Siv vi lossis vim los kho qhov /etc/yum.repos.d/mysql-community.repo ntawv, luam cov ntsiab lus hauv qab no rau hauv ntawv, tom qab khaws thiab tawm.

            [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
        

Ua kev teeb tsa

            yum -y install mysql-community-server
        

Hloov kho cov ntaub ntawv teeb tsa

Siv vi lossis vim hloov /etc/my.cnf. Raws li MySQL8 piv nrog cov qauv dhau los, cov qauv txheej txheem ntawm kev nkag mus, SQL nqe lus nruj me ntsis thiab tsis txaus teb qhov ntev tau hloov pauv, yog li yog peb xav tau khaws cov qub ib yam li ua ntej, ua cov kev teeb tsa hauv qab no. Yog tias koj tsis tas yuav ua kom haum rau cov kev pabcuam qub, koj tuaj yeem tsis quav ntsej nws. Hauv kev hloov kho hloov ntawm cov piv txwv hauv qab no, thawj peb yam khoom yog rau kev sib raug zoo nrog kev siv cwj pwm ntawm cov qub, thiab cov khoom kawg yog los hloov cov qauv pib ntawm cov chaw khaws cia.

            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
        

Pib kev pabcuam

            systemctl enable mysqld
systemctl start mysqld
        

Tau txais lub neej ntawd kev txuas tus password

Tus ID nkag mus password ntawm MySQL8 haiv neeg hauv paus tau muab cia rau hauv lub voos xwm txheej, thiab peb yuav tsum kuaj xyuas nws ntawm cov ntawv sau cia.

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

Kev pabcuam Pov Thawj

Txog tam sim no peb kev teeb tsa thiab kev teeb tsa tau ua tiav, peb siv cov kab hais kom ua haujlwm txuas rau MySQL qhov kev pabcuam, thiab tom qab ntawd tsim cov chaw khaws ntaub ntawv thiab nyiaj txiag.

            mysql -uroot -p