niomsf.blogg.se

Make sure to change admin with your username and _pas$$w0rd_ with a new secure password. Now create a new user with a password in the MariaDB server. And to create a new user login to MariaDB using: sudo mysql This may cause complications therefore, it is recommended to set a new user with password-based access. Create Privileges User with Authenticationįor security purposes, MariaDB uses a unix_socket plugin to authenticate the root user. The options are self-explanatory, for the first two options choose “n” and for the next sequence of options press “y” for yes. To configure MariaDB properly we need to run a security script using the below-mentioned command: sudo mysql_secure_installationĪfter running the above command, you will be prompted with various options: Now, to install MariaDB, execute the below-mentioned command: sudo apt install mariadb-server Configure MariaDB on Debian For this tutorial, we will install MariaDB on Debian 11 system via default repositories.įirstly, update the packages list using: sudo apt update You can directly install it without adding an extra repo to your system. The MariaDB packages are available under the official repositories. This article is focusing on how to install MariaDB, an alternative to MySQL on Debian 11. MySQL is currently not available for Debian 11 Bullseye, so MariaDB is a perfect choice.