Faka uMariaDB 10.4 kwi-CentOS7

Isalathiso

Yongeza ifayile yeREPO

Sebenzisa vi okanye vim ukuhlela i /etc/yum.repos.d/MariaDB.repo ifayile, ukope umxholo olandelayo kwifayile, emva koko ugcine kwaye uphume.

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

Yenza ufakelo kwaye uqalise inkonzo

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

Yenza umsebenzisi kwaye ugunyaze

Emva kokuba ufakelo lugqityiwe, sinako ukungena kuMariaDB ngqo kulo matshini emva koko sigunyazise oko. Inqaku elinye elifuna ukuhoywa ngokukodwa ekusebenzeni kokugunyaziswa kukuba awukwazi ukubuyisela indawo yangaphakathi xa usebenzisa i-% kwikhadi lasendle zonke iidilesi, ke ukuba sisebenzisa i-localhost ukufikelela kulo matshini, kufuneka sigunyazise kwakhona. Emva kokuba isigunyaziso sigqityiwe, iimvume kufuneka zihlaziywe, kungenjalo azizukusebenza. Ngeenkcukacha, nceda ujonge kulo mzekelo ulandelayo.

            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;
        

Inkonzo yokuqinisekisa

Emva kogunyaziso, sisebenzisa iakhawunti entsha ukungena kwiMariaDB.Ukuba unxibelelwano luyaphumelela, ubumbeko luyaphumelela. Kuya kufuneka sisebenzise abanye oomatshini ukunxibelelana ukuvavanya ukuba ngaba oomatshini abangahlaliyo banokudibanisa neMariaDB. Ukuba uqhagamshelo aluphumeleli, jonga ukuba i-firewall ithintelwe na.

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