Sakani ndi kukonza MySQL8 pa CentOS7

Kutchulidwa

Onjezani fayilo ya REPO

Gwiritsani ntchito vi kapena vim kuti musinthe fayilo ya /etc/yum.repos.d/mysql-community.repo, lembani zotsatirazi mufayiloyi, kenako sungani ndi kutuluka.

            [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
        

Pangani unsembe

            yum -y install mysql-community-server
        

Sinthani fayilo yosintha

Gwiritsani ntchito vi kapena vim kuti musinthe /etc/my.cnf. Monga MySQL8 poyerekeza ndi mtundu wapitawu, njira zosinthira zolowera, mawu a SQL ndi kutalika kosakwanira kwam'munda zasintha, chifukwa chake ngati tikufunikira kukhala momwemonso kale, chitani izi. Ngati simukuyenera kukhala woyenerana ndi pulogalamu yakale, mutha kuiwala. Pakukonzekera kosinthidwa kwa chitsanzo chotsatirachi, zinthu zitatu zoyambirira ndizogwirizana ndi zizolowezi zogwiritsa ntchito mtundu wakale, ndipo chinthu chomaliza ndikusintha nkhokwe yosungira ya 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
        

Yambani ntchito

            systemctl enable mysqld
systemctl start mysqld
        

Pezani achinsinsi kulumikiza achinsinsi

Mawu achinsinsi olowera muzu wa MySQL8 amasungidwa mu fayilo yamakalata, ndipo tifunika kuwunika kuchokera pa fayilo ya chipika.

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

Ntchito Yotsimikizira

Pakadali pano kukhazikitsa ndi kukonza kwathu kwatsirizidwa, timagwiritsa ntchito mzere wamagetsi kulumikizana ndi ntchito ya MySQL, kenako ndikupanga database ndi akaunti.

            mysql -uroot -p