Isa MariaDB 10.4 pane CentOS7

Refer

Wedzera REPO faira

Shandisa vi kana vim kugadzirisa iyo /etc/yum.repos.d/MariaDB.repo faira, teedzera zvinotevera zvirimo kune iyo faira, wobva wachengeta uye kubuda.

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

Ita iyo yekuisa oparesheni uye tanga sevhisi

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

Gadzira mushandisi uye bvumidza

Mushure mekumisikidza kwapera, tinogona kupinda kuna MariaDB zvakananga pamushini uyu tobva tamupa mvumo. Imwe poindi inoda kutariswa kwakakosha kwekubvumidzwa mashandiro ndeyekuti haugone kutsiva localhost kana iwe uchishandisa% kukadhi kadhi kero dzese, saka kana tikashandisa localhost kuwana muchina uyu, tinofanirwa kubvumidza zvakare. Mushure mekupihwa mvumo kwapera, mvumo dzinofanirwa kuzorodzwa, zvikasadaro hazvizoshanda. Nezve ruzivo, ndapota tarisa kune unotevera muenzaniso.

            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;
        

Kuongorora Service

Mushure mekubvumidzwa, isu tinoshandisa iyo account nyowani kupinda muMariaDB.Kana iko kubatana kuri kubudirira, kumisikidzwa kuri kubudirira. Isu tinodawo kushandisa mimwe michina kuti ubatanidze kuyedza kana asiri emunharaunda michina inogona kubatana naMariaDB. Kana kubatana kwacho kukatadza, tarisa kana firewall ichirambidzwa.

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