MySQL

The Railway MySQL database service allows you to provision and connect to a MySQL database with zero configuration.

Deploy

You can add a MySQL database via the CMD + K menu or by clicking the + New button on the Project Canvas.

Connect

There are two ways to connect to a MySQL database:

• privately via Private Networking
• publicly via TCP Proxy

When you deploy your MySQL database, you will have access to two environment variables that enable one of the two connection types (private or public).

As you create more services in your project, you can use Reference Variables to easily connect to the MySQL database.

Private Networking

To access your MySQL database from another service within the same project, you can use the connection string stored in the MYSQL_PRIVATE_URL environment variable.

This connection string uses Private Networking to route communication to your service over the private network.

TCP Proxy Connection

To access your MySQL database over the public internet, you can use the connection string stored in the MYSQL_URL environment variable available in the service.

This connection string uses the TCP Proxy connection to route communication to your service over the public internet.

You can also connect using mysql shell:

Variables

The following variables are included in the MySQL service and can be referenced in other services:

• MYSQLHOST
• MYSQLPORT
• MYSQLUSER
• MYSQLPASSWORD
• MYSQLDATABASE
• MYSQL_URL
• MYSQL_PRIVATE_URL

Connect to your MySQL container using your library of choice and supplying the appropriate environment variables.

Image

The MySQL database service uses the mysql:latest docker image.

Changing System Variables

Tailor your MySQL service to your needs by adding any variables relevant to the mysql image.