How to create a new database in MySQL command line

To create a new database on your MySQL server, start the `mysql` command line client and execute the following query:

CREATE DATABASE `cloudbalkan_db`;

Here – ” cloudbalkan_db” is the name of your new database.

You have freedom to choose that name, but keep in mind the following rules and advises for naming:

  • Database names in MySQL are case sensitive
  • Database names in MySQL can be between 1 and 64 character long
  • It’s highly adviseable to replace spaces with underscores
  • It’s highly adviseable to stick to simple and descriptive names, in lower case, english aphabet only

Check out more MySQL related articles on CloudBalkan.