Kenya le ho hlophisa MySQL8 ho CentOS7

Tšupiso

Kenya file ea REPO

Sebelisa vi kapa vim ho hlophisa file ea /etc/yum.repos.d/mysql-community.repo faele, kopitsa litaba tse latelang faeleng, ebe u li boloka le ho tsoa.

            [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
        

Etsa kopo

            yum -y install mysql-community-server
        

Fetola faele ea phetolo

Sebelisa vi kapa vim ho hlophisa /etc/my.cnf. Joalo ka MySQL8 ha e bapisoa le mofuta oa pejana, mokhoa o sa sebetseng oa ho sebetsana le ho kena, polelo e thata ea SQL le bolelele bo sa lekaneng ba tšimo li fetohile, kahoo haeba re hloka ho boloka se ts'oanang le pele, etsa moralo o latelang. Haeba u sa hloke ho lumellana le lenaneo la khale, u ka le hlokomoloha. Ka phetolo e fetotsoeng ea mohlala o ka tlase, lintho tsa pele tse tharo li lokela ho tsamaellana le litloaelo tsa ts'ebeliso ea mofuta oa khale, 'me ntho ea hoqetela ke ho fetola mochini oa polokelo oa kamehla oa database.

            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 tšebeletso

            systemctl enable mysqld
systemctl start mysqld
        

Fumana password ea khokahano ea kamehla

Phasewete ea ho kena ea MySQL8 e bolokiloe ka har'a file ea log, 'me re hloka ho e sheba ho tsoa faeleng ea log.

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

Tšebeletso ea netefatso

Ho fihlela hajoale ho kenya le ho hlophisa ha rona ho se ho phethiloe, re sebelisa mohala oa taelo ho hokela ts'ebeletso ea MySQL, ebe re theha database le akhaonto.

            mysql -uroot -p