Shyiramo kandi ugene MySQL8 kuri CentOS7

Reba

Ongeraho dosiye ya REPO

Koresha vi cyangwa vim kugirango uhindure dosiye /etc/yum.repos.d/mysql-community.repo, wandukure ibikurikira muri dosiye, hanyuma ubike hanyuma usohoke.

            [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
        

Kora installation

            yum -y install mysql-community-server
        

Hindura dosiye iboneza

Koresha vi cyangwa vim kugirango uhindure /etc/my.cnf. Nka MySQL8 ugereranije na verisiyo yabanjirije iyi, uburyo busanzwe bwo gutunganya uburyo bwo kwinjira, SQL itangazo rikomeye hamwe nuburebure bwumurima udahagije byarahindutse, niba rero dukeneye kugumana nka mbere, kora iboneza bikurikira. Niba udakeneye guhuza na gahunda ishaje, urashobora kubyirengagiza. Muburyo bwahinduwe bwurugero rukurikira, ibintu bitatu byambere nibyerekeranye no guhuza ningeso yo gukoresha ya verisiyo ishaje, kandi ikintu cyanyuma nuguhindura ububiko bwububiko bwububiko bwibanze.

            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
        

Tangira serivisi

            systemctl enable mysqld
systemctl start mysqld
        

Shaka ijambo ryibanga ryibanze

Ijambobanga ryinjira rya MySQL8 imizi kavukire yabitswe muri dosiye yinjira, dukeneye kugenzura uhereye muri dosiye yinjira.

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

Serivisi ishinzwe kugenzura

Kugeza ubu kwishyiriraho no kugena ibyarangiye, dukoresha umurongo wumurongo kugirango duhuze serivisi ya MySQL, hanyuma dukore base base na konte.

            mysql -uroot -p