Installing and configuring MariaDB database
-
Install MariaDB database. See Prerequisites for complete installation instructions.
- Verify that MariaDB is installed correctly.
systemctl status mariadb
You should see a message that the database is active and running.
Active: active (running) since Mon 2020-06-01 22:31:25 GMT; 24s ago
- Set MariaDB to start up automatically at system boot time.
systemctl enable mariadb
- Lastly, create the database. Sign in to the MariaDB database engine.
mysql -u root -p
Create the database and add an administrator user. You’ll use this administrator user to connect to the database from the ownCloud application.
MariaDB [(none)]> CREATE DATABASE ownCloud_db; MariaDB [(none)]> GRANT ALL ON ownCloud_db.* TO 'owncloud_admin'@'localhost' IDENTIFIED BY 'YourStrongP@ssword'; MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> EXIT;