Debian Jessie-de MariaDB 10.1 gurmak we dürli MariaDB talaplaryny işletmek
Geçen makalamyzda “MySQL” -ni satyn almagyň arkasyndaky hekaýa we “MariaDB” -iň ýokarlanmagy ýokary baha berildi. Bu makalada, MySQL-den çykmagyň zerurlygy, MariaDB-iň ýokarlanmagy, onuň aýratynlyklary, MariaDB we MySQL-ni deňeşdirip öwrenmek, dünýä belli korporasiýalaryň we kompaniýalaryň (Google, Wikipediýa) MySQL-den MariaDB-e geçmegi barada maslahat etdik. we başga-da köp tehniki we tehniki däl tarapy.
Bu ýerde Debian Jessie (Testing) -da MariaDB 10.1 gurmakçy we kiçijik tablisalary döretmek we öwrenmek we düşünmek prosesinde birnäçe soragy işletmek arkaly synagdan geçireris.
Debian Jessie-de MariaDB 10.1 guruň
Debian ulgamlarynda, resmi ammarlardan MariaDB gurnama başlamazdan ozal, python-software-häsiýetleri paketini gurmak maslahat berilýär.
# apt-get install python-software-properties
Ondan soň, göçürip alýan programma üpjünçiliginiň bitewiligini barlamaga laýyk mümkinçilik berýän GPG açaryny import ediň we bellige alyň.
# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
Indi, aşakdaky buýrugy ulanyp, source.list faýlyňyza aşakdaky MariaDB resmi ammaryny goşuň.
# add-apt-repository 'deb http://mariadb.biz.net.id//repo/10.1/debian sid main'
Ammar goşmak\ add-apt-repository: buýruk tapylmady ýaly ýalňyşlyk goýberýän bolsa, aşakda görkezilişi ýaly programma üpjünçiligi-häsiýetleri-umumy gurmaly.
# apt-get install software-properties-common
Ulgamdaky elýeterli paketleriň sanawyny täzeläň.
# apt-get update
Ahyrynda, aşakdaky buýruklary ulanyp, MariaDB Serwerini we Müşderisini guruň.
# apt-get install mariadb-server mariadb-client
Eger gurnama göwnejaý bolsa, Gurlan MariaDB wersiýasyny barlaň.
# mysql -V mysql Ver 15.1 Distrib 5.5.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1
MariaDB-e kök ulanyp maslahat beriň (maslahat berilmeýär), soňra bolsa parol.
$ 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)]>
BELLIK: aboveokardaky ýok, häzirki wagtda maglumat bazasynyň saýlanmandygyny aňladýar.
Dürli MariaDB soraglaryny işletmek
MariaDB-de nädip ulanyjy döretmeli. MariaDB-de ulanyjy döretmek üçin aşakdaky sintaksis ulanyň.
CREATE USER 'USER_NAME' IDENTIFIED BY 'PASSWORD';
Mysal üçin, “ sam123 ” paroly bilen “ sam ” ulanyjyny döretmek üçin ýerine ýetirmeli.
MariaDB [(none)]> CREATE USER 'sam' IDENTIFIED BY 'sam123'; Query OK, 0 rows affected (0.00 sec)
Indi çykyň MariaDB we ulanyjy sam ulanyp giriň.
$ 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)]>
MySQL ulanyjysyny sam öçüriň/taşlaň.
MariaDB [(none)]> DROP USER sam; Query OK, 0 rows affected (0.00 sec)
Bar bolan maglumatlar bazasyna serediň.
MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.04 sec)
BELLIK: aboveokardaky görkezilen maglumatlar bazalarynyň hemmesini MariaDB Içerki ulanýar. Näme edýändigiňizi bilmeseňiz, bu maglumat bazalaryny redaktirlemäň.
Sanawdan maglumat bazasyny saýlaň (Soraglary işletmek zerur).
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]>
Maglumat bazasynyň içindäki ähli tablisalary görkeziň.
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)
Tablisadaky ähli sütünlere serediň, maglumatlar bazasyndan ulanyjy diýilýän mysql. Iki soragyň ikisini ulanyň.
SHOW COLUMNS FROM user; or DESCRIBE user;
Iki soragyň netijesi birmeňzeş.
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)
MariaDB-iň giň serwer ýagdaýy baradaky maglumatlara serediň.
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)
Maglumat bazasyny döretmek üçin ulanylan MariaDB beýanyna mysql diýiň.
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)
Tablisa döretmek üçin ulanylan MariaDB beýanyna ulanyjy diýiň.
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', ....
MariaDB ulanyjysynyň hemmesine berlen howpsuzlyk hukuklaryna serediň.
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)
MariaDB serweriniň DUNDURYŞlaryna serediň.
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)
MariaDB hyzmatynyň säwliklerine serediň.
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)
Bularyň hemmesi häzirlikçe. SHOW beýanynda köp aýratynlyk bar, indiki makalada islenýän netijäni almak üçin MariaDB-de işlenmeli beýleki soraglar bilen bilelikde ara alyp maslahatlaşarys. Soňra “Tecmint” -e birikdiriň. Aşakdaky teswirler bölüminde bize gymmatly pikirleriňizi bermegi ýatdan çykarmaň.