MySQL/MariaDB user generator

Generate SQL to create a database user and grant selected privileges on one database or globally.

Username

Connect from host

Password

CHANGE_ME is a placeholder. Replace it here with a strong password. Backslashes and control characters are not allowed so the SQL remains valid across SQL modes.

Privilege scope

One database Global server access

Database name Create the database if needed

Privileges

Only common data privileges are selected by default. Choose additional schema privileges deliberately.

Data access

Read data SELECT Insert data INSERT Update data UPDATE Delete data DELETE Execute routines EXECUTE Show views SHOW VIEW

Schema and administration

Create tables CREATE Alter tables ALTER Manage indexes INDEX Drop objects DROP Use references REFERENCES Create temporary tables CREATE TEMPORARY TABLES Lock tables LOCK TABLES Create views CREATE VIEW Create triggers TRIGGER Create events EVENT

SQL output

-- Create the user account if it does not exist (an existing password is not changed)
CREATE USER IF NOT EXISTS 'app_user'@'localhost' IDENTIFIED BY 'CHANGE_ME';

-- Grant the selected privileges
GRANT SELECT, INSERT, UPDATE, DELETE ON `app\_db`.* TO 'app_user'@'localhost';

The output contains the password in plain text. Keep it confidential and execute it only over a trusted connection.

SQL is generated in your browser and is never transmitted.

Home Privacy Imprint

A project by Fabian Martin