Wụnye ma hazie MySQL8 na CentOS7

Ntughari

Tinye faịlụ REPO

Jiri vi ma ọ bụ vim iji dezie faịlụ /etc/yum.repos.d/mysql-community.repo, detuo ọdịnaya ndị a na faịlụ ahụ, wee chekwaa ma pụọ.

            [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
        

Mee nhazi

            yum -y install mysql-community-server
        

Gbanwee faịlụ nhazi

Jiri vi ma ọ bụ vim iji dezie /etc/my.cnf. Dị ka MySQL8 jiri ya tụnyere mbipute gara aga, usoro nhazi ndabara nke nbanye, nkwupụta okwu SQL rigor na ezughị oke ubi agbanweela, yabụ ọ bụrụ na anyị kwesịrị idebe otu ihe ahụ dị na mbụ, mee nhazi ndị a. Y’oburu n’ichoghi dakọtara na mmemme ochie, ị nwere ike ileghara ya anya. Na nhazi gbanwetụrụ nke ihe atụ dị n'okpuru ebe a, ihe atọ ndị mbụ ga-adaba na njiri ojiji nke ụdị ochie ahụ, ihe ikpeazụ bụ iji gbanwee ndekọ nchekwa ndabara nke nchekwa data.

            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
        

Malite ọrụ

            systemctl enable mysqld
systemctl start mysqld
        

Nweta okwuntughe njikọ ndabara

A na-echekwa paswọọdụ nbanye nke mgbọrọgwụ nke MySQL8 na faịlụ ndekọ ahụ, anyị kwesịrị ịlele ya site na faịlụ ndekọ.

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

Ọrụ nkwenye

Ruo ugbu a e mechara nwụnye anyị na nhazi anyị, anyị na-eji akara iwu iji jikọọ na ọrụ MySQL, wee mepụta nchekwa data na akaụntụ.

            mysql -uroot -p