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.