L-installazzjoni ta' MariaDB 10.1 f'Debian Jessie u t-Tmexxija ta' Diversi Mistoqsijiet MariaDB
Fl-aħħar artiklu tagħna The Story Behind Acquisition of 'MySQL' and the Rise of 'MariaDB' kienet apprezzata ħafna. F'dan l-artikolu, aħna diġà ddiskutejna l-ħtieġa li jitfork MySQL, iż-żieda ta 'MariaDB, Karatteristiċi tiegħu, studju komparattiv ta' MariaDB u MySQL, Moviment ta 'wħud mill-Kumpaniji u Kumpaniji rinomati fid-dinja (Google, Wikipedia) minn MySQL għal MariaDB u ħafna aspett ieħor tekniku u mhux tekniku tiegħu.
Hawnhekk se ninstallaw MariaDB 10.1 fuq Debian Jessie (Ittestjar) u se nkunu qed nittestjawha billi noħolqu tabelli żgħar u nħaddmu diversi mistoqsijiet fil-proċess tat-tagħlim u l-fehim.
Installa MariaDB 10.1 fuq Debian Jessie
Taħt is-sistemi Debian, huwa rakkomandat ħafna li tinstalla l-pakkett 'python-software-properties', qabel ma titla' għall-installazzjoni MariaDB minn repożitorji uffiċjali.
# apt-get install python-software-properties
Sussegwentement, importa u rreġistra ċ-ċavetta GPG, li tippermetti lil apt li tivverifika l-integrità tas-softwer li tniżżel.
# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
Issa, żid ir-repożitorju uffiċjali MariaDB li ġej mal-fajl sources.list tiegħek, billi tuża l-kmand li ġej.
# add-apt-repository 'deb http://mariadb.biz.net.id//repo/10.1/debian sid main'
Jekk iż-żieda ta 'repożitorju tarmi żball bħal \add-apt-repository: kmand not found, għandek bżonn tinstalla 'software-properties-common' kif muri hawn taħt.
# apt-get install software-properties-common
Aġġorna l-lista ta' Pakketti disponibbli fis-sistema.
# apt-get update
Fl-aħħarnett, installa MariaDB Server u Klijent, billi tuża l-kmandi li ġejjin.
# apt-get install mariadb-server mariadb-client
Jekk l-installazzjoni tmur bla xkiel, iċċekkja l-verżjoni ta 'Installed MariaDB.
# mysql -V mysql Ver 15.1 Distrib 5.5.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1
Idħol f'MariaDB billi tuża root (Mhux Rakkomandat), segwit minn password.
$ 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)]>
NOTA: L-'ebda dejta' hawn fuq, dan ifisser li l-ebda Database m'hi magħżula bħalissa.
Tmexxi Diversi Mistoqsijiet MariaDB
Kif toħloq utent f'MariaDB. Uża s-sintassi li ġejja biex toħloq utent f'MariaDB.
CREATE USER 'USER_NAME' IDENTIFIED BY 'PASSWORD';
Pereżempju, biex noħolqu Utent 'sam' bil-password 'sam123', irridu nwettqu.
MariaDB [(none)]> CREATE USER 'sam' IDENTIFIED BY 'sam123'; Query OK, 0 rows affected (0.00 sec)
Issa oħroġ MariaDB u illoginja billi tuża l-utent 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)]>
Ħassar/Waqqa 'l-utent MySQL 'sam'.
MariaDB [(none)]> DROP USER sam; Query OK, 0 rows affected (0.00 sec)
Ara d-Database kollha disponibbli.
MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.04 sec)
NOTA: Id-databases kollha murija hawn fuq huma użati minn MariaDB Internament. Teditjax dawn id-databases sakemm ma tkunx taf x'qed tagħmel.
Agħżel Database mil-lista (Meħtieġ biex tmexxi Mistoqsijiet).
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]>
Uri t-tabelli kollha fid-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)
Ara l-kolonni kollha minn tabella jgħidu 'utent' minn Database 'mysql'. Uża waħda miż-żewġ query.
SHOW COLUMNS FROM user; or DESCRIBE user;
Ir-riżultat taż-żewġ mistoqsijiet huma l-istess.
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)Ara informazzjoni estensiva dwar l-istatus tas-server ta' 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)
Ara d-dikjarazzjoni MariaDB li ntużat biex tinħoloq Database jgħidu '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)
Ara d-dikjarazzjoni MariaDB li ntużat biex tinħoloq Tabella tgħid 'utent'.
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',
....Ara d-drittijiet tas-sigurtà mogħtija lill-utent kollu ta' 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)
Ara t-TWISSIJIET tas-server 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)
Ara Żbalji ta' MariaDB serve.
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)
Dak kollu għal Issa. Id-Dikjarazzjoni 'SHOW' għandha ħafna karatteristiċi, li se niddiskutu fl-artiklu futur flimkien ma' mistoqsijiet oħra li għandhom jitmexxew fuq MariaDB biex tikseb ir-riżultat mixtieq. Sa dakinhar ibqa' sintonizzat u mqabbad ma' Tecmint. Tinsiex tagħtina l-feedback siewi tiegħek fit-taqsima tal-kummenti hawn taħt.