Note that the password is not included in this URL, so you should provide your password manually within your database client's GUI. Forge automatically generates this connection URL for you and you can use it to connect to your database. Some clients, such as TablePlus, allow you to connect to a database via a connection URL. For example, when using the TablePlus database client: When selecting the SSH key to use during authentication, ensure that you select your private SSH key. Therefore, when using a GUI database client to connect to your Forge database, you will need to use SSH authentication. ::: Connecting To Databases Via A GUI Clientīy default, database connections require SSH key authentication and are not able to be accessed using passwords. Doing so will prevent Forge from being able to connect to or manage your database. You should not change the root or forge database user passwords manually or outside of the Forge dashboard. :::danger Manually Changing The Root Password To reset the root and forge database user passwords, you may use the password reset functionality provided by Forge's Databases management tab. ::: Changing the Root / Forge Database Password If you need a database and web server on the same server, you should provision an 'App Server'. Web servers are provisioned with the minimum amount of software needed to serve your PHP application only. If you created a 'Web Server', you will not be able to install a database on that server at any point. Once installed, you will then be able to manage your database via Forge. If you later decide to that you need to install a database on your server, you can do so through the server's Databases management tab. These passwords will also be emailed to you.

The database password will be shown upon creating the server alongside the root password. When creating a new server, you can select to install a supported database server:Īs part of the provisioning process, Forge will automatically install the selected database server and create a default forge database, forge user, and a secure, randomly-generated password. You can then use the Forge dashboard to manage databases, users, and permissions.

When provisioning a new Forge server you may choose to install an App Server or a Database Server.

Tableplus create new database