Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 6


A cikin koyaswar da ta gabata, mun nuna muku yadda ake shigar da MariaDB 10 a cikin CentOS 7. A cikin wannan jagorar, za mu nuna muku yadda ake shigar da amintaccen sigar MariaDB 10.1 a cikin rarraba RHEL/CentOS 6.

Lura cewa a cikin wannan koyawa, za mu ɗauka aikin ku akan sabar azaman tushen, in ba haka ba, yi amfani da umarnin sudo don gudanar da duk umarni.

Mataki 1: Ƙara Ma'ajiyar MariaDB Yum

1. Da farko, ƙara shigarwar maajiyar MariaDB YUM don tsarin RHEL/CentOS 6. Ƙirƙiri fayil ɗin /etc/yum.repos.d/MariaDB.repo.

# vi /etc/yum.repos.d/MariaDB.repo

Bayan haka kwafa da liƙa layukan da ke ƙasa cikin fayil ɗin kuma adana shi.

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

Mataki 2: Sanya MariaDB a cikin CentOS 6

2. Bayan ƙara ma'ajiyar MariaDB, shigar da fakitin uwar garken MariaDB kamar haka:

# yum install MariaDB-server MariaDB-client -y

3. Da zarar an gama shigarwa na fakitin MariaDB, fara daemon uwar garken bayanai na ɗan lokaci, sannan kuma ba shi damar farawa ta atomatik a taya ta gaba kamar ƙasa:

# service mysqld start
# chkconfig --level 35 mysqld on
# service mysqld status

Mataki 3: Amintacce MariaDB a cikin CentOS 6

4. Yanzu gudanar da rubutun mysql_secure_installation don amintar da bayanan ta: saita kalmar sirri (idan ba a saita shi a cikin matakan daidaitawa a sama ba), kashe tushen shiga nesa, cire bayanan gwajin da masu amfani da ba a san su ba kuma a ƙarshe sake loda gata kamar yadda aka nuna a allon. harbi a kasa:

# mysql_secure_installation

5. Bayan shigar da uwar garken MariaDB, kuna iya bincika wasu fasalulluka na MariaDB kamar: sigar shigarwa, jerin muhawarar shirin tsoho, da kuma shiga cikin harsashi na MariaDB kamar haka:

# mysql -V
# mysql --print-defaults
# mysql -u root -p

Mataki 4: Koyi Gudanarwar MariaDB

Don farawa, zaku iya shiga:

  1. Koyi MySQL/MariaDB don Mafari - Kashi na 1
  2. Koyi MySQL/MariaDB don Masu farawa - Kashi na 2
  3. MySQL Dokokin Gudanarwa na Basic Database – Sashe na III
  4. 20 MySQL (Mysqladmin) Umarni don Gudanar da Database – Sashe na IV

Idan kun riga kun yi amfani da MySQL/MariaDB, yana da mahimmanci ku tuna da jerin kayan aikin umarni masu amfani zuwa MySQL/MariaDB aikin kunnawa da ingantawa.

A cikin wannan jagorar, mun nuna muku yadda ake shigar da amintaccen sigar MariaDB 10.1 a cikin RHEL/CentOS 6. Yi amfani da fom ɗin amsa da ke ƙasa don aiko mana da kowace tambaya ko kowane tunani game da wannan jagorar.