Database connection and public access

Services in the same project reach the database at its Internal address, a full connection address that already holds the user, the password and the port. Copy it with the button beside it and paste it into the application's Environment, for example as DATABASE_URL= followed by the address, then press Save. See Environment variables for when the change takes effect.

The internal address does not work from your own computer. For that, turn on public access (below) and use the Public address.

Set the password and Generate change the password inside the running database. Services that connect with the old one stop connecting until their environment has the new one.

Copy the Internal address again, which carries the new password, and replace the old value in the Environment of every application that uses the database.

A new database starts only when it is deployed. Check its state chip: Idle means it has never been deployed, so press Deploy; Stopped means someone stopped it, so press Start.

The password of a database that has started is changed by running a command inside it, so the database must be running. The card warns about this ahead of time with "The password changes inside the running database, so start it first."

Press Start (or Deploy if it failed), wait for Running, then set the password again.

The database name, the user and the version are only editable before the first start: the database writes them into its data then, and the card afterwards reads "The name, the user and the version were written into the database when it first started, and are fixed now."

To use another name, user or version, create a new database with the values you want, copy the data across with the database's own tools, and point your applications at the new one. See Databases.

Public access publishes the database on the platform's public address, and this platform has none configured. The card shows Not available on this platform under Public address, and Turn on is greyed out. Connect from a service on the platform instead, or contact support.

Public access takes a free port from 20000 to 29999 on the server the database runs on, and none is free. Try Turn on again later.

You chose a public port with Change port that another database on the same server already uses. Choose another port and press Move the port.

The port given to Change port is outside the range public access uses. The console says the same thing before asking, and also refuses the port the database already has. Give a whole number from 20000 to 29999.

A password you set yourself must be 12 to 128 characters long and use only letters, digits and the four characters ., -, _ and ~, so that it reads the same inside a connection address. Choose another, or press Generate for one Cloud makes.

Before the first start you can rename the database. The name starts with a lowercase letter and is at most 32 characters of lowercase letters, digits and underscores, such as app or shop_orders.

The same rule applies to the user name, such as app.

MySQL and MariaDB keep root as their own administrator, so it cannot be the database's user. Choose another user name.