To list the existing databases:

SHOW DATABASES;

To create a new database:

CREATE DATABASE db_name;

To get access and use the newly created database:

USE db_name;

In TablePlus, you can create a new table from its GUI tool for MySQL:

  • Click on the database button to see the list of current databases (Cmd + K)
  • Click + button to create a new database
  • Don’t forget to commit changes (Cmd + S) to the server after creating

Create a new MySQL database

New to TablePlus? It’s a modern, native tool with an elegant GUI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.

TablePlus GUI Tool MySQL