Shigar da MariaDB 10.1 a cikin Debian Jessie da Gudun Tambayoyi daban-daban na MariaDB
A cikin labarinmu na ƙarshe Labarin Bayan Samun 'MySQL' da Tashin 'MariaDB' an yaba sosai. A cikin wannan labarin, mun riga mun tattauna buƙatar cokali mai yatsa na MySQL, haɓakar MariaDB, Siffofinsa, nazarin kwatancen MariaDB da MySQL, Motsi na wasu manyan kamfanoni da Kamfanoni na duniya (Google, Wikipedia) daga MySQL zuwa MariaDB da sauran fannonin fasaha da na fasaha da yawa game da shi.
Anan za mu Sanya MariaDB 10.1 akan Debian Jessie (Gwaji) kuma za mu gwada ta ta hanyar ƙirƙirar ƙananan tebur da gudanar da tambayoyi da yawa a cikin tsarin koyo da fahimta.
Sanya MariaDB 10.1 akan Debian Jessie
A ƙarƙashin tsarin Debian, ana ba da shawarar sosai don shigar da '' Python-software-properties' kunshin, kafin a tashi don shigarwar MariaDB daga wuraren ajiyar hukuma.
# apt-get install python-software-properties
Bayan haka, shigo da yin rajistar maɓalli na GPG, wanda ke ba da damar apt don tabbatar da amincin software ɗin da yake saukewa.
# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
Yanzu, ƙara ma'ajiyar hukuma ta MariaDB mai zuwa zuwa fayil ɗin ku na Source.list, ta amfani da umarni mai zuwa.
# add-apt-repository 'deb http://mariadb.biz.net.id//repo/10.1/debian sid main'
Idan ƙara wurin ajiya yana jefa kuskure kamar \add-apt-repository: umarni ba a samo ba, kuna buƙatar shigar da 'software-properties-common' kamar yadda aka nuna a ƙasa.
# apt-get install software-properties-common
Sabunta jerin fakitin da ke akwai akan tsarin.
# apt-get update
A ƙarshe, shigar MariaDB Server da Client, ta amfani da waɗannan umarni.
# apt-get install mariadb-server mariadb-client
Idan shigarwa ya tafi santsi, duba sigar shigar MariaDB.
# mysql -V mysql Ver 15.1 Distrib 5.5.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1
Shiga zuwa MariaDB ta amfani da tushen (Ba a Shawarar ba), sannan kalmar wucewa.
$ mysql -u root -p
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 28 Server version: 5.5.38-MariaDB-1 (Debian) Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
NOTE: 'Babu' a sama, yana nufin ba a zaɓi Database a halin yanzu.
Gudun Tambayoyin MariaDB Daban-daban
Yadda ake ƙirƙirar mai amfani a cikin MariaDB. Yi amfani da mahallin mahallin don ƙirƙirar mai amfani a cikin MariaDB.
CREATE USER 'USER_NAME' IDENTIFIED BY 'PASSWORD';
Misali, don ƙirƙirar Mai amfani ''sam' tare da kalmar sirri '' sam123', muna buƙatar aiwatarwa.
MariaDB [(none)]> CREATE USER 'sam' IDENTIFIED BY 'sam123'; Query OK, 0 rows affected (0.00 sec)
Yanzu fita MariaDB kuma shiga ta amfani da mai amfani sam.
$ mysql -u 'sam' -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 36 Server version: 5.5.38-MariaDB-1 (Debian) Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Share/Dauke MySQL mai amfani 'sam'.
MariaDB [(none)]> DROP USER sam; Query OK, 0 rows affected (0.00 sec)
Duba duk da akwai Database.
MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.04 sec)
NOTE: Duk bayanan da aka nuna a sama ana amfani da su ta cikin MariaDB. Kada ku gyara waɗannan bayanan bayanai sai dai idan kun san abin da kuke yi.
Zaɓi Database daga lissafin (Wajibi don gudanar da Tambayoyi).
MariaDB [(none)]> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [mysql]>
Nuna duk allunan dake cikin Database.
MariaDB [mysql]> SHOW TABLES; | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | event | | func | | general_log | | help_category | | help_keyword | | help_relation | | help_topic | ..... 24 rows in set (0.00 sec)
Duba duk ginshiƙan daga tebur suna faɗi 'mai amfani' daga Database'mysql'. Yi amfani da ɗaya daga cikin tambayoyin biyun.
SHOW COLUMNS FROM user; or DESCRIBE user;
Sakamakon duka tambayoyin guda ɗaya ne.
MariaDB [mysql]> describe user;
+------------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
.......
42 rows in set (0.01 sec)Duba babban bayanin matsayin uwar garke na MariaDB.
MariaDB [mysql]> SHOW STATUS; +------------------------------------------+----------------------+ | Variable_name | Value | +------------------------------------------+----------------------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Access_denied_errors | 0 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 15737 | | Aria_pagecache_blocks_used | 2 | | Aria_pagecache_read_requests | 176 | | Aria_pagecache_reads | 4 | | Aria_pagecache_write_requests | 8 | .... 419 rows in set (0.00 sec)
Dubi bayanin MariaDB wanda aka yi amfani da shi don ƙirƙirar Database ce 'mysql'.
MariaDB [mysql]> SHOW CREATE DATABASE mysql; +----------+------------------------------------------------------------------+ | Database | Create Database | +----------+------------------------------------------------------------------+ | mysql | CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+------------------------------------------------------------------+ 1 row in set (0.00 sec)
Dubi bayanin MariaDB wanda aka yi amfani da shi don ƙirƙirar Tebu ka ce 'mai amfani'.
MariaDB [mysql]> SHOW CREATE TABLE user;
+
| Table | Create Table
+-------
| user | CREATE TABLE `user` (
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
....Dubi haƙƙin tsaro da aka ba wa mai amfani da MariaDB.
MariaDB [mysql]> SHOW GRANTS; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for [email | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*698vsgfkemhvjh7txyD863DFF63A6bdfj8349659232234bs3bk5DC1412A' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)
Dubi WARNINGS na uwar garken MariaDB.
MariaDB [mysql]> SHOW WARNINGS; +--------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code |Message | +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON mysql' at line 1 | +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
Duba Kurakurai na hidimar MariaDB.
MariaDB [mysql]> SHOW ERRORS; +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON mysql' at line 1 | +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
Shi ke nan don Yanzu. Bayanin 'SHOW' yana da fasali da yawa, waɗanda za mu tattauna a cikin labarin nan gaba tare da wasu tambayoyin da za a gudanar akan MariaDB don samun sakamakon da ake so. Har sai a saurara kuma ku haɗa zuwa Tecment. Kar ku manta da samar mana da ra'ayoyin ku masu mahimmanci a cikin sashin sharhin da ke ƙasa.