In order for that user to be able to use the database that you just created, you need to grant them privileges on it. ![]() That command creates a regular user that can sign in locally and set that user’s password. CREATE USER IDENTIFIED BY 'userpassword' ![]() It is an absolutely terrible idea to use the root user for anything other than managing MariaDB as a whole. You need to create a regular user now to use the database. MariaDB will then prompt you for the root password that you just set up.Ĭreating a database is fairly simple. Now that the MariaDB server is installed, you can log in as your root user and set up a regular user and a database. Make sure to choose something as secure as possible, since it will determine, in part, the security of your databases. # apt install mariadb-client mariadb-serverĭuring the install process, you will be prompted to create a root password for MariaDB. To install MaridaDB on Stretch, just use apt to install the packages. However, MariaDB is a drop-in replacement that isn’t controlled by Oracle, so it tends to be a better option. Traditionally, the “M” in LAMP stands for MySQL. ![]() To get started, install and setup the database portion of the stack, MariaDB.
0 Comments
Leave a Reply. |