Access denied for user 'root'@'localhost' (Mysql - phpMyAdmin)
Subscribe - / @techprogrammingideas
Access denied for user 'root'@'localhost' (Mysql - phpMyAdmin)
ERROR 1698 (28000): Access denied for user 'root'@'localhost' at Ubuntu 18.04
=========================================================
Steps:
Open terminal and type
sudo mysql -u root -p
It will prompt you in mysql, here you can fire any mysql commands.
Use mysql table for change table type, so we can use empty password. Bellow is command for it
USE mysql;
Now we change type of table by following command
UPDATE user SET plugin='mysql_native_password' WHERE User='root';
now we have to flush the privileges, because we have used UPDATE. If you use INSERT, UPDATE or DELETE on grant tables directly you need use FLUSH PRIVILEGES in order to reload the grant tables.
FLUSH PRIVILEGES;
now exit from mysql by following command
exit;
now restart mysql server by following command
service mysql restart
=========================================================
#phpMyAdmin_MySql
https://techprogrammingideas.blogspot...
PSC Study Materials and Previous Question Papers
http://www.mission2win.in/
Any doubts and help to type comments below
En esta página del sitio puede ver el video en línea Access denied for user 'root'@'localhost' (Mysql - phpMyAdmin) de Duración hora minuto segunda en buena calidad , que subió el usuario TechProgrammingIdeas 20 febrero 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 2,234 veces y le gustó 8 a los espectadores. Disfruta viendo!
