GRANT ALL PRIVILEGES ON newdb.* to that’s done, flush all privileges from the console and exit. Since this is a general purpose user for managing everything on this database, it will be given all privileges. 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.

Install mysql debian 9