{"id":22527,"date":"2024-05-12T21:49:49","date_gmt":"2024-05-12T18:49:49","guid":{"rendered":"https:\/\/kifarunix.com\/?p=22527"},"modified":"2024-05-12T21:49:52","modified_gmt":"2024-05-12T18:49:52","slug":"how-to-install-mariadb-11-on-ubuntu-24-04","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/how-to-install-mariadb-11-on-ubuntu-24-04\/","title":{"rendered":"How to Install MariaDB 11 on Ubuntu 24.04"},"content":{"rendered":"\n<p>Follow through this guide to learn how to install MariaDB 11 on Ubuntu 24.04. \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>.<\/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 24.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-24-04\">Installing MariaDB 11 on Ubuntu 24.04<\/a><ul><li><a href=\"#run-system-update\">Run System Update<\/a><\/li><li><a href=\"#installing-maria-db-11-on-ubuntu-24-04-1\">Installing MariaDB 11 on Ubuntu 24.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-24-04-2\">Installing MariaDB 11 on Ubuntu 24.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-24-04\">Running MariaDB 11 on Ubuntu 24.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-24-04\">Installing MariaDB 11 on Ubuntu 24.04<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"run-system-update\">Run System Update<\/h3>\n\n\n\n<p>Update and upgrade your system package cache.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt update<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"installing-maria-db-11-on-ubuntu-24-04-1\">Installing MariaDB 11 on Ubuntu 24.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>Default Ubuntu 24.04 repos currently do not have MariaDB 11.x<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">apt show mariadb-server<\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>mariadb-server:\n  Installed: 1:10.11.7-2ubuntu2\n  Candidate: 1:10.11.7-2ubuntu2\n  Version table:\n *** 1:10.11.7-2ubuntu2 500\n        500 http:\/\/de.archive.ubuntu.com\/ubuntu noble\/universe amd64 Packages\n        100 \/var\/lib\/dpkg\/status\n<\/code><\/pre>\n\n\n\n<p>The version of MariaDB available on Ubuntu 24.04 default repositories is is MariaDB 10.11 as you can see in the command output above.<\/p>\n\n\n\n<p>Therefore, to install MariaDB 11, you need to MariaDB APT repository as follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt install software-properties-common dirmngr curl ca-certificates apt-transport-https<\/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> which allows  you to choose the version of MariaDB you want to set the APT repositories for.<\/p>\n\n\n\n<p>Unfortunately, MariaDB APT repositories similarly are not available for Ubuntu 24.04 Noble Numbat as of this writing. So if you really need to run the latest stable release version of MariaDB on Noble Numbat, you just have to use APT repos for Ubuntu 22.04 Jammy by executing the command below;<\/p>\n\n\n\n<pre class=\"scroll-box\"><code>curl -LsS https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup | \\\n\tsudo bash -s -- --mariadb-server-version=\"mariadb-11.3\" \\\n\t--os-type=\"ubuntu\" \\\n\t--os-version=\"jammy\"\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Normally, the script automatically detects the OS type and the version and checks if it is supported or not.<\/p>\n\n\n\n<p>For example, you would simply just execute it as follows;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>curl -LsS https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup | \\<br>sudo bash -s -- --mariadb-server-version=\"mariadb-11.3\"<\/code><\/pre>\n\n\n\n<p>To check more information on how to use the script, see the help page.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>curl -LsS https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup | bash -s -- --help<\/code><\/pre>\n<cite>MariaDB APT Repository Setup Script<\/cite><\/blockquote>\n\n\n\n<p>Sample script output;<\/p>\n\n\n\n<pre class=\"scroll-box\"><code># [info] Skipping OS detection and using OS type 'ubuntu' and version 'jammy' as given on the command line\n# [info] Checking for script prerequisites.\n# [info] MariaDB Server version 11.3 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-24-04-2\">Installing MariaDB 11 on Ubuntu 24.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\">sudo apt install mariadb-server<\/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\">mariadb -V<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mariadb from 11.3.2-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using  EditLine wrapper<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"running-maria-db-11-on-ubuntu-24-04\">Running MariaDB 11 on Ubuntu 24.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\">systemctl status mariadb<\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\u25cf mariadb.service - MariaDB 11.3.2 database server\n     Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled; preset: enabled)\n    Drop-In: \/etc\/systemd\/system\/mariadb.service.d\n             \u2514\u2500migrated-from-my.cnf-settings.conf\n     Active: active (running) since Sun 2024-05-12 18:18:13 UTC; 50s ago\n       Docs: man:mariadbd(8)\n             https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\n    Process: 27007 ExecStartPre=\/usr\/bin\/install -m 755 -o mysql -g root -d \/var\/run\/mysqld (code=exited, status=0\/SUCCESS)\n    Process: 27009 ExecStartPre=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 27011 ExecStartPre=\/bin\/sh -c [ ! -e \/usr\/bin\/galera_recovery ] && VAR= ||   VAR=`cd \/usr\/bin\/..; \/usr\/bin\/galera_recovery`; [ $? -eq 0 ]   && systemct>\n    Process: 27085 ExecStartPost=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\n    Process: 27087 ExecStartPost=\/etc\/mysql\/debian-start (code=exited, status=0\/SUCCESS)\n   Main PID: 27071 (mariadbd)\n     Status: \"Taking your SQL requests now...\"\n      Tasks: 14 (limit: 30453)\n     Memory: 102.3M (peak: 107.2M)\n        CPU: 1.457s\n     CGroup: \/system.slice\/mariadb.service\n             \u2514\u250027071 \/usr\/sbin\/mariadbd\n\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] InnoDB: log sequence number 46980; transaction id 14\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] InnoDB: Loading buffer pool(s) from \/var\/lib\/mysql\/ib_buffer_pool\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] Plugin 'FEEDBACK' is disabled.\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] Plugin 'wsrep-provider' is disabled.\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] InnoDB: Buffer pool(s) load completed at 240512 18:18:13\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] Server socket created on IP: '127.0.0.1'.\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] mariadbd: Event Scheduler: Loaded 0 events\nMay 12 18:18:13 noble mariadbd[27071]: 2024-05-12 18:18:13 0 [Note] \/usr\/sbin\/mariadbd: ready for connections.\nMay 12 18:18:13 noble mariadbd[27071]: Version: '11.3.2-MariaDB-1:11.3.2+maria~ubu2204'  socket: '\/run\/mysqld\/mysqld.sock'  port: 3306  mariadb.org binary distribut>\nMay 12 18:18:13 noble systemd[1]: Started mariadb.service - MariaDB 11.3.2 database server.\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\">sudo systemctl start mariadb<\/pre>\n\n\n\n<p>To restart;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<p>To stop the service;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl stop mariadb<\/pre>\n\n\n\n<p>Enable the service from running on system boot;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl enable mariadb<\/pre>\n\n\n\n<p>Disable the service from running on system boot;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl disable mariadb<\/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\">sudo mariadb-secure-installation<\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>NOTE: 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] \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] \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] \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] \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] \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\">mariadb<\/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>If you are a non-root user with sudo account;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mariadb<\/code><\/pre>\n\n\n\n<p>Or;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mariadb -u root<\/code><\/pre>\n\n\n\n<p>Even if you run,\u00a0<code><strong>mariadb -u root -p<\/strong><\/code>, and press ENTER for blank password, you will still login.<\/p>\n\n\n\n<p>You can also login as <strong>mysql<\/strong> 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>sudo 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><pre class=\"scroll-box\"><code>MariaDB [(none)]> select User,Host,plugin from mysql.user;\n<strong>+-------------+-----------+-----------------------+\n| User        | Host      | plugin                |\n+-------------+-----------+-----------------------+\n| mariadb.sys | localhost | mysql_native_password |\n| root        | localhost | mysql_native_password |\n| mysql       | localhost | mysql_native_password |\n| dvwa        | localhost | mysql_native_password |\n+-------------+-----------+-----------------------+<\/strong>\n4 rows in set (0.001 sec)\n\nMariaDB [(none)]>\n<\/code><\/pre>\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| 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<\/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| 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| GRANT PROXY ON ''@'%' TO 'mysql'@'localhost' WITH GRANT OPTION                                                                           |\n+------------------------------------------------------------------------------------------------------------------------------------------+\n2 rows in set (0.000 sec)\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\">ALTER USER root@localhost identified by 'myStr0nP@ssW0rd';<\/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\">sudo mariadb<\/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>Or;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo -u mysql mariadb<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1045 (28000): Access denied for user 'mysql'@'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>Enter password: \nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 61\nServer version: 11.3.2-MariaDB-1:11.3.2+maria~ubu2204 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\">show grants for root@localhost;<\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>+----------------------------------------------------------------------------------------------------------------------------------------+\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.001 sec)\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">show grants for mysql@localhost;<\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>+-----------------------------------------------------------------------------------------------------------------------------------------+\n| Grants for mysql@localhost                                                                                                              |\n+-----------------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `mysql`@`localhost` IDENTIFIED BY PASSWORD '*4C8C1832BBF14A360C2F70EA14CBD912AE0AF280' WITH GRANT OPTION |\n| GRANT PROXY ON ''@'%' TO 'mysql'@'localhost' WITH GRANT OPTION                                                                          |\n+-----------------------------------------------------------------------------------------------------------------------------------------+\n2 rows in set (0.001 sec)\n<\/code><\/pre>\n\n\n\n<p>That marks the end of our guide on installing MariaDB 11 on Ubuntu 24.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 24.04. \u201cMariaDB 11&nbsp;is the new major release series of MariaDB. It ships<\/p>\n","protected":false},"author":10,"featured_media":9145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[121,299,928],"tags":[3981,7488,7396],"class_list":["post-22527","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","category-database","category-mariadb","tag-mariadb-11","tag-mariadb-apt-repositories","tag-ubuntu-24-04","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\/22527"}],"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=22527"}],"version-history":[{"count":2,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/22527\/revisions"}],"predecessor-version":[{"id":22529,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/22527\/revisions\/22529"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/9145"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=22527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=22527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=22527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}