When provisioning a server Forge can optionally install a database. You can then use the Forge dashboard to manage the database such as; managing users / databases and resetting the database password.
Managing Databases Not Installed By Forge
Forge is unable to manage databases that were not installed as part of the provisoning process.
# Creating a Server With a Database
When creating a new server, you can select to install one of these database servers:
- MySQL (5.7)
- MySQL (8.0)
- MariaDB (10.3)
- Postgres (12)
As part of the provisioning process, Forge will automatically install the chosen database server and create a default
forge user, and a secure, random password. The database password will be shown upon creating the server alongside the root password and will also be emailed to you.
If you decide not to install a database as part of the provisioning process but later decide you need one, you have two options:
- Re-create the server, but this time selecting your required database server too.
- Maintaining a custom database server. In this case, Forge will not be able to manage users or databases for you.
# Changing the Root / Forge Database Password
To reset the
forge database user passwords, you may use the password reset functionality.
Manually changing the root password
Do not change the
forge database user passwords manually or outside of the Forge dashboard. Doing so will prevent Forge from being able to connect to, or manage your database.
# Connecting to a Database GUI Client
All Forge servers require SSH key authentication and are not able to be accessed using passwords. Therefore, when using a GUI database client to connect to your Forge database, you will need to use SSH authentication.
When selecting the SSH key to use during authentication, ensure that you select your private SSH key. For example, when using the Sequel Pro database client:
# Database Management Within Forge
For servers running MySQL, MariaDB & PostgreSQL, Forge offers some advanced features which allows it to manage your databases and database users easily.
# Creating a Database
You can create a new database through the Forge dashboard by clicking on to the server detail page and clicking Database in the sidebar. By default, you only need to enter the name of your new database. The
forge user will be able to access the database automatically.
# Create a Database User
You can create extra database users through the Forge dashboard. To do so, you'll need to provide the username, password and also select the databases that the new user can access.
# Upgrading A Database Server
Forge does not provide the ability to upgrade your database server software automatically. If you wish to upgrade your database server, you will need to complete this manually.