Wụnye MariaDB 10.4 na CentOS7

Ntughari

Tinye faịlụ REPO

Jiri vi ma ọ bụ vim iji dezie faịlụ /etc/yum.repos.d/MariaDB.repo, detuo ọdịnaya ndị a na faịlụ ahụ, wee chekwaa ma pụọ.

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

Mee ọrụ ntinye ma bido ọrụ ahụ

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

Mepụta onye ọrụ ma nye ikike

Mgbe echichi ahụ mechara, anyị nwere ike ịbanye na MariaDB ozugbo na igwe a wee nye ya ikike. Otu isi ihe chọrọ nlebara anya pụrụ iche maka ịrụ ọrụ ikike bụ na ịnweghị ike dochie localhost mgbe ị jiri% wepu adreesị niile, yabụ ọ bụrụ na anyị ejiri localhost nweta igwe a, anyị ga-enyerịrị ikike ọzọ. Mgbe ikike mechara, a ga-enyerịrị ikike ahụ, ma ọ bụghị na ọ gaghị emetụta. Maka nkọwapụta, biko rụtụ aka na ihe atụ na-esonụ.

            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;
        

Ọrụ nkwenye

Mgbe enyere ikike, anyị jiri akaụntụ ọhụrụ ahụ banye na MariaDB. Ọ bụrụ na anyị nwere ike ijikọ nke ọma, nhazi ahụ na-aga nke ọma. Anyị kwesịkwara iji igwe ndị ọzọ iji jikọọ iji nwalee ma igwe ndị na-abụghị nke obodo nwere ike ijikọ MariaDB. Ọ bụrụ na njikọ ada ada, lelee ma firewall amachibidoro.

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