Shyiramo MariaDB 10.4 kuri CentOS7

Reba

Ongeraho dosiye ya REPO

Koresha vi cyangwa vim kugirango uhindure dosiye /etc/yum.repos.d/MariaDB.repo, wandukure ibikurikira muri dosiye, hanyuma ubike hanyuma usohoke.

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

Kora ibikorwa byo kwishyiriraho hanyuma utangire serivisi

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

Kurema umukoresha no gutanga uburenganzira

Nyuma yo kwishyiriraho birangiye, dushobora kwinjira muri MariaDB kuriyi mashini hanyuma tukabiha uburenganzira. Ingingo imwe ikeneye kwitabwaho byumwihariko kubikorwa byemewe ni uko udashobora gusimbuza localhost mugihe ukoresheje% kuri ikarita yerekana aderesi zose, niba rero dukoresheje localhost kugirango tugere kuri iyi mashini, tugomba kongera gutanga uburenganzira. Uruhushya rumaze kurangira, uruhushya rugomba kuvugururwa, bitabaye ibyo ntiruzatangira gukurikizwa. Kubisobanuro birambuye, nyamuneka reba kurugero rukurikira.

            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;
        

Serivisi ishinzwe kugenzura

Nyuma yo gutanga uburenganzira, dukoresha konti nshya kugirango twinjire muri MariaDB.Niba dushobora guhuza neza, iboneza riratsinda. Tugomba kandi gukoresha izindi mashini kugirango duhuze kugirango tumenye niba imashini zitari iz'ibanze zishobora guhuza na MariaDB. Niba ihuza ryananiwe, reba niba firewall yabujijwe.

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