{"id":2826,"date":"2019-05-03T23:06:42","date_gmt":"2019-05-03T20:06:42","guid":{"rendered":"https:\/\/kifarunix.com\/?p=2826"},"modified":"2019-05-04T07:55:28","modified_gmt":"2019-05-04T04:55:28","slug":"install-mariadb-10-3-on-fedora-30","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-mariadb-10-3-on-fedora-30\/","title":{"rendered":"Install MariaDB 10.3 on Fedora 30"},"content":{"rendered":"\n

Welcome to our guide on how to install MariaDB 10.3 on Fedora 30. MariaDB<\/a> is an open-source relational database which comes as an enhanced drop-in replacement for the famous MySQL. It is fast, robust and scalable with a rich ecosystem of storage engines, plugins etc making it very versatile for most use cases.<\/p>\n\n\n\n

Install MariaDB 10.3 on Fedora 30<\/h2>\n\n\n\n

MariaDB 10.3 is the current stable release with MariaDb 10.4 being the latest release development version. Fedora 30 repos contains this current stable version of MariaDB and thus, you can simply install it via the DNF package manager.<\/p>\n\n\n\n

dnf install mariadb mariadb-server<\/code><\/pre>\n\n\n\n
Dependencies resolved.\n=======================================================================================================================================================\n Package                                            Architecture              Version                                 Repository                  Size\n=======================================================================================================================================================\nInstalling:\n mariadb                                            x86_64                    3:10.3.12-10.fc30                       fedora                     6.0 M\n mariadb-server                                     x86_64                    3:10.3.12-10.fc30                       fedora                      17 M\n...<\/code><\/pre>\n\n\n\n
Running MariaDB on Fedora 30<\/h2>\n\n\n\n
Once the installation is done, you can run by executing the command below;<\/p>\n\n\n\n
systemctl start mariadb<\/code><\/pre>\n\n\n\n
To configure MariaDB to run on system boot;<\/p>\n\n\n\n
systemctl enable mariadb<\/code><\/pre>\n\n\n\n
Initial MariaDB security<\/h2>\n\n\n\n
The install of MariaDB comes with a security script called mysql_secure_installation<\/strong>. This script is used to perform initial MariaDB security including setting up root password, remove default test databases, disabling root remote login, removing anonymous database users. This can be done by running the command below;<\/p>\n\n\n\n
mysql_secure_installation<\/code><\/pre>\n\n\n\n
Set MariaDB root Password<\/h3>\n\n\n\n
When the script above runs, it first prompts you for the current root password. But since you just did the installation and no password set yet, press Enter to accept blank password. You will then be prompted to set root password.<\/p>\n\n\n\n
...\nEnter current password for root (enter for none): \nOK, successfully used password, moving on...\n\nSetting the root password ensures that nobody can log into the MariaDB\nroot user without the proper authorisation.\n\nSet root password? [Y\/n] y\nNew password: StrongPassWORD\nRe-enter new password: StrongPassWORD\n...<\/code><\/pre>\n\n\n\n
Remove MariaDB anonymous user<\/h3>\n\n\n\n
By default, MariaDB usually has an anonymous user for testing purposes. Remove this user.<\/p>\n\n\n\n
Remove anonymous users? [Y\/n] y\n ... Success!<\/code><\/pre>\n\n\n\n
Disable Remote root Login<\/h3>\n\n\n\n
When prompted to disable remote root login to MariaDB, accept and proceed.<\/p>\n\n\n\n
Disallow root login remotely? [Y\/n] y\n ... Success!<\/code><\/pre>\n\n\n\n
Remove MariaDB test Database<\/h3>\n\n\n\n
Remove test database and the privileges associated with it.<\/p>\n\n\n\n
Remove test database and access to it? [Y\/n] y\n - Dropping test database...\n ... Success!\n - Removing privileges on test database...\n ... Success!<\/code><\/pre>\n\n\n\n
Reload the Privilege Tables<\/h3>\n\n\n\n
Reload the privilege tables to effect all the changes that have been made above.<\/p>\n\n\n\n
Reload privilege tables now? [Y\/n] y\n ... Success!<\/code><\/pre>\n\n\n\n
That is, you MariaDB on Fedora 30 is installed and setup.<\/p>\n\n\n\n
Test Connection.<\/h3>\n\n\n\n
Since you have disabled remote login for root user, you can test local connection as shown below;<\/p>\n\n\n\n
mysql -u root -p\nEnter password: StrongPassWORD\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 16\nServer version: 10.3.12-MariaDB MariaDB Server\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)]> <\/code><\/pre>\n\n\n\n
As you can see above, MariaDB version we are running is 10.3.<\/p>\n\n\n\n
Welcome to the MariaDB monitor.  Commands end with ; or \\g.
Your MariaDB connection id is 16
Server version: 10.3.12-MariaDB<\/strong> MariaDB Server<\/code><\/pre>\n\n\n\n
You can also check the version by logging to MariaDB as in above and running the query;<\/p>\n\n\n\n
select version();
<\/code><\/pre>\n\n\n\n
MariaDB [(none)]> select version();\n+-----------------+\n| version()       |\n+-----------------+\n| 10.3.12-MariaDB |\n+-----------------+\n1 row in set (0.002 sec)<\/code><\/pre>\n\n\n\n
That is all about how to install MariaDB 10.3 on Fedora 30. Enjoy.<\/p>\n\n\n\n
You can also check out previous articles on Fedora 30\/29\/28;<\/p>\n\n\n\n