In this tutorial we will learn how to Create new MySQL user and give it the full root user privileges.
Step 1: Log-in to uer MySQL from the terminal
~$ mysql -u root -p
Step 2: Write The following COmmands
This command will create the user with no privileges
mysql> CREATE USER ''user'@'localhost'
This command will add the root user privileges to the created user
mysql> GRANT ALL ON *.* TO 'user'@'localhost' WITH GRANT OPTION
Now we will reset the privileges table
mysql> FULSH PRIVILEGES
That's it now you can log-out from root user and log-in with the new user.
Have a nice day
Category: How To