[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;  


Popular posts from this blog

Data Flow Diagram (DFD)

allow only numeric (0-9) in html inputbox using jquery