This is a very complicated and tiring problem that we all have to face in some point of our life. Someday suddenly, we will not be able to access mysql through phpmyadmin/mysql_workbench. So follow these steps to make it work perfectly:
1. open terminal
2. mysql -u root -p (enter)
3. enter your password
4. use mysql;
5. select user, host, plugin from mysql.user;
6.. update user set plugin=’mysql_native_password’ where user=’root’;
7. update user set Password=’Password(‘my_password’) where user=’root’;
update user set authentication_string=password(‘my_password’) where user=’root’;
8. flush privileges;
8. service mysql restart
Xem thêm bài viết khác: https://madisonrep.org/cong-nghe
10 seconds video and finish! solved!
Perfect! Without water!Short and !
Great. Thank you so much.
thanks a lot..
Thanks, I am an entry level enthusiast of coding in PHP, and MySQL, it was excessively difficult to find out the solution on my own.
The best and shortest solution which works like a charm. Thank you!
before setting the password you can check with this command whether you have the field password or the field authentication_string: desc user;
thaks, your video helped me too much.
worked perfectly!!! thanks man!
you cool man
Perfect!! I had search on web for many solutions, but your solution is the only right!!! Thank you