How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs | Eklavya Online

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs

# mysql -u root -p

mysql> use mysql;

mysql>INSERTINTO user (Host,User,Password) VALUES(‘%’,’username’,PASSWORD(‘password’));

mysql> flush privileges;