Isa uye gadzirisa MySQL8 paCentOS7

2021-01-08 CentOS7 MySQL

Refer

Webhusaiti yepamutemo Chigadzirwa Gwaro

Wedzera REPO faira

Shandisa vi kana vim kugadzirisa iyo /etc/yum.repos.d/mysql-community.repo faira, teedzera zvinotevera zvirimo kune iyo faira, wobva wachengeta uye kubuda.

            [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

Ita kumisikidza

            yum -y install mysql-community-server

Chinja faira rekumisikidza

Shandisa vi kana vim kugadzirisa /etc/my.cnf. Sezvo MySQL8 ichienzaniswa neshanduro yapfuura, iyo yekumisikidza nzira yekugadzirisa yekupinda, SQL chirevo chakasimba uye isina kukwana munda urefu hwachinja, saka kana tichida kuchengeta zvakafanana sepakutanga, ita zvinotevera gadziriso. Kana iwe usingade kuenderana nechirongwa chekare, unogona kuchisiya. Mukugadziriswa kwakagadziriswa kwemuenzaniso uri pazasi, zvinhu zvitatu zvekutanga zvinofanirwa kuenderana nemaitiro ekushandisa eiyo vhezheni yekare, uye chinhu chekupedzisira kugadzirisa dura rekuchengetedza dhatabhesi.

            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

Kutanga sevhisi

            systemctl enable mysqld
systemctl start mysqld

Tora default kubatana password

Iyo yekunyoresa password yeMySQL8 yemuno midzi inochengeterwa mugiyo faira, isu tinofanirwa kuitarisa kubva kune iyo danda faira.

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

Kuongorora Service

Parizvino kuisirwa kwedu uye kugadzirisa kwapedzwa, isu tinoshandisa rairo yekuraira kubatanidza kune MySQL sevhisi, uyezve kugadzira dhatabhesi uye account.

            mysql -uroot -p