MySQL Connection

Create a PawSQL Workspace from a MySQL connection.

Requirements

• MySQL Server 8.0, 5.7, or 5.6.
• Make sure your database is accessible from the machine running PawSQL

Information Needed

When we choose a MySQL connection as the workspace type, we need to supply following connection information. PawSQL will connect to the database server and retrieve the table, view and indexes definition.

Host * - The host name of the database. Port * - The port to connect to. Database * - The database name. Username * - The user name which is used to access the database. Password * - The password associated with the user name.

How to access your database from internet?

• Deploy PawSQL Cloud in your own environment, contact us at service@pawsql.com
• Amazon RDS or Aliyun RDS
• Set up a reverse proxy

  • ngrok https://github.com/inconshreveable/ngrok

  • frp https://github.com/fatedier/frp

  • lanproxy https://github.com/ffay/lanproxy

  • goproxy https://github.com/snail007/goproxy

  • nps https://github.com/cnlh/nps