[mysql] 5 step create and grant mysql user

1. Login to mysql using user root.

  mysql -u root -p  

    enter your mysql password if needed. if login success, continue to the next step.

2. Use database mysql.

 use mysql;  

3. Create user root1 at all host...

 create user 'root1'@'%' identified by 'password';  

if you want to create user just for localhost ... the code must be like this :

 create user 'root1'@'localhost' identified by 'password';  

4. Once you succeed create a new user, clear and reloads the privileges from the grant tables in the Mysql database with the following command.

 flush privileges;  

5. Last step, grant all privileges to the user that was created.

 grant all privileges on *.* to root1@'%' identified by '' with grant option;