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)
MySQL version 8 introduced a new format for creating users. The Create User tool also has an option for generating the create user statements using the MySQL version 8 syntax.
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;
Below is an example using the MySQL version 8 syntax.
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass';
CREATE USER 'testuser'@'%' IDENTIFIED BY 'testpass';
GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%';
flush privileges;
