Whakauruhia a MariaDB 10.4 ki CentOS7

Tohutoro

Taapirihia te konae REPO

Whakamahia te vi, to vim ranei hei whakatika i te /etc/yum.repos.d/MariaDB.repo konae, kape i nga korero e whai ake nei ki te konae, ka penapena ka puta.

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

Whakamahia te mahi whakauru ka tiimata te ratonga

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

Waihangahia te kaiwhakamahi me te whakamana

Mutu ana te whakaurunga, ka taea e taatau te takiuru ki a MariaDB tika i runga i tenei miihini ka whakamana ai. Ko tetahi tohu e tika ana kia aro nui mo te mahi whakamana ko te kore e taea e koe te whakakapi i te localhost ka whakamahi koe i te% ki te panui i nga wahitau katoa, no reira mena ka whakamahia e tatou te localhost ki te uru ki tenei miihini, me whakamana ano e taatau. Ka mutu te whakamana, me whakahou nga whakaaetanga, mena ka kore e mana. Mo nga korero taipitopito, tirohia te tauira e whai ake nei.

            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;
        

Ratonga Manatoko

I muri i te whakamana, ka whakamahia e maatau te kaute hou ki te takiuru ki a MariaDB. Mena kua angitu te hononga, kua angitu te whirihoranga. Me whakamahi ano e taatau miihini tetahi atu hei hono atu ki te whakamatautau mena ka taea e nga miihini kore-rohe te hono atu ki a MariaDB. Mena kua kore te hononga, tirohia mena ka aukatia te pātūahi.

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