Q. To set new Password for mysql user
SOLUTION:
# update mysql.user set password= PASSWORD(‘abc’) where user =’root’;
# flush privileges;
# commit;
- Goto mysql command prompt:
# update mysql.user set password= PASSWORD(‘abc’) where user =’root’;
# flush privileges;
# commit;