Yadda ake Shigar Database na MariaDB a Debian 10

MariaDB shine tushen buɗe-yanar gizo kuma sanannen tsarin tsarin tattara bayanai (RDBMS) waɗanda asalin masu haɓaka MySQL suka yi. Tsarin tsari ne mai sauri, mai iya karuwa kuma mai karfi, tare da wadataccen yanayin halittar injina masu adanawa, kari, da sauran kayan aikin da yawa wadanda suke samar da tsarin SQL don samun bayanai.

MariaDB ingantacciya ce, sauya-wuri don maye gurbin MySQL da ƙungiyoyi da kamfanoni ke amfani da su kamar Wikipedia, WordPress.com, Google da sauran su.

A cikin wannan gajeriyar labarin, zamu nuna muku yadda ake girka da amintar da sabar MariaDB a cikin Debian 10.

  1. Sanya Debian 10 (Buster) Mafi qarancin Server

Lura: Idan kuna aiki da tsarin azaman mara amfani da tsarin mulki, yi amfani da sudo domin samun gatanan tushen idan kuma kuna sanya MySQL kuna aiki, to ku dakatar dashi kuma ku kashe shi kafin ku ci gaba.

Shigar da Sabis na MariaDB a Debian 10

Kuna iya shigar da kunshin sabar MariaDB daga rumbun hukuma na Debian ta hanyar aiwatar da wannan umarni, wanda zai girka uwar garken MariaDB, abokin harka da duk masu dogaro da shi.

# apt install mariadb-server

Wannan al'ada ce ta gama gari tsakanin Debian da dangoginsu kamar Ubuntu don farawa da kunna taemon ta atomatik ta hanyar sarrafawa, kai tsaye bayan an girka su. Hakanan ya shafi sabis ɗin MariaDB.

Kuna iya bincika ko sabis ɗin MariaDB yana aiki kuma yana aiki ta amfani da umarnin systemctl mai zuwa.

# systemctl status mariadb

Allyari, kuna buƙatar sanin wasu ƙa'idodi na yau da kullun don gudanar da sabis ɗin MariaDB ƙarƙashin tsarin, waɗanda suka haɗa da umarni don farawa, sake kunnawa, dakatarwa da sake shigar da sabis ɗin MariaDB kamar yadda aka nuna.

# systemctl start mariadb
# systemctl restart mariadb
# systemctl stop mariadb
# systemctl reload mariadb

Kulla Sabar MariaDB a cikin Debian 10

Tsarin shigarwa na MariaDB ya hada da tabbatar da kafuwa ta asali kuma ana iya yinta ta hanyar gudanar da rubutun mysql_secure_installation , wanda zai baka damar kara dan karin tsaro a tsarin ka na MariaDB ta:

  • Kafa kalmar wucewa don asusun asusu.
  • Kashe hanyar shiga nesa.
  • Cire asusun asusun mai amfani da ba a sani ba.
  • Cire bayanan jarabawar, wanda ta hanyar tsoho za a iya samun damar ta masu amfani da ba a sani ba.
  • Kuma sake loda gata.

Don kiran rubutun tsaro, gudanar da umarni mai zuwa kuma amsa tambayoyin kamar yadda aka nuna a cikin hoton da ke tafe.

Da zarar kun amintar da girkin MariaDB ɗinku, zaku iya haɗuwa da mysql shell ta amfani da kalmar sirri ta mai amfani.

# mysql -u root -p

Don ƙirƙirar rumbun adana bayanai mai suna \"my_test_db \" da kuma mai amfani mai suna \"test_user \" tare da cikakkun dama don gudanar da rumbun adana bayanan dokokin SQL masu zuwa.

MariaDB [(none)]> CREATE DATABASE  my_test_db;
MariaDB [(none)]> GRANT ALL ON my_test_db.* TO 'test_user'@'localhost' IDENTIFIED BY 'test_user_pass_here' WITH GRANT OPTION;
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;

Bayan ƙirƙirar sabon rumbun adana bayanai da mai amfani da rumbun adana bayanai, yi ƙoƙari ku sami damar shiga cikin ɗakunan MariaDB ta amfani da sabon asusun mai amfani da nuna duk bayanan bayanan da aka sanya wa mai amfani kamar haka.

# mysql -u test_user -p
MariaDB [(none)]> SHOW DATABASES;

Hakanan kuna iya karanta waɗannan labaran masu amfani akan MariaDB.

  1. Koyi MySQL/MariaDB don Masu farawa - Sashe na 1
  2. Koyi Yadda Ake Amfani da Ayyuka da yawa na MySQL da MariaDB - Sashe na 2
  3. 12 MySQL/MariaDB Tsaro Mafi Kyawun Ayyuka don Linux
  4. Yadda ake Ajiyayyen/Sake dawo da MySQL/MariaDB da PostgreSQL Ta amfani da 'Automysqlbackup' da 'Autopostgresqlbackup' Kayan aiki
  5. Amfani mai Amfani don magance Matsalolin da ke Ciki a cikin MySQL

Wannan kenan a yanzu! A cikin wannan jagorar, mun nuna yadda za a girka da amintar da sabar MariaDB a cikin Debian 10 mafi ƙarancin sabar shigarwa. Yi amfani da hanyar sharhi da ke ƙasa don isa gare mu don kowane tambayoyi ko bayanin da kuke son rabawa tare da mu.