Ku rakib oo ku xir MySQL8 CentOS7

Tixraac

Kudar feylka REPO

Adeegso vi ama vim si aad wax uga beddesho feylka /etc/yum.repos.d/mysql-community.repo, nuqul nuxurka soo socda feylka, ka dibna kaydso oo ka bax.

            [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
        

Samee rakibo

            yum -y install mysql-community-server
        

Wax ka beddel feylka qaabeynta

Adeegso vi ama vim si aad wax uga beddesho /etc/my.cnf. Maaddaama MySQL8 la barbardhigay nuqulkii hore, hababka waxqabadka asalka ah ee soo galida, qallafsanaanta qoraalka SQL iyo dhererka dhererka beerka oo aan ku filnayn ayaa is beddelay, markaa haddii aan u baahanahay inaan sidii hore u sii wadno, samee qaabeynta soo socota. Haddii aadan u baahnayn inaad la jaanqaadi karto barnaamijkii hore, waad iska indha tiri kartaa. Qaab dhismeedka wax laga beddelay ee tusaalaha hoose, saddexda shay ee ugu horreeya waa inay la jaan qaadaan caadooyinka isticmaalka noocii hore, sheyga ugu dambeeyaana waa inuu wax ka beddelo galka kaydinta ee keydka xogta.

            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
        

Adeeg bilow

            systemctl enable mysqld
systemctl start mysqld
        

Hel lambarka sirta ah ee isku xirka asalka

MySQL8 lambarka sirta ah ee lagu xidho 'root login password' ayaa lagu kaydiyaa faylka faylka, waxaan u baahan nahay inaan ka aragno faylka qoraalka.

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

Adeegga Xaqiijinta

Ilaa hadda rakibaadeyntii iyo qaabeyntii waa la dhammeeyay, waxaan u adeegsanaa qadka amarka si aan ugu xirno adeegga MySQL, ka dibna aan u abuurno xog-ururin iyo koonto.

            mysql -uroot -p