![]() ![]() ![]() So, install both the Apache server and the module for PHP support. Because this is just a simple guide, it’s going to follow the quickest path for getting a basic server set up. The Apache web server is extremely powerful and can be extremely easy to set up or ridiculously difficult, depending how in-depth you wan to go. To install PHP on Debian Stretch, run the following line. In the LAMP stack, PHP powers the web content and interacts with the database. The next step in getting the LAMP server set up is installing PHP. Certainly, you can customize any portion of this as you need. 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. ![]()
0 Comments
Leave a Reply. |