In the latest version of MySQL Database Server, the password field of user table has been removed so the newest way with old server compatibility is given below. Just follow the instruction as follows it works for me.
Start the mysql server:
© 2017 W3public.com. All Rights Reserved.