{"id":16346,"date":"2023-05-03T10:21:59","date_gmt":"2023-05-03T07:21:59","guid":{"rendered":"https:\/\/kifarunix.com\/?p=16346"},"modified":"2024-03-10T09:21:18","modified_gmt":"2024-03-10T06:21:18","slug":"install-mariadb-11-on-debian","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-mariadb-11-on-debian\/","title":{"rendered":"Install MariaDB 11 on Debian 11\/Debian 10"},"content":{"rendered":"\n<p>Follow through this guide to learn how to install MariaDB 11 on Debian 11\/Debian 10. \u201c<em><a href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-11-0\/\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB 11<\/a>&nbsp;is the new major release series of MariaDB. It ships with several entirely&nbsp;<a href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-11-0\/\" target=\"_blank\" rel=\"noreferrer noopener\">new features and improvements<\/a>&#8220;<\/em>. However, it is good to note that as of this writing, MariaDB 11 is in active development, and preview releases are available for testing purposes. Therefore, &#8220;<em><strong>Do not use non-stable (non-GA) releases in production!&#8221;<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1062\" height=\"589\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-debian.png\" alt=\"Install MariaDB 11 on Debian\" class=\"wp-image-16350\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-debian.png?v=1683098364 1062w, https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-debian-768x426.png?v=1683098364 768w\" sizes=\"(max-width: 1062px) 100vw, 1062px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#installing-maria-db-11-on-debian-11-debian-10\">Installing MariaDB 11 on Debian 11\/Debian 10<\/a><ul><li><a href=\"#run-system-update\">Run System Update<\/a><\/li><li><a href=\"#installing-maria-db-11-on-debian-11-debian-10-1\">Installing MariaDB 11 on Debian 11\/Debian 10<\/a><ul><li><a href=\"#install-maria-db-11-from-apt-repository\">Install MariaDB 11 from APT Repository<\/a><\/li><li><a href=\"#installing-maria-db-11-on-debian-11-debian-10-2\">Installing MariaDB 11 on Debian 11\/Debian 10;<\/a><\/li><li><a href=\"#verify-the-maria-db-installed-version\">Verify the MariaDB installed version<\/a><\/li><li><a href=\"#running-maria-db-11-on-debian-11-debian-10\">Running MariaDB 11 on Debian 11\/Debian 10<\/a><\/li><\/ul><\/li><li><a href=\"#securing-maria-db-11\">Securing MariaDB 11<\/a><\/li><li><a href=\"#maria-db-authentication\">MariaDB Authentication<\/a><\/li><li><a href=\"#enable-maria-db-password-authentication\">Enable MariaDB password Authentication<\/a><ul><li><a href=\"#set-native-password-authentication-method-as-default\">Set Native Password Authentication Method as Default<\/a><\/li><\/ul><\/li><li><a href=\"#other-tutorials\">Other Tutorials<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"installing-maria-db-11-on-debian-11-debian-10\">Installing MariaDB 11 on Debian 11\/Debian 10<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"run-system-update\">Run System Update<\/h3>\n\n\n\n<p>Assuming that you are installing MariaDB 11 on a newly installed Debian 11, update and upgrade your system packages.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>apt update<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>apt upgrade<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"installing-maria-db-11-on-debian-11-debian-10-1\">Installing MariaDB 11 on Debian 11\/Debian 10<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"install-maria-db-11-from-apt-repository\">Install MariaDB 11 from APT Repository<\/h4>\n\n\n\n<p>One of the easiest ways to install MariaDB is via the use of their MariaDB package repositories.<\/p>\n\n\n\n<p>As of this writing, the default repos for Debian 10\/Debian 11 does not provide MariaDB 11 packages.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>apt show mariadb-server<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\nPackage: mariadb-server\nVersion: 1:10.5.19-0+deb11u2\nPriority: optional\nSection: database\nSource: mariadb-10.5\nMaintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>\nInstalled-Size: 73.7 kB\nDepends: mariadb-server-10.5 (>= 1:10.5.19-0+deb11u2)\nHomepage: https:\/\/mariadb.org\/\nTag: devel::lang:c++, devel::lang:sql, devel::library, implemented-in::c++,\n interface::commandline, interface::daemon, network::server,\n protocol::db:mysql, role::devel-lib, role::metapackage, role::program,\n works-with::db\nDownload-Size: 35.5 kB\nAPT-Sources: http:\/\/deb.debian.org\/debian bullseye\/main amd64 Packages\n<\/code><\/pre>\n\n\n\n<p>Default version of MariaDB on Debian 10 is MariaDB 10.3.<\/p>\n\n\n\n<p>Therefore, to install MariaDB 11;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Install MariaDB APT repository on Debian 11\/Debian 10<\/li>\n<\/ul>\n\n\n\n<p>Execute the commands below to install MariaDB 11 APT repos;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>apt install software-properties-common dirmngr curl ca-certificates apt-transport-https<\/code><\/pre>\n\n\n\n<p>To Install MariaDB 11 APT repository, we will use the <a href=\"https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB package repository setup script<\/a>.<\/p>\n\n\n\n<p>The script allows you to choose the version of MariaDB you want to set the APT repositories for.<\/p>\n\n\n\n<p>For example, to install APT repository for MariaDB 11, then execute the command below;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>curl -LsS https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup | \\\nsudo bash -s -- --mariadb-server-version=\"mariadb-11.0\"<\/code><\/pre>\n\n\n\n<p>Sample script output;<\/p>\n\n\n\n<pre class=\"scroll-box\"><code>\n# [info] Checking for script prerequisites.\n# [info] MariaDB Server version 11.0 is valid\n# [info] Repository file successfully written to \/etc\/apt\/sources.list.d\/mariadb.list\n# [info] Adding trusted package signing keys...\n# [info] Running apt-get update...\n# [info] Done adding trusted package signing keys\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"installing-maria-db-11-on-debian-11-debian-10-2\">Installing MariaDB 11 on Debian 11\/Debian 10;<\/h4>\n\n\n\n<p>You should now be able to install MariaDB 11 by running the command below;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>apt install mariadb-server<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"verify-the-maria-db-installed-version\">Verify the MariaDB installed version<\/h4>\n\n\n\n<p>MariaDB 11 deprecates the use of <strong><code>mysql<\/code><\/strong> command line tool and replaces it with <code>mariadb<\/code>.<\/p>\n\n\n\n<p>As much as you can still be able to use mysql command, you will get some deprecation warnings.<\/p>\n\n\n\n<p>To check the version of installed MariaDB, run the command below;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb -V<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb from 11.0.1-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using readline EditLine wrapper<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"running-maria-db-11-on-debian-11-debian-10\">Running MariaDB 11 on Debian 11\/Debian 10<\/h4>\n\n\n\n<p>Upon installation, MariaDB is started and enabled to run on system boot;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl status mariadb<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n\u25cf mariadb.service - MariaDB 11.0.1 database server\n     Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\n    Drop-In: \/etc\/systemd\/system\/mariadb.service.d\n             \u2514\u2500migrated-from-my.cnf-settings.conf\n     Active: active (running) since Wed 2023-05-03 09:11:48 EAT; 9min ago\n       Docs: man:mariadbd(8)\n             https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\n    Process: 13468 ExecStartPre=\/usr\/bin\/install -m 755 -o mysql -g root -d \/var\/run\/mysqld (code=exited, status=0\/SUCCESS)\n    Process: 13469 ExecStartPre=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 13471 ExecStartPre=\/bin\/sh -c [ ! -e \/usr\/bin\/galera_recovery ] && VAR= ||   VAR=`cd \/usr\/bin\/..; \/usr\/bin\/galera_recovery`; [ $? -eq 0 ]   && systemctl set-e>\n    Process: 13516 ExecStartPost=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 13518 ExecStartPost=\/etc\/mysql\/debian-start (code=exited, status=0\/SUCCESS)\n   Main PID: 13500 (mariadbd)\n     Status: \"Taking your SQL requests now...\"\n      Tasks: 8 (limit: 2341)\n     Memory: 205.6M\n        CPU: 502ms\n     CGroup: \/system.slice\/mariadb.service\n             \u2514\u250013500 \/usr\/sbin\/mariadbd\n\nMay 03 09:11:47 debian11 mariadbd[13500]: 2023-05-03  9:11:47 0 [Note] Plugin 'wsrep-provider' is disabled.\nMay 03 09:11:47 debian11 mariadbd[13500]: 2023-05-03  9:11:47 0 [Note] InnoDB: Loading buffer pool(s) from \/var\/lib\/mysql\/ib_buffer_pool\nMay 03 09:11:48 debian11 mariadbd[13500]: 2023-05-03  9:11:48 0 [Note] Server socket created on IP: '127.0.0.1'.\nMay 03 09:11:48 debian11 mariadbd[13500]: 2023-05-03  9:11:48 0 [Note] InnoDB: Buffer pool(s) load completed at 230503  9:11:48\nMay 03 09:11:48 debian11 mariadbd[13500]: 2023-05-03  9:11:48 0 [Note] \/usr\/sbin\/mariadbd: ready for connections.\nMay 03 09:11:48 debian11 mariadbd[13500]: Version: '11.0.1-MariaDB-1:11.0.1+maria~deb11'  socket: '\/run\/mysqld\/mysqld.sock'  port: 3306  mariadb.org binary distribution\nMay 03 09:11:48 debian11 systemd[1]: Started MariaDB 11.0.1 database server.\nMay 03 09:11:48 debian11 \/etc\/mysql\/debian-start[13520]: Upgrading MySQL tables if necessary.\nMay 03 09:11:48 debian11 \/etc\/mysql\/debian-start[13531]: Checking for insecure root accounts.\nMay 03 09:11:48 debian11 \/etc\/mysql\/debian-start[13535]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables\n<\/code><\/pre>\n\n\n\n<p>You can manage the service via systemctl command.<\/p>\n\n\n\n<p>For example, to start MariaDB service;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>For example, to restart MariaDB service;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl restart mariadb<\/code><\/pre>\n\n\n\n<p>To stop the service;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl stop mariadb<\/code><\/pre>\n\n\n\n<p>Disable the service from running on system boot;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl disable mariadb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"securing-maria-db-11\">Securing MariaDB 11<\/h3>\n\n\n\n<p>MariaDB comes with a default security script,&nbsp;<strong><code>mariadb-secure-installation<\/code><\/strong> that is used to improve the security of MariaDB installation by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Setting the password for root accounts (if need be).<\/li>\n\n\n\n<li>Disabling remote root login to the databases.<\/li>\n\n\n\n<li>Removing anonymous-user accounts.<\/li>\n\n\n\n<li>Removing the test database, which by default can be accessed by anonymous users.<\/li>\n<\/ul>\n\n\n\n<p>Simply run the command below to launch the script.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb-secure-installation<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"maria-db-authentication\">MariaDB Authentication<\/h3>\n\n\n\n<p>The new installations of MariaDB have two secure accounts are created during the installation.<\/p>\n\n\n\n<p>The accounts are&nbsp;<strong><code>root@localhost<\/code><\/strong>&nbsp;and&nbsp;<code><strong>mysql@localhost<\/strong><\/code>.<\/p>\n\n\n\n<p>Both accounts uses either of the&nbsp;<strong><code>unix_socket<\/code><\/strong>&nbsp;and the&nbsp;<strong><code>mysql_native_password<\/code><\/strong>&nbsp;authentication plugins.<\/p>\n\n\n\n<p><code><strong>unix_socket<\/strong><\/code>&nbsp;authentication plugin allows a system&nbsp;<code>root<\/code>&nbsp;user or a&nbsp;<code><strong>user with sudo rights<\/strong><\/code>&nbsp;to login as&nbsp;<code><strong>root@locahost<\/strong><\/code>&nbsp;to MariaDB database without a password.<\/p>\n\n\n\n<p>With&nbsp;<code><strong>unix_socket<\/strong><\/code>&nbsp;authentication plugin, while being a root user, you can simply login by running either of the commands below;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb<\/code><\/pre>\n\n\n\n<p>or<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb -u root<\/code><\/pre>\n\n\n\n<p>Even if you run,&nbsp;<code><strong>mariadb -u root -p<\/strong><\/code>, and press ENTER for blank password, you will still login.<\/p>\n\n\n\n<p>As a user with sudo rights, prefix the commands above with&nbsp;<code><strong>sudo<\/strong><\/code>.<\/p>\n\n\n\n<p>For example, you can login as mysql user;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo -u mysql mariadb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"enable-maria-db-password-authentication\">Enable MariaDB password Authentication<\/h3>\n\n\n\n<p>With the two privileged accounts, <strong><code>root@localhost<\/code><\/strong> and <strong><code>mysql@localhost<\/code><\/strong>, anyone with access to it can login to MariaDB.<\/p>\n\n\n\n<p>It is not recommended to leave such user accounts with no password and all privileges, as this can pose a significant security risk to your database.<\/p>\n\n\n\n<p>The two accounts above uses <code>mysql_native_password<\/code> plugin by default;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mariadb<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>select User,Host,plugin from mysql.user;<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n+-------------+-----------+-----------------------+\n| User        | Host      | plugin                |\n+-------------+-----------+-----------------------+\n<strong>| mariadb.sys | localhost | mysql_native_password |\n| root        | localhost | mysql_native_password |\n| mysql       | localhost | mysql_native_password |<\/strong>\n+-------------+-----------+-----------------------+\n3 rows in set (0.002 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<p>The&nbsp;<code>mysql_native_password<\/code>&nbsp;plugin is used as a failover for the&nbsp;<code>unix_socket<\/code>&nbsp;plugin. Even if you have setup a password using MariaDB secure installation script, you can still login as those accounts without a password.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show grants for root@localhost;<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| Grants for root@localhost                                                                                                                                                 |\n+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING '*9C6C35530EE4427B07D2FA4F9E119C3915D18940' OR unix_socket WITH GRANT OPTION |\n| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                                                             |\n+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n2 rows in set (0.000 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>show grants for mysql@localhost;<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n+------------------------------------------------------------------------------------------------------------------------------------------+\n| Grants for mysql@localhost                                                                                                               |\n+------------------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `mysql`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION |\n+------------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (0.000 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<p>As you can see above, we had already set the password for root user using the mysql_secure_installation command. But mysql user account has invalid password.<\/p>\n\n\n\n<p>Thus, enable password authentication.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>ALTER USER root@localhost identified by 'myStr0nP@ssW0rd';<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER mysql@localhost identified by 'myStr0nP@ssW0rd2';<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>flush privileges;\nquit<\/code><\/pre>\n\n\n\n<p>This re-enables the MariaDB password authentication and hence, you can now login as non root or non sudo user.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>mariadb<\/code><\/pre>\n\n\n\n<p>Or;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo -u mysql mariadb<\/code><\/pre>\n\n\n\n<p>Sample output;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<\/code><\/pre>\n\n\n\n<p>Provide a password to be able to login;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mariadb -u root -p<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\nEnter password: \nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 35\nServer version: 11.0.1-MariaDB-1:11.0.1+maria~deb10 mariadb.org binary distribution\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"set-native-password-authentication-method-as-default\">Set Native Password Authentication Method as Default<\/h4>\n\n\n\n<p>When you set the password above, it completely disables&nbsp;<code>unix_socke<\/code>t authentication plugin and instead use the&nbsp;<code>msqyl_native_password<\/code>&nbsp;authentication method;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>show grants for root@localhost;<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n+----------------------------------------------------------------------------------------------------------------------------------------+\n| Grants for root@localhost                                                                                                              |\n+----------------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED BY PASSWORD '*73E1DDB4DA8B34D3080B082A8DFC863A56285DD4' WITH GRANT OPTION |\n| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                          |\n+----------------------------------------------------------------------------------------------------------------------------------------+\n2 rows in set (0.000 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>show grants for mysql@localhost;<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\n+-----------------------------------------------------------------------------------------------------------------------------------------+\n| Grants for mysql@localhost                                                                                                              |\n+-----------------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `mysql`@`localhost` IDENTIFIED BY PASSWORD '*4C8C1832BBF14A360C2F70EA14CBD912AE0AF280' WITH GRANT OPTION |\n+-----------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (0.000 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\n\n\n\n<p>That marks the end of our guide on how to installing MariaDB 11 on Debian 11\/Debian 10.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"other-tutorials\">Other Tutorials<\/h3>\n\n\n\n<p>You can check our <a href=\"https:\/\/kifarunix.com\/?s=mariadb\" target=\"_blank\" rel=\"noreferrer noopener\">other MySQL\/MariaDB related tutorials<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Follow through this guide to learn how to install MariaDB 11 on Debian 11\/Debian 10. \u201cMariaDB 11&nbsp;is the new major release series of MariaDB. It<\/p>\n","protected":false},"author":10,"featured_media":16350,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[121,299,928],"tags":[6587,6586,6585,6584,6588],"class_list":["post-16346","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","category-database","category-mariadb","tag-debian-11-mariadb-10","tag-debian-11-mariadb-11","tag-install-mariadb-11-on-debian","tag-install-mariadb-11-on-linux","tag-mariadb-11-install","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/16346"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=16346"}],"version-history":[{"count":6,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/16346\/revisions"}],"predecessor-version":[{"id":20756,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/16346\/revisions\/20756"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/16350"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=16346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=16346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=16346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}