This is the shortest way we know about creating and granting privileges to a new user in a development environment;
Log into Mysql Console and type: GRANT ALL PRIVILEGES ON *.* TO 'yourUserName'@'localhost' IDENTIFIED BY 'password';
[Note] The user will be created and privileges will be granted all in one.
Edit this Article