Fi sori ẹrọ ati tunto MySQL8 lori CentOS7

2021-01-08 CentOS7 MySQL

Itọkasi

Oju opo wẹẹbu osise Iwe Akọsilẹ Ọja

Ṣafikun faili REPO

Lo vi tabi vim lati satunkọ faili /etc/yum.repos.d/mysql-community.repo, daakọ akoonu atẹle si faili naa, lẹhinna fipamọ ki o jade.

            [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

Ṣe fifi sori ẹrọ

            yum -y install mysql-community-server

Ṣe atunṣe faili iṣeto

Lo vi tabi vim lati satunkọ /etc/my.cnf. Bii MySQL8 ṣe akawe pẹlu ẹya ti tẹlẹ, ọna ṣiṣe aiyipada ti iwọle, riru ọrọ SQL ati ipari aaye ti ko to ti yipada, nitorinaa ti a ba nilo lati tọju bakanna bi iṣaaju, ṣe iṣeto atẹle. Ti o ko ba nilo lati ni ibamu pẹlu eto atijọ, o le foju rẹ. Ninu iṣeto ti a ṣe atunṣe ti apẹẹrẹ atẹle, awọn ohun mẹta akọkọ ni lati ni ibaramu pẹlu awọn ihuwasi lilo ti ẹya atijọ, ati ohun ti o kẹhin ni lati yipada itọsọna ibi ipamọ aiyipada ti ibi ipamọ 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

Ibere ​​iṣẹ

            systemctl enable mysqld
systemctl start mysqld

Gba ọrọigbaniwọle asopọ aiyipada

Ọrọ igbaniwọle iwọle ti root abinibi MySQL8 wa ni fipamọ ni faili log, a nilo lati ṣayẹwo rẹ lati faili log.

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

Iṣẹ ijerisi

Nitorinaa fifi sori ẹrọ ati iṣeto wa ti pari, a lo laini aṣẹ lati sopọ si iṣẹ MySQL, ati lẹhinna ṣẹda ibi ipamọ data ati akọọlẹ kan.

            mysql -uroot -p