{"id":16342,"date":"2023-05-04T08:52:22","date_gmt":"2023-05-04T05:52:22","guid":{"rendered":"https:\/\/kifarunix.com\/?p=16342"},"modified":"2024-05-12T19:37:53","modified_gmt":"2024-05-12T16:37:53","slug":"install-mariadb-11-on-ubuntu","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-mariadb-11-on-ubuntu\/","title":{"rendered":"Install MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04"},"content":{"rendered":"\n<p>Follow through this guide to learn how to install MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04. \u201c<em><a href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-11-0\/\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB 11<\/a>\u00a0is the new major release series of MariaDB. It ships with several entirely\u00a0<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>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1060\" height=\"589\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-ubuntu.png\" alt=\"Install MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-16363\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-ubuntu.png?v=1683179454 1060w, https:\/\/kifarunix.com\/wp-content\/uploads\/2023\/05\/install-mariadb-11-on-ubuntu-768x427.png?v=1683179454 768w\" sizes=\"(max-width: 1060px) 100vw, 1060px\" \/><\/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-ubuntu-22-04-ubuntu-20-04\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/a><ul><li><a href=\"#run-system-update\">Run System Update<\/a><\/li><li><a href=\"#installing-maria-db-11-on-ubuntu-22-04-ubuntu-20-04-1\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/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-ubuntu-22-04-ubuntu-20-04-2\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04;<\/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-ubuntu-22-04-ubuntu-20-04\">Running MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/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-ubuntu-22-04-ubuntu-20-04\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/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 Ubuntu system, update and upgrade your system packages.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo su -<\/code><\/pre>\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-ubuntu-22-04-ubuntu-20-04-1\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/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 Ubuntu 20.04\/Ubuntu 22.04 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.6.12-0ubuntu0.22.04.1\nPriority: optional\nSection: universe\/database\nSource: mariadb-10.6\nOrigin: Ubuntu\nMaintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>\nOriginal-Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>\nBugs: https:\/\/bugs.launchpad.net\/ubuntu\/+filebug\nInstalled-Size: 69.6 kB\nDepends: mariadb-server-10.6 (>= 1:10.6.12-0ubuntu0.22.04.1)\nHomepage: https:\/\/mariadb.org\/\nDownload-Size: 11.8 kB\nAPT-Sources: http:\/\/ke.archive.ubuntu.com\/ubuntu jammy-updates\/universe amd64 Packages\n<\/code><\/pre>\n\n\n\n<p>Default version of MariaDB on Ubuntu 20.04 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 Ubuntu 22.04\/Ubuntu 20.04<\/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-ubuntu-22-04-ubuntu-20-04-2\">Installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04;<\/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  EditLine wrapper<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"running-maria-db-11-on-ubuntu-22-04-ubuntu-20-04\">Running MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04<\/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 Thu 2023-05-04 05:31:30 UTC; 1s ago\n       Docs: man:mariadbd(8)\n             https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\n    Process: 12654 ExecStartPre=\/usr\/bin\/install -m 755 -o mysql -g root -d \/var\/run\/mysqld (code=exited, status=0\/SUCCESS)\n    Process: 12664 ExecStartPre=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 12666 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: 12715 ExecStartPost=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 12717 ExecStartPost=\/etc\/mysql\/debian-start (code=exited, status=0\/SUCCESS)\n   Main PID: 12701 (mariadbd)\n     Status: \"Taking your SQL requests now...\"\n      Tasks: 15 (limit: 2281)\n     Memory: 79.1M\n     CGroup: \/system.slice\/mariadb.service\n             \u2514\u250012701 \/usr\/sbin\/mariadbd\n\nMay 04 05:31:29 ubuntu20 mariadbd[12701]: 2023-05-04  5:31:29 0 [Note] Plugin 'wsrep-provider' is disabled.\nMay 04 05:31:29 ubuntu20 mariadbd[12701]: 2023-05-04  5:31:29 0 [Note] InnoDB: Loading buffer pool(s) from \/var\/lib\/mysql\/ib_buffer_pool\nMay 04 05:31:29 ubuntu20 mariadbd[12701]: 2023-05-04  5:31:29 0 [Note] Server socket created on IP: '127.0.0.1'.\nMay 04 05:31:30 ubuntu20 mariadbd[12701]: 2023-05-04  5:31:30 0 [Note] InnoDB: Buffer pool(s) load completed at 230504  5:31:30\nMay 04 05:31:30 ubuntu20 mariadbd[12701]: 2023-05-04  5:31:30 0 [Note] \/usr\/sbin\/mariadbd: ready for connections.\nMay 04 05:31:30 ubuntu20 mariadbd[12701]: Version: '11.0.1-MariaDB-1:11.0.1+maria~ubu2004'  socket: '\/run\/mysqld\/mysqld.sock'  port: 3306  mariadb.org binary distribution\nMay 04 05:31:30 ubuntu20 systemd[1]: Started MariaDB 11.0.1 database server.\nMay 04 05:31:30 ubuntu20 \/etc\/mysql\/debian-start[12719]: Upgrading MySQL tables if necessary.\nMay 04 05:31:30 ubuntu20 \/etc\/mysql\/debian-start[12730]: Checking for insecure root accounts.\nMay 04 05:31:30 ubuntu20 \/etc\/mysql\/debian-start[12734]: 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>To restart;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><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>Enable the service from running on system boot;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl enable 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<pre class=\"scroll-box\"><code>\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\n\nIn order to log into MariaDB to secure it, we'll need the current\npassword for the root user. If you've just installed MariaDB, and\nhaven't set the root password yet, you should just press enter here.\n\nEnter current password for root (enter for none): \nOK, successfully used password, moving on...\n\nSetting the root password or using the unix_socket ensures that nobody\ncan log into the MariaDB root user without the proper authorisation.\n\nYou already have your root account protected, so you can safely answer 'n'.\n\nSwitch to unix_socket authentication [Y\/n]  \nEnabled successfully!\nReloading privilege tables..\n ... Success!\n\n\nYou already have your root account protected, so you can safely answer 'n'.\n\nChange the root password? [Y\/n] y\nNew password: \nRe-enter new password: \nPassword updated successfully!\nReloading privilege tables..\n ... Success!\n\n\nBy default, a MariaDB installation has an anonymous user, allowing anyone\nto log into MariaDB without having to have a user account created for\nthem.  This is intended only for testing, and to make the installation\ngo a bit smoother.  You should remove them before moving into a\nproduction environment.\n\nRemove anonymous users? [Y\/n] y\n ... Success!\n\nNormally, root should only be allowed to connect from 'localhost'.  This\nensures that someone cannot guess at the root password from the network.\n\nDisallow root login remotely? [Y\/n] y\n ... Success!\n\nBy default, MariaDB comes with a database named 'test' that anyone can\naccess.  This is also intended only for testing, and should be removed\nbefore moving into a production environment.\n\nRemove test database and access to it? [Y\/n] y\n - Dropping test database...\n ... Success!\n - Removing privileges on test database...\n ... Success!\n\nReloading the privilege tables will ensure that all changes made so far\nwill take effect immediately.\n\nReload privilege tables now? [Y\/n] y\n ... Success!\n\nCleaning up...\n\nAll done!  If you've completed all of the above steps, your MariaDB\ninstallation should now be secure.\n\nThanks for using MariaDB!\n<\/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 installing MariaDB 11 on Ubuntu 22.04\/Ubuntu 20.04.<\/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 Ubuntu 22.04\/Ubuntu 20.04. \u201cMariaDB 11\u00a0is the new major release series of MariaDB. It<\/p>\n","protected":false},"author":10,"featured_media":16363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[121,299,928],"tags":[6595,6597,6596,6594],"class_list":["post-16342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","category-database","category-mariadb","tag-install-mariadb-11-on-ubuntu","tag-install-mariadb-11-on-ubuntu-20-04","tag-install-mariadb-11-on-ubuntu-22-04","tag-install-mariadb-on-ubuntu","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\/16342"}],"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=16342"}],"version-history":[{"count":8,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/16342\/revisions"}],"predecessor-version":[{"id":22526,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/16342\/revisions\/22526"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/16363"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=16342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=16342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=16342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}