1,234
edits
Changes
→Create an SQL user
* Execute '''use firstdb''' and '''show tables'''. You have access to the firstdb databases, but there aren't any tables in it. You need to create your own.
* [https://www.guru99.com/mariadb-tutorial-install.html#6 This MariaDB tutorial] is as simple as it gets for creating tables, inserting data into them, and retrieving data. Follow it if you have the time.
= Install Nextcloud =
We're going to install a handy web application in order to get some real world practice setting up our database. Nextcloud has all kinds of capabilities, the most obvious one is that you can use it to share files (of any size) with specific users or make them public for anyone to access.
<source></source>
<source></source>
* wget the .tar.bz2 (not zip)
* Extract it into /var/www/html so you have a /var/www/html/nextcloud/index.html