Ikani MariaDB 10.4 pa CentOS7

Kutchulidwa

Onjezani fayilo ya REPO

Gwiritsani ntchito vi kapena vim kusintha fayilo ya /etc/yum.repos.d/MariaDB.repo, lembani zotsatirazi mufayiloyi, kenako sungani ndi kutuluka.

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

Yesetsani kukhazikitsa ndikuyamba ntchito

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

Pangani wosuta ndikuvomereza

Pambuyo pomaliza kukonza, titha kulowa mu MariaDB mwachindunji pamakinawa kenako ndikuvomereza. Mfundo imodzi yomwe imafunikira chisamaliro chapadera chololeza kuti musalowe m'malo mwa localhost mukamagwiritsa ntchito% ku wildcard ma adilesi onse, chifukwa chake ngati tigwiritsa ntchito localhost kupeza makina awa, tiyenera kuvomerezanso. Chilolezo chikamalizidwa, zilolezo ziyenera kutsitsimutsidwa, apo ayi sizigwira ntchito. Kuti mumve zambiri, chonde onani zitsanzo zotsatirazi.

            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;
        

Ntchito Yotsimikizira

Pambuyo chilolezo, timagwiritsa ntchito akaunti yatsopano kulowa mu MariaDB. Tiyeneranso kugwiritsa ntchito makina ena kulumikizana kuti tiwone ngati makina osakhala akomweko amatha kulumikizana ndi MariaDB. Ngati kulumikizana kukulephera, onani ngati firewall ili yoletsedwa.

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