How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the MySQL db. Give privs. Update privs | Eklavya Online

How to allow the user “sonia” to connect to the server from localhost using the password “passwd”. Login as root. Switch to the MySQL db. Give privs. Update privs

MySQL Interview Questions

# mysql -u root -p

mysql> use mysql;

mysql> grant usage on *.* to sonia@localhost identified by ‘passwd’;

mysql> flush privileges;

Total Views: 38,841