Hope you are doing well.

Please follow the steps given below:

1) Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting).

    $ mysqld --skip-grant-tables

2) Execute these statements.

    $ mysql -u root mysql
    $ mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';
    $ mysql> FLUSH PRIVILEGES;

If you face the unknown field Password error above use:

update user set authentication_string=password('my_password') where user='root';

3) Finally, restart the instance/daemon without the --skip-grant-tables option.

    $ /etc/init.d/mysql restart

4) You should now be able to connect with your new password.

$ mysql -u root -p

Enter password: my_password

5) Now try to create the new user

mysql>CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

mysql>GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

mysql>FLUSH PRIVILEGES;


I think this will resolve the query, Please let me know if you have any further issue regarding this.

Feel free to contact us in case you have any query. 
 
Kindly share your feedback by clicking on either of the smiley's.


Please note if you are not happy with the response on this ticket, please escalate it to escalations@edureka.in.
We assure you that we will get back to you within 24 hours

 
Regards,
Suman Samanta
edureka! Support Team