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