MySQL Command Generator
A free online tool that generates the commands to create a MySQL database and user in seconds
Fill in the fields below and the generator assembles the full set of SQL statements you need to create a MySQL database and user straight from the console.
How does the MySQL command generator work?
Enter a database name, username, host name and password, and the tool returns ready-to-paste SQL statements — CREATE DATABASE, CREATE USER and the GRANT that ties them together. No need to memorise the syntax or dig through the documentation.
Who is this tool for?
The generator is completely free and comes in handy for developers and system administrators who regularly set up new databases — when deploying online shops, web applications or business systems on cloud instances and dedicated servers. Instead of typing three commands by hand and risking a typo in the privileges, you copy one consistent, ready-made set.
Other tools
PostgreSQL Generator
Ready-to-paste CREATE ROLE, CREATE DATABASE and GRANT statements for PostgreSQL.
Open tool