Documentation

Didn't know where to start? Here we have something might be useful.

Database

Database overview

RunCloud use MariaDB for your database. It is a drop-in replacement for MySQL. Please note that MariaDB == MySQL but MySQL != MariaDB. Every tools created for MySQL is also compatible with MariaDB.

Your database run in tcp mode rather than sock. So that you can open your firewall port to use your database remotely. By default, we closed your database port from outside. You can enable it by adding firewall to port 3306/tcp inside the Security section.

Create database

To create database, navigate to database menu and then click create database. Here you will need to fill in the database name.

Create database user

This will create a user for your database. Please note that this user won’t be able to use any database that you have until you attach them to any of your database.

For the password, we recommended you to use password generator instead of the password stored in your head. Recommended password length is more than 25 characters.

Attach user to database

This will attach intended user to database. Once the user have been attached, the user will own the database. You can always revoke the user access from the database.

For the best practice, please make sure each user only own one database.

Change database user password

You may change the database password easily using RunCloud. Click on the change password and generate your database user password. New password will be push to your server and will be taken care by the Agent.

Delete database

To delete your database, click on the delete button and fill in the database name. Please make sure there is no Web Application is using the database or you will face serious problem since deleting database will drop all your database data.