Skip to content

Using MySQL

This section outlines how to import the MySQL package both with or without a Vapor project.

Install MySQL

To use MySQL, you need to have the C MySQL library installed on your computer.

# macOS
brew tap vapor/homebrew-tap
brew install https://raw.githubusercontent.com/Homebrew/homebrew-core/a340bfac3b7abff408a6b6fe6fdc39a38ab94871/Formula/mysql.rb
brew install mysql
brew install cmysql
brew switch mysql 5.7.22

Note for Ubuntu * Add Vapor's APT repo to get access to all of Vapor's system packages.

# Ubuntu

sudo apt-get install cmysql

With Vapor + Fluent

The easiest way to use MySQL with Vapor is to include the MySQL provider.

import PackageDescription

let package = Package(
    name: "Project",
    dependencies: [
        .Package(url: "https://github.com/vapor/vapor.git", majorVersion: 2),
        .Package(url: "https://github.com/vapor/mysql-provider.git", majorVersion: 2)
    ],
    exclude: [ ... ]
)

The MySQL provider package adds MySQL to your project and adds some additional, Vapor-specific conveniences like drop.mysql().

Using import MySQLProvider will import both Fluent and Fluent's Vapor-specific APIs.

With Fluent

Fluent is a powerful, pure-Swift ORM that can be used with any Server-Side Swift framework. The MySQL driver allows you to use a MySQL database to power your models and queries.

import PackageDescription

let package = Package(
    name: "Project",
    dependencies: [
        ...
        .Package(url: "https://github.com/vapor/fluent.git", majorVersion: 2),
        .Package(url: "https://github.com/vapor/mysql-driver.git", majorVersion: 2)
    ],
    exclude: [ ... ]
)

Use import MySQLDriver to access the MySQLDriver class which you can use to initialize a Fluent Database.

Just MySQL

At the core of the MySQL provider and MySQL driver is a Swift wrapper around the C MySQL client. This package can be used by itself to send raw, parameterized queries to your MySQL database.

import PackageDescription

let package = Package(
    name: "Project",
    dependencies: [
        ...
        .Package(url: "https://github.com/vapor/mysql.git", majorVersion: 2)
    ],
    exclude: [ ... ]
)

Use import MySQL to access the MySQL.Database class.