Connecting to MySql DB in strapi

Question

I can't seem to understand the documentation in http://strapi.io/documentation/configuration#databases

How to connect to MySqlDB? Where in databases.json do i set all my db settings like user: root, pwd: secret123, host: 192.12.2.123, etc.?

Answer 1

You should add a new connection like this:

{
  "orm": {
    "adapters": {
      "mysql": "sails-mysql"
    },
    "defaultConnection": "default",
    "connections": {
      "someMysqlServer": {
        "adapter": "mysql",
        "host": "YOUR_MYSQL_SERVER_HOSTNAME_OR_IP_ADDRESS",
        "user": "YOUR_MYSQL_USER",
        "password": "YOUR_MYSQL_PASSWORD",
        "database": "YOUR_MYSQL_DB"
      }
    }
  }
}

The current version of Strapi is based on Waterline so if you can't find the right info in the documentation, take a look at the Waterline/Sails documentation as well.

Answer 2

Solution for 2020

1. Add client:

• Strapi < 3.2.5: yarn add sails-mysql or npm install sails-mysql
• Strapi >= 3.2.5: yarn add mysql or npm install mysql

2. Change config <project>/config/database.js (for development) or <project>/config/env/production/database.js (for production)

module.exports = ({ env }) => ({
  defaultConnection: 'default',
  connections: {
    default: {
      connector: 'bookshelf',
      settings: {
        client: "mysql",
        host: env('DATABASE_HOST', 'localhost'),
        port: env('DATABASE_PORT', 3306),
        database: env('DATABASE_NAME', 'default'),
        username: env('DATABASE_USERNAME', 'root'),
        password: env('DATABASE_PASSWORD', ''),
      },
      options: {
        useNullAsDefault: true,
      },
    },
  },
});

3. Also may be you'll need to run yarn build to rebuild your CMS.