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

Comments

Popular posts from this blog

Review Pemakaian Lenovo K900 Mati Total (Matot)

VERIFIKASI SUARA MENGGUNAKAN METODE MFCC DAN DTW MENGGUNAKAN METODE MFCC DAN DTW (BAB II TINJAUAN PUSTAKA)

cara daftar di DMOZ