Next, grant permissions on all databases to a newly created account. 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: 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:Īfter running the above command, you will be prompted with various options: Now, to install MariaDB, execute the below-mentioned command: Configure MariaDB on Debian # For this tutorial, we will install MariaDB on Debian 11 system via default repositories. 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.
0 kommentar(er)
