- \n
- Install MariaDB on Arch Linux<\/strong><\/li>\n
- Use MariaDB on Arch Linux<\/strong><\/li>\n
- Remove MariaDB on Arch Linux <\/strong><\/li>\n<\/ul>\n
How To Install MariaDB on Arch Linux<\/strong><\/h2>\n
To install MariaDB on Arch Linux there is only one way and that is by using its default package manager though it has a slightly old version. If you are looking for a newer version and using the Debian-based Linux distributions, then you can visit their official website for it. In the case of Arch Linux to install MariaDB execute:<\/p>\n
pacman -S<\/span> mariadb<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-1.png\")
<\/p>\nNow initialize the MariaDB data directory and create the system tables in the MySQL database and for that execute:<\/p>\n
sudo<\/span> mariadb-install-db --user<\/span>=mysql --basedir<\/span>=\/<\/span>usr --datadir<\/span>=\/<\/span>var\/<\/span>lib\/<\/span>mysql<\/div><\/div>\nIt works by starting the MariaDB server\u2019s mysqld process in –bootstrap mode and sending commands to create the system tables and their content. The options –user, –basedir, and –datadir specify the username that mysqld will run as, the installation directory, and the data directory, respectively. This command is for Linux\/Unix only. Moreover, this command is also useful for setting up MariaDB on a new system or after upgrading from a previous version.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-2.png\")
<\/p>\nNext, activate the MariaDB service on Arch Linux and for first enable it and then start it using the systemctl <\/em>command:<\/p>\n
sudo<\/span> systemctl enable<\/span> mariadb
\n
\nsudo<\/span> systemctl start mariadb<\/div><\/div>\n
\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-3.png\")
<\/strong><\/p>\nThe default installation of MariaDB leaves it insecure which can cause security breaches and for that, it is necessary to prevent unauthorized access to your database server and data. So, to configure security settings and improve MySQL or MariaDB server security on Linux systems execute:<\/p>\n
sudo<\/span> mysql_secure_installation<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-4.png\")
<\/p>\nFurthermore, it allows you to set a password for the root user, remove root and anonymous accounts, delete the test database, and reload user privileges tables. Now upon the execution of the command you will receive several prompts:<\/p>\n
Switch to unix_socket authentication: <\/strong>If you want to use the unix_socket plugin to authenticate the root user by matching the system username and the MariaDB username. You can avoid passwords and be safer, but only for connections within the same network. The recommended answer is Yes if you only need to access MariaDB as root from the same machine, or No if you need to connect remotely or use a different system username.<\/p>\n
Change the root password:<\/strong> If you have not set a password yet, or if you want to use a stronger password, you should answer Yes and enter a new password. Otherwise, you can answer No to keep the existing password.<\/p>\n
Remove anonymous users:<\/strong> This prompt asks you if you want to remove the anonymous users that are created by default when you install MariaDB. Anonymous users can pose a security risk, as they can access any database that has not been explicitly protected. The recommended answer is Yes to delete the anonymous users.<\/p>\n
Disallow remote login:<\/strong> This prompt asks you if you want to prevent the root user from logging in remotely. Allowing remote login for the root user can expose your MariaDB server to attacks from the network. The recommended answer is Yes to disable remote login for the root user.<\/p>\n
Remove test database and access to it: <\/strong>This prompt asks you if you want to remove the test database that is created by default when you install MariaDB. The test database can be accessed by any user, even anonymous users, and can be used to test malicious queries or exploit vulnerabilities. The recommended answer is Yes to delete the test database and the privileges that allow access to it. However, you can enter No if you want to keep the test databases for testing and learning purposes.<\/p>\n
Reload table privileges:<\/strong> This prompt asks you if you want to reload the table privileges after making the changes above. This is necessary to apply the new security settings to the MariaDB server. The recommended answer is Yes to reload the table privileges.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-5.png\")
<\/p>\nNow once you are done with the changes you can upgrade MariaDB if by any chance the version in the default repository is updated:<\/p>\n
sudo<\/span> mariadb-upgrade<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-6.png\")
<\/p>\nNow login to the MariaDB database tool using the root account, here if you have created any other user then replace the root with its username:<\/p>\n
mysql -u<\/span> root -p<\/span><\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-7.png\")
<\/p>\nNow as you can see in the image above there is a warning for using mysql which says to use mariadb instead as it will be deprecated in the newer versions though still you can use it for logging in:<\/p>\n
sudo<\/span> mariadb -u<\/span> root -p<\/span><\/div><\/div>\nOnce you are in the database server now you are all set and can create users, and databases and manage them, to list all the databases executed:<\/p>\n
SHOW DATABASES;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-8.png\")
<\/p>\nNote:<\/strong> As I have mentioned earlier the newer version file for MariaDB is available on its official site but on Arch Linux, there are some issues with the dependencies due to which it cannot be installed. This is because the dependencies required to install the tar.gz file on Arch Linux have been deprecated.<\/p>\n
Here I have tried to install through yaourt and other AUR helpers on Arch, but the process wasn\u2019t successful as the repository required for installation of yaourt on Arch is dead as you can see the error in the image below:<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-9.png\")
<\/p>\n<\/p>\n
How to Use MariaDB on Arch Linux <\/strong><\/h2>\n
MariaDB can power websites that need to handle large amounts of content, such as blogs, news portals, e-commerce sites, and more. It can handle log data from different kinds of sources, such as web servers, applications, and devices. MariaDB is free and open source under the GPLv2 license, which means you can use it without any restrictions or fees. Here I have explained some of the basics of using MariaDB:<\/p>\n
1: Creating a Database in MariaDB<\/strong><\/h3>\n
The database is primarily a set of data that is specifically about a single entity, for instance, a list of employees and their details of a company or any set of readings regarding any experiment. So, to gather all the data in one place you first have to create a database and execute:<\/p>\n
CREATE DATABASE <<\/span>database-name><\/span><\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-10.png\")
<\/p>\nTo list all the databases created in MariaDB, just use the following command:<\/p>\n
SHOW DATABASES;<\/div><\/div>\n2: Create a User in MariaDB<\/strong><\/h3>\n
Managing a big database by a single user can be a challenging task, so a database can be linked with different users, but these users can be given limited privileges. So, to create a user you need to give a username and password through which the user will access MariaDB:<\/p>\n
CREATE USER '<user-name>'<\/span>@<\/span>'localhost'<\/span> IDENTIFIED BY '<user-passowd>'<\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-11.png\")
<\/p>\nOnce you have created a user, you can log in to MariaDB by giving its username and password as in the syntax below:<\/p>\n
sudo<\/span> mariadb -u<\/span> <<\/span>user-name><\/span> -p<<\/span>passowrd><\/span> -h<\/span> localhost<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-12.png\")
<\/p>\nYou can also log in to MariaDB by using the p flag and giving the password at a later stage as this way is more secure because no one can see your database password:<\/p>\n
mariadb -u<\/span> <<\/span>User-name><\/span> -p<\/span><\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-13.png\")
<\/p>\nJust like listing the databases in MariaDB, you can also list the users that have access to MariaDB on Arch Linux and for that execute:<\/p>\n
SELECT User FROM mysql.user;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-14.png\")
<\/p>\n3: Grant Privileges in MariaDB<\/strong><\/h3>\n
Users in MariaDB require permissions to make changes in the databases so if you want a user to edit or add some data in the database then the respective user should have editing permissions. As in the image below User1 is trying to create a database but it doesn\u2019t have any rights to it:<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-15.png\")
<\/p>\nTo grant the privileges to a user first, you have to log in using the administrator account and then list all the privileges that can be given to a user along with their command and for that execute:<\/p>\n
SHOW PRIVILEGES;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-16.png\")
<\/p>\nNow from the privileges table, shortlist the privileges you want to give and then use the GRANT<\/em> command along with the username and database name to give access to the respective user:<\/p>\n
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, EVENT, TRIGGER, DELETE HISTORY ON <<\/span>database-name><\/span>.*<\/span> TO '<user-name>'<\/span>@<\/span>'localhost'<\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-17.png\")
<\/p>\nNow once you have given access to the user for the certain task on the database, log in to MariaDB using that user and execute the below command to see the given privileges:<\/p>\n
SHOW GRANTS;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-18.png\")
<\/p>\nNow as an administrator, you can list the users along with the databases along with their hostname through which they are allowed to access the MariaDB databases:<\/p>\n
SELECT User, Db, Host from mysql.db;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-19.png\")
<\/p>\n4<\/strong>: Granting Similar Privileges to Multiple Users <\/strong><\/h3>\n
Usually, there might be cases where different databases are accessed by multiple users so in that case it becomes quite a lengthy task to grant each user the same set of rights. For that, it\u2019s better to create a role in MariaDB that has all the privileges that are to be granted to other users and then use the role permissions that can be granted to the users.<\/p>\n
CREATE ROLE <<\/span>role-name><\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-20.png\")
<\/p>\nNow I have created a role named MANAGER and granted it the same permissions using the GRANT<\/em> command along with the database name:<\/p>\n
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES,INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, EVENT, TRIGGER, DELETE HISTORY ON test.*<\/span> to 'MANAGER'<\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-21.png\")
<\/p>\nAs I have already created a user and to grant it privileges for the test database, I have granted the manager role to User2 by stating its username and password:<\/p>\n
GRANT MANAGER TO '<user-name>'<\/span>@<\/span>'localhost'<\/span> IDENTIFIED BY '<password>'<\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-22.png\")
<\/p>\nUsually, granting all the permissions is not recommended to any of the users except the administrator as it can compromise the security of the database. To give a user or root account full access, run this command:<\/p>\n
GRANT ALL PRIVILEGES ON '<database-name>'<\/span>.*<\/span> TO '<user-name>'<\/span>@<\/span>localhost;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-23.png\")
<\/strong><\/p>\nNow if you want to remove all the privileges from a user in case you have assigned a role to the user then in that case execute:<\/p>\n
REVOKE <<\/span>given-role><\/span> FROM <<\/span>user-name>@<\/span>localhost;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-24.png\")
<\/strong><\/p>\nAlternatively, you can also revoke the privileges of a user if you have assigned it manually and for that execute:<\/p>\n
REVOKE ALL PRIVILEGES ON *<\/span>.*<\/span> FROM '<user-name>'<\/span>@<\/span>'localhost'<\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-25.png\")
<\/p>\n5: Removing Database in MariaDB<\/strong><\/h3>\n
If you want to remove the database in MariaDB then login through the administrator account if the other users do not have permission for it and after that use the below syntax:<\/p>\n
DROP DATABASE <<\/span>database-name><\/span>;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-26.png\")
<\/strong><\/p>\n6: Removing a User in MariaDB<\/strong><\/h3>\n
Further, if you want to delete a user from the MariaDB database on Arch Linux, then execute the drop command:<\/p>\n
DROP USER <<\/span>user-name>@<\/span>localhost;<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-27.png\")
<\/strong><\/p>\nFurthermore, if you need more help with commands used for operating MariaDB then you can consult its help:<\/p>\n
help<\/span><\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-28.png\")
<\/p>\nNote: <\/strong>Granting and revoking access to users for different databases should be done by logging in to the administrator account.<\/p>\n
<\/p>\n
How to Remove MariaDB from Arch Linux<\/strong><\/h2>\n
If you want to completely remove MariaDB from Arch Linux, then first you need to deactivate its service and for that execute:<\/p>\n
sudo<\/span> systemctl stop mariadb<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-29.png\")
<\/p>\nNow to uninstall it from Arch using the default package manager along with the Rns<\/em> flag as in the command below:<\/p>\n
sudo<\/span> pacman -Rns<\/span> mariadb<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-30.png\")
<\/p>\nNext, remove the directory of MariaDB from Arch Linux and afterward reboot the system to apply the changes:<\/p>\n
sudo<\/span> rm<\/span> -r<\/span> \/<\/span>var\/<\/span>lib\/<\/span>mysql<\/div><\/div>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2024\/01\/word-image-24472-31.png\")
<\/p>\nConclusion<\/strong><\/h2>\n
MariaDB is a database management tool that is open-source and free to use, to install it on Arch Linux use its default package installer. Once you have installed it, make it secure by executing the sudo mysql_secure_installation<\/em> command. Compared to MySQL, MariaDB offers more features and capabilities, which makes it a preferred choice for most users.<\/p>","protected":false},"excerpt":{"rendered":"
To install it on Arch Linux, use its default package manager. Once you have installed it, make it secure by executing the sudo mysql_secure_installation command.<\/p>","protected":false},"author":113,"featured_media":24784,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1055],"tags":[],"class_list":["post-24472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-arch"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/24472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=24472"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/24472\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/24784"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=24472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=24472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=24472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Use MariaDB on Arch Linux<\/strong><\/li>\n