Faka iMariaDB 10.4 kuCentOS7

Inkomba

Faka ifayela le-REPO

Sebenzisa i-vi noma i-vim ukuhlela ifayili le /etc/yum.repos.d/MariaDB.repo, ukopishe okuqukethwe okulandelayo kufayela, bese ulondoloza bese uphuma.

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

Yenza umsebenzi wokufaka bese uqala insiza

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

Dala umsebenzisi futhi ugunyaze

Ngemuva kokuthi ukufakwa kuqediwe, singangena ngemvume kuMariaDB ngqo kulo mshini, bese sigunyaza. Iphuzu elilodwa elidinga ukunakekelwa okukhethekile ekusebenzeni kokugunyazwa ukuthi awukwazi ukufaka indawo yendawo yasendaweni lapho usebenzisa i-% ukufaka amakhadi wasendle wonke amakheli, ngakho-ke uma sisebenzisa i-localhost ukufinyelela lo mshini, kufanele sigunyaze futhi. Ngemuva kokuqedwa kokugunyazwa, izimvume kufanele zivuselelwe, ngaphandle kwalokho ngeke zisebenze. Ngemininingwane, sicela ubheke isibonelo esilandelayo.

            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;
        

Insiza Yokuqinisekisa

Ngemuva kokugunyazwa, sisebenzisa i-akhawunti entsha ukungena ngemvume kuMariaDB. Uma ukuxhumana kuphumelele, ukumiswa kuyaphumelela. Sidinga futhi ukusebenzisa eminye imishini ukuxhuma ukuhlola ukuthi imishini engeyona eyasendaweni ingaxhuma yini kuMariaDB. Uma ukuxhumeka kwehluleka, hlola ukuthi ngabe i-firewall ivinjelwe.

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