Fi MariaDB 10.4 sori CentOS7

Itọkasi

Ṣafikun faili REPO

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

            [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
        

Ṣe iṣẹ fifi sori ẹrọ ki o bẹrẹ iṣẹ naa

            yum -y install MariaDB-server MariaDB-client
systemctl enable mariadb
systemctl start mariadb
        

Ṣẹda olumulo ki o fun laṣẹ

Lẹhin fifi sori ẹrọ ti pari, a le wọle si MariaDB taara lori ẹrọ yii lẹhinna fun laṣẹ. Oju kan ti o nilo ifojusi pataki fun iṣẹ aṣẹ ni pe o ko le ropo localhost nigbati o ba lo% lati ṣe igbasilẹ gbogbo awọn adirẹsi, nitorinaa ti a ba lo localhost lati wọle si ẹrọ yii, a gbọdọ fun laṣẹ lẹẹkansii. Lẹhin asẹ ti pari, awọn igbanilaaye gbọdọ wa ni itura, bibẹẹkọ kii yoo ni ipa. Fun awọn alaye, jọwọ tọka si apẹẹrẹ atẹle.

            grant all privileges on *.* to 'username'@'%' identified by 'password' with grant option;
grant all privileges on *.* to 'username'@'localhost' identified by 'password' with grant option;
flush privileges;
        

Iṣẹ ijerisi

Lẹhin asẹ, a lo akọọlẹ tuntun lati wọle si MariaDB Ti asopọ naa ba ṣaṣeyọri, iṣeto naa ṣaṣeyọri. A tun nilo lati lo awọn ẹrọ miiran lati sopọ lati ṣe idanwo boya awọn ẹrọ ti kii ṣe ti agbegbe le sopọ si MariaDB. Ti asopọ naa ba kuna, ṣayẹwo boya ogiriina ti ni ihamọ.

            mysql -u username -p password
mysql -h x.x.x.x -u username -p password