MySQL Create User

The MySQL Create User Tool allows users to visually create users for MySQL.

The create user tools prompts the user for the following information:

User Name (The name of the user to create)
Password (The password for the new user)
Privileges (Whether to grant all privileges or specific privileges to the user)
Databases (Whether to grant access to all databases or specific databases for the user)
Domains (Whether to grant access from all domains or specific domains for the user)
Grant Option (Whether to give the user the grant option)

Listed below is an example SQL statement generated by the Create User Tool for MySQL

GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'localhost'
IDENTIFIED BY 'test_pass' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'%'
IDENTIFIED BY 'test_pass' WITH GRANT OPTION;

MySQL Create User