Laravel and MySQL

For data store, why not start with a relational database classic: MySQL. You can run your own MySQL Fly App, or set up a PlanetScale MySQL-compatible serverless database.

Laravel and MySQL Fly App

To run MySQL as a Fly App, follow our guide here. Afterwards, you’re good to connect:

  1. Connect to your MySQL Fly App from a Laravel Fly App
  2. Connect to your MySQL Fly App from a local environment

Connect from a Laravel Fly App

  1. Revise the [env] configuration in your Laravel application’s fly.toml file to connect with your MySQL Fly App’s Fly .internal address:

      APP_ENV = "production"
      DB_CONNECTION = "mysql"
      DB_HOST = "<MYSQL Fly .internal Address>"
  2. Then, set up your Laravel Fly App’s database username and password through Fly Secrets:

  3. Finally deploy your Laravel Fly App changes with:

    fly deploy 

Connect from a local environment

The MySQL instance you spun up in “is closed to the public internet”, and can only be accessed by another application found in your organization’s private network. You’ll need a way to tunnel into the network and finally connect to your MySQL instance.

In this guide you’ll tunnel to your MySQL instance through the use of fly proxy

  1. Open your MySQL application’s fly.toml and take note of the following:

    app = "<mysql-app-name>"
      MYSQL_DATABASE = "<database-name>"
      MYSQL_USER =  "<database-user>"
  2. Then use fly proxy to tunnel to your MySQL application:

    fly proxy 3306 -a <mysql-app-name>
  3. Finally, update your Laravel application’s local .env file with the values from your MySQL fly.toml file:


Laravel with MySQL-compatible PlanetScale

For a basic PlanetScale and connection, follow our guide here. If you’re up for a multi-region level up, check out our Multi-Region Laravel with PlanetScale article.

Once you’re setup with PlanetScale, connect your Laravel application in through the following steps below:

  1. Get Laravel connection information from PlanetScale instance
  2. Connect from Laravel application in

Get Laravel connection from PlanetScale instance

Once initialized, your database dashboard should have metrics and options like so:

PlanetScale initialize database dashboard

  1. Click on the Connect button at the top right, this should provide a box of information for connecting with your PlanetScale database.
  2. First though, make sure to add a password, by clicking on the “New Password” button at the upper right corner. This should show you a new password afterwards.
  3. Next, select “Laravel” in the list labeled “Connect with”

PlanetScale Laravel connection string Take note of the connection string provided and let’s move on!

Connect from a Laravel Fly App

  1. Update the [env] configuration in Laravel application’s fly.toml with details from the PlanetScale connection string

      APP_ENV = "production"
      DB_CONNECTION = "mysql"
      DB_HOST = "<DB_HOST>"

    Take note that the value for MYSQL_ATTR_SSL_CA varies depending on the Docker container used. For the default Docker container used by, the above value is the path

  2. Next, set up the database username and password through fly secrets:

  3. Finally deploy your changes with:

    fly deploy