{"id":1662,"date":"2017-07-30T18:50:11","date_gmt":"2017-07-30T16:50:11","guid":{"rendered":"http:\/\/miroslaw.borodziuk.eu\/?p=1662"},"modified":"2017-08-01T09:49:09","modified_gmt":"2017-08-01T07:49:09","slug":"system-zarzadzania-baza-danych-mariadb","status":"publish","type":"post","link":"http:\/\/miro.borodziuk.eu\/index.php\/2017\/07\/30\/system-zarzadzania-baza-danych-mariadb\/","title":{"rendered":"System zarz\u0105dzania baz\u0105 danych MariaDB"},"content":{"rendered":"<p><em>MariaDB<\/em> to stosunkowo nowe rozwi\u0105zanie w\u015br\u00f3d system\u00f3w zarz\u0105dzania bazami danych (DBMS &#8211; Data Base Management System). To ulepszona wersja dla s\u0142ynnego <em>MySQLa<\/em>, kt\u00f3ry zosta\u0142 kupiony przez Sun Microsystems (teraz Oracle) w 2008 r.\u00a0 Z powodu polityki Oracla\u00a0 spo\u0142ecze\u0144stwo opensource mia\u0142o mniejszy wp\u0142yw na DBMS i jego rozw\u00f3j znacznie zwolni\u0142. Sk\u0142oni\u0142o to developer\u00f3w <em>MySQLa<\/em> do utworzenia forka <em>MariaDB<\/em> z intencj\u0105 utrzymania go pod licencj\u0105 GNU GPL i kontynuowaniem jego rozwoju.<!--more--><\/p>\n<p><span style=\"color: #3366ff;\">Komendy MariaDB:<\/span><\/p>\n<p><code><span style=\"color: #008000;\"># mysql<\/span><\/code> &#8211; pow\u0142oka do administracji i odpytywania bazy.<\/p>\n<p><code><span style=\"color: #008000;\"># mysql_secure_installation<\/span><\/code> &#8211; zwi\u0119ksza bezpiecze\u0144stwo instalacji MariaDB.<\/p>\n<p><code><span style=\"color: #008000;\"># mysqldump<\/span><\/code> &#8211; backup i przywracanie jednej tabeli, kilku tabel lub ca\u0142ej bazy.<\/p>\n<p>Domy\u015blnym plikiem z logami MariaDB jest <code>\/var\/log\/mariadb\/mariadb.log<\/code>.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Konfiguracja MariaDB.<\/span><\/p>\n<p>G\u0142\u00f3wnym plikiem konfiguracyjnym jest <code>\/etc\/my.cnf<\/code>, w kt\u00f3rym znajduj\u0105 si\u0119 ustawienia domy\u015blne pow\u0142oki <em>mysql<\/em>, skryptu startowego <em>mysql_safe<\/em> i demona <em>mysqld<\/em>.<\/p>\n<pre class=\"lang:sh decode:true\"># grep \u2013v ^# \/etc\/my.cnf\r\n\r\n[mysqld]\r\ndatadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\nsymbolic-links=0\r\n\r\n[mysqld_safe]\r\nlog-error=\/var\/log\/mariadb\/mariadb.log\r\npid-file=\/var\/run\/mariadb\/mariadb.pid\r\n!includedir \/etc\/my.cnf.d<\/pre>\n<p><code>[mysqld]<\/code> to blok zwi\u0105zany z demonem <em>mysqld<\/em> a<code> [mysqld_safe]<\/code> zwi\u0105zany jest z programem startowym. Dyrektywa<code> includedir<\/code> na dole instruuje program startowy aby szuka\u0142 dodatkowych plik\u00f3w konfiguracyjnych w katalogu <code>\/etc\/my.cnf.d<\/code>. Domy\u015blnie w tym katalogu znajduj\u0105 si\u0119 trzy pliku konfiguracyjne:<\/p>\n<pre class=\"lang:sh decode:true \"># ll\r\nrazem 12\r\n-rw-r--r--. 1 root root 295 2016-09-12 client.cnf\r\n-rw-r--r--. 1 root root 232 2016-09-12 mysql-clients.cnf\r\n-rw-r--r--. 1 root root 744 2016-09-12 server.cnf<\/pre>\n<p>W plikach tych znajduje si\u0119 konfiguracja odpowiednio dla klient\u00f3w og\u00f3lnie, konkretnych klient\u00f3w oraz serwera <em>mysqld<\/em>.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Wymagania SELinux dla operacji zwi\u0105zanych z MariaDB.<\/span><\/p>\n<p>S\u0105 dwie zmienne boolean zwiazane z MariaDB:<\/p>\n<pre class=\"lang:sh decode:true \"># getsebool -a | grep mysql\r\nmysql_connect_any --&gt; off\r\nselinuxuser_mysql_connect_enabled --&gt; off<\/pre>\n<p>Te zmienne pozwalaj\u0105 lub zabraniaj\u0105 demonowi mysqld na \u0142\u0105czenie si\u0119 z dowolnym portem i u\u017cytkownikom na pod\u0142\u0105czanie si\u0119 do lokalnego serwera MariaDB.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Instalacja i konfiguracja MariaDB.<\/span><\/p>\n<p>Pakiety w RHEL zwi\u0105zane z MariaDB:<\/p>\n<ul>\n<li><em>mariadb<\/em> &#8211; klient MariaDB i plik konfiguracyjny.<\/li>\n<li><em>mariadb-server<\/em> &#8211; serwer MariaDB, narz\u0119dzia, pliki konfiguracyjne i logi.<\/li>\n<li><em>mariadb-libs<\/em> &#8211; niezb\u0119dne biblioteki dla klienta.<\/li>\n<\/ul>\n<p>1. Instalacja pakiet\u00f3w, start i dodanie do autostartu serwera MariaDB.<\/p>\n<pre class=\"lang:sh decode:true \"># yum -y install mariadb mariadb-server\r\n# systemctl start mariadb\r\n# systemctl enable mariadb<\/pre>\n<p>2. Uruchomienie bezpiecznej instalacji:<\/p>\n<pre class=\"lang:sh decode:true\"># mysql_secure_installation\r\n\r\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\r\nSERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!\r\n\r\nIn order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user. If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\n\r\nEnter current password for root (enter for none):\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\r\nEnter current password for root (enter for none):\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\r\nEnter current password for root (enter for none):\r\nOK, successfully used password, moving on...\r\n\r\nSetting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nSet root password? [Y\/n] Y\r\nNew password: WPISA\u0106 JAKIE\u015a HAS\u0141O\r\nRe-enter new password: WPISA\u0106 JAKIE\u015a HAS\u0141O\r\n\r\nPassword updated successfully!\r\nReloading privilege tables..\r\n... Success!\r\n\r\nBy default, a MariaDB installation has an anonymous user, allowing anyone\r\nto log into MariaDB without having to have a user account created for\r\nthem. This is intended only for testing, and to make the installation\r\ngo a bit smoother. You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] MO\u017bNA WYKASOWA\u0106 U\u017bYTKOWNIK\u00d3W ANONIMOWYCH\r\n... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'. This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] JE\u017bELI ROOT MA NIE LOGOWA\u0106 SI\u0118 ZDALNIE TO DA\u0106 TUTAJ \"Y\".\r\n... skipping.\r\n\r\nBy default, MariaDB comes with a database named 'test' that anyone can\r\naccess. This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] n\r\n... skipping.\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] y\r\n... Success!\r\n\r\nCleaning up...\r\n\r\nAll done! If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for using MariaDB!<\/pre>\n<p>3. Zalogowanie do pow\u0142oki <em>mysql<\/em>:<\/p>\n<pre class=\"lang:sh decode:true\"># mysql -u root -p<\/pre>\n<p>4. Wy\u015bwietlenie pomocy:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [database1]&gt; help;\r\n\r\nGeneral information about MariaDB can be found at\r\nhttp:\/\/mariadb.org\r\n\r\nList of all MySQL commands:\r\nNote that all text commands must be first on line and end with ';'\r\n? (\\?) Synonym for `help'.\r\nclear (\\c) Clear the current input statement.\r\nconnect (\\r) Reconnect to the server. Optional arguments are db and host.\r\ndelimiter (\\d) Set statement delimiter.\r\nedit (\\e) Edit command with $EDITOR.\r\nego (\\G) Send command to mysql server, display result vertically.\r\nexit (\\q) Exit mysql. Same as quit.\r\ngo (\\g) Send command to mysql server.\r\nhelp (\\h) Display this help.\r\nnopager (\\n) Disable pager, print to stdout.\r\nnotee (\\t) Don't write into outfile.\r\npager (\\P) Set PAGER [to_pager]. Print the query results via PAGER.\r\nprint (\\p) Print current command.\r\nprompt (\\R) Change your mysql prompt.\r\nquit (\\q) Quit mysql.\r\nrehash (\\#) Rebuild completion hash.\r\nsource (\\.) Execute an SQL script file. Takes a file name as an argument.\r\nstatus (\\s) Get status information from the server.\r\nsystem (\\!) Execute a system shell command.\r\ntee (\\T) Set outfile [to_outfile]. Append everything into given outfile.\r\nuse (\\u) Use another database. Takes database name as argument.\r\ncharset (\\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.\r\nwarnings (\\W) Show warnings after every statement.\r\nnowarning (\\w) Don't show warnings after every statement.<\/pre>\n<p>5. Wy\u015bwietlenie list baz:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [(none)]&gt; show databases;\r\n+--------------------+\r\n| Database |\r\n+--------------------+\r\n| information_schema |\r\n| mysql |\r\n| performance_schema |\r\n| test |\r\n+--------------------+\r\n4 rows in set (0.00 sec)<\/pre>\n<p>6. Wy\u015bwietlenie pomocy zwi\u0105zanej zwi\u0105zanej z utworzeniem bazy:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [(none)]&gt; ? create;\r\nMany help items for your request exist.\r\nTo make a more specific request, please type 'help &lt;item&gt;',\r\nwhere &lt;item&gt; is one of the following\r\ntopics:\r\nCREATE DATABASE\r\nCREATE EVENT\r\nCREATE FUNCTION\r\nCREATE FUNCTION UDF\r\nCREATE INDEX\r\nCREATE PROCEDURE\r\nCREATE SERVER\r\nCREATE TABLE\r\nCREATE TABLESPACE\r\nCREATE TRIGGER\r\nCREATE USER\r\n......<\/pre>\n<p>6. Utworzenie bazy o nazwie <em>database1<\/em>:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [(none)]&gt; create database database1;\r\nQuery OK, 1 row affected (0.00 sec)<\/pre>\n<p>7. Utworzenie tabeli <em>scientists<\/em> w bazie <em>database1<\/em>:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [baza]&gt; use database1\r\nDatabase changed\r\n\r\nMariaDB [database1]&gt; create table scientists (Sno int,FirstName varchar(20),LastName\r\n-&gt; varchar(20),City varchar(20),Country varchar(20),Age int);\r\nQuery OK, 0 rows affected (0.02 sec)<\/pre>\n<p>8. Wype\u0142nienie tabeli <em>scientists<\/em> danymi:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [database1]&gt; insert into scientists\r\nvalues('1','Albert','Einstein','Ulm','Germany','76');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('2','Isaac','Newton','Woolsthorpe','UK','84');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('3','Marie','Curie','Warsaw','Poland','67');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('4','Galileo','Galilei','Pisa','Italy','78');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('5','Thomas','Edison','Milan','USA','84');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('6','Alexander','Bell','Edinburg','UK','75');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('7','Louis','Pasteur','Dole','France','73');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('8','Nicolaus','Copernicus','Toruri','Poland','70');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('9','James','Maxwell','Edinburg','UK','48');\r\nMariaDB [database1]&gt; insert into scientists\r\nvalues('10','Pierre','Curie','Paris','France','47');\r\n<\/pre>\n<p>9. Wy\u015bwietlenie tabeli <em>scientists<\/em>:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; select * from scientists;\r\n+------+-----------+------------+-------------+---------+------+\r\n| Sno | FirstName | LastName | City | Country | Age |\r\n+------+-----------+------------+-------------+---------+------+\r\n| 1 | Albert | Einstein | Ulm | Germany | 76 |\r\n| 2 | Isaac | Newton | Woolsthorpe | UK | 84 |\r\n| 3 | Marie | Curie | Warsaw | Poland | 67 |\r\n| 4 | Galileo | Galilei | Pisa | Italy | 78 |\r\n| 5 | Thomas | Edison | Milan | USA | 84 |\r\n| 6 | Alexander | Bell | Edinburg | UK | 75 |\r\n| 7 | Louis | Pasteur | Dole | France | 73 |\r\n| 8 | Nicolaus | Copernicus | Toruri | Poland | 70 |\r\n| 9 | James | Maxwell | Edinburg | UK | 48 |\r\n| 10 | Pierre | Curie | Paris | France | 47 |\r\n+------+-----------+------------+-------------+---------+------+\r\n10 rows in set (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Tworzenie u\u017cytkownik\u00f3w bazy i nadawanie im r\u00f3znych uprawnie\u0144.<\/span><\/p>\n<p>1. Zalogowanie do pow\u0142oki <em>mysql<\/em>.<\/p>\n<pre class=\"lang:sh decode:true \"># mysql -u root -p<\/pre>\n<p>2. Zmiana bazy i wy\u015bwietlenie pomocy zwi\u0105zanej z dodawaniem u\u017cytkownika:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [(none)]&gt; use database1;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n\r\nMariaDB [database1]&gt; ? create user;\r\n...\r\nCREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';\r\n...<\/pre>\n<p>3. Utworzenie u\u017cytkownika <em>user1 <\/em> has\u0142em <em>password1<\/em>, kt\u00f3ry mo\u017ce \u0142\u0105czy\u0107 si\u0119 tylko lokalnie z baz\u0105:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; create user 'user1'@'localhost' identified by 'password1';\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<p>4. Utworzenie u\u017cytkownika <em>user2<\/em> has\u0142em <em>password2<\/em>, kt\u00f3ry mo\u017ce \u0142\u0105czy\u0107 si\u0119 ze zdalnego hosta z baz\u0105:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; create user 'user2'@'%' identified by 'password2';\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<p>5. Wy\u015bwietlenie pomocy mysql zwi\u0105zanej z nadawaniem uprawnie\u0144:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [database1]&gt; ? grant;\r\n\r\n....\r\nCREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';\r\nGRANT ALL ON db1.* TO 'jeffrey'@'localhost';\r\nGRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';\r\nGRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;\r\n....<\/pre>\n<p>6. Nadanie u\u017cytkownikowi <em>user1<\/em> wszystkich uprawnie\u0144 do bazy:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; GRANT ALL ON scientists.* TO 'user1'@'localhost';\r\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n<p>7. Nadanie u\u017cytkownikowi <em>user2<\/em> uprawnie\u0144 tylko do odczytu do bazy:<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; GRANT select ON scientists.* TO 'user2'@'%';\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<p>8. Prze\u0142adowanie uprawnie\u0144.<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; flush privileges;\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Backup i przywracanie bazy lub tabeli.<\/span><\/p>\n<p>Backup to duplikowanie danych do innej lokalizacji na wypadek utraty danych. S\u0105 dwa rodzaje backupu: <em>fizyczny<\/em> i <em>logiczny<\/em>. Backup<em> fizyczny<\/em> to kopiowanie aktualnych plik\u00f3w, kt\u00f3re mog\u0105 nale\u017ce\u0107 do systemu operacyjnego, bazy danych lub innej aplikacji. Backup <em>logiczny<\/em> zawiera tylko komendy SQL niezb\u0119dne do odtworzenia danych.<\/p>\n<p>Przywracanie danych to czynno\u015b\u0107 odwrotna do backupu.<\/p>\n<p>Backup wszystkich baz w systemie:<\/p>\n<pre class=\"lang:sh decode:true\"># mysqldump \u2013u root \u2013p --all-databases &gt; db_bkp_all.mysql<\/pre>\n<p>Przywr\u00f3cenie okre\u015blonej bazy np. DB1:<\/p>\n<pre class=\"lang:sh decode:true\"># mysql \u2013u root \u2013p DB1 &lt; db_bkp_all.mysql<\/pre>\n<p>Backup wybranych baz np. DB1 DB2 DB3:<\/p>\n<pre class=\"lang:sh decode:true\"># mysqldump \u2013u root \u2013p --databases DB1 DB2 DB3 &gt; db_bkp_db123.mysql<\/pre>\n<p>Przywr\u00f3cenie trzech baz z przyk\u0142adu powy\u017cej:<\/p>\n<pre class=\"lang:sh decode:true\"># mysql \u2013u root \u2013p DB1 DB2 DB3 &lt; db_bkp_db123.mysql<\/pre>\n<p>Backup okre\u015blonych tabel takich jak np. tb1 i tb2 w bazie DB1:<\/p>\n<pre class=\"lang:sh decode:true\"># mysqldump \u2013u root \u2013p DB1 tbl1 tbl2 &gt; tbl_bkp_tbl12.mysql<\/pre>\n<p>Aby przywr\u00f3ci\u0107 tylko tabel\u0119 tb1 z przyk\u0142adu powy\u017cej:<\/p>\n<pre class=\"lang:sh decode:true\"># mysql \u2013u root \u2013p DB1 tbl1 &lt; tbl_bkp_tbl12.mysql;<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #3366ff;\">Backup, usuni\u0119cie bazy lub tabeli i odtworzenie bazy.<\/span><\/p>\n<p>1. Backup bazy.<\/p>\n<pre class=\"lang:sh decode:true \"># mysqldump \u2013u root \u2013p database1 &gt; \/tmp\/database1.mysql\r\nEnter password:<\/pre>\n<p>2. Wykasowanie bazy <em>database1<\/em>.<\/p>\n<pre class=\"lang:sh decode:true\"># mysql \u2013u root \u2013p\r\n\u2026\u2026 . .\r\nMariaDB [(none)]&gt; drop database database1;\r\nQuery OK, 1 row affected (0.05 sec)<\/pre>\n<p>3. Potwierdzenie:<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [(none)]&gt; show databases;\r\n+--------------------+\r\n| Database |\r\n+--------------------+\r\n| information_schema |\r\n| mysql |\r\n| performance_schema |\r\n+--------------------+\r\n3 rows in set (0.00 sec)<\/pre>\n<p>4. Ponowne utworzenie bazy <em>database1<\/em>.<\/p>\n<pre class=\"lang:sh decode:true\">MariaDB [(none)]&gt; create database daatabase1;\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nMariaDB [(none)]&gt; show databases;\r\n+--------------------+\r\n| Database |\r\n+--------------------+\r\n| information_schema |\r\n| database1 |\r\n| mysql |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.00 sec)<\/pre>\n<p>5. Odtworzenie bazy.<\/p>\n<pre class=\"lang:sh decode:true \"># mysql -u root -p database1 &lt; \/root\/database.mysql\r\nEnter password:<\/pre>\n<p>6.\u00a0 Ponowne zalogowanie i sprawdzenie obecno\u015bci tabeli scientist.<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [(none)]&gt; use database1;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n\r\nMariaDB [database1]&gt; show tables;\r\n+---------------------+\r\n| Tables_in_database1 |\r\n+---------------------+\r\n| scientists |\r\n+---------------------+\r\n1 row in set (0.00 sec)\r\n\r\n\r\nMariaDB [database1]&gt; select * from scientists;\r\n+------+-----------+------------+-------------+---------+------+\r\n| Sno | FirstName | LastName | City | Country | Age |\r\n+------+-----------+------------+-------------+---------+------+\r\n| 1 | Albert | Einstein | Ulm | Germany | 76 |\r\n| 2 | Isaac | Newton | Woolsthorpe | UK | 84 |\r\n| 3 | Marie | Curie | Warsaw | Poland | 67 |\r\n| 4 | Galileo | Galilei | Pisa | Italy | 78 |\r\n| 5 | Thomas | Edison | Milan | USA | 84 |\r\n| 6 | Alexander | Bell | Edinburg | UK | 75 |\r\n| 7 | Louis | Pasteur | Dole | France | 73 |\r\n| 8 | Nicolaus | Copernicus | Toruri | Poland | 70 |\r\n| 9 | James | Maxwell | Edinburg | UK | 48 |\r\n| 10 | Pierre | Curie | Paris | France | 47 |\r\n+------+-----------+------------+-------------+---------+------+\r\n10 rows in set (0.00 sec)<\/pre>\n<p>7. Wykasowanie tabeli scientists a p\u00f3\u017cniej bazy database1 cho\u0107 mo\u017ana od razu skasowa\u0107 baz\u0119 i poskutkuje to skasowanem tabeli.<\/p>\n<pre class=\"lang:sh decode:true \">MariaDB [database1]&gt; drop table scientists;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nMariaDB [database1]&gt; drop database database1;\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><!--EndFragment--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB to stosunkowo nowe rozwi\u0105zanie w\u015br\u00f3d system\u00f3w zarz\u0105dzania bazami danych (DBMS &#8211; Data Base Management System). To ulepszona wersja dla s\u0142ynnego MySQLa, kt\u00f3ry zosta\u0142 kupiony przez Sun Microsystems (teraz Oracle) w 2008 r.\u00a0 Z powodu polityki Oracla\u00a0 spo\u0142ecze\u0144stwo opensource mia\u0142o mniejszy wp\u0142yw na DBMS i jego rozw\u00f3j znacznie zwolni\u0142. Sk\u0142oni\u0142o to developer\u00f3w MySQLa do utworzenia &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/miro.borodziuk.eu\/index.php\/2017\/07\/30\/system-zarzadzania-baza-danych-mariadb\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;System zarz\u0105dzania baz\u0105 danych MariaDB&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[],"_links":{"self":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/1662"}],"collection":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/comments?post=1662"}],"version-history":[{"count":15,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/1662\/revisions"}],"predecessor-version":[{"id":1702,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/1662\/revisions\/1702"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media\/1663"}],"wp:attachment":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media?parent=1662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/categories?post=1662"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/tags?post=1662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}