mysqli_real_connect() (HY0001698) Access denied for user 'root'@'localhost'

mysqli_real_connect() (HY0001698) Access denied for user 'root'@'localhost'
#1698 - Access denied for user 'root'@'localhost'
Cannot enter phpmyadmin as root (MySQL 5.7)
phpmyadmin #1698 - Access denied for user 'root'@'localhost'
mysqli_real_connect(): (HY000/1698): Access denied for user

Login to MySQL
sudo mysql -p -u root

CREATE USER
CREATE USER 'admin'@'%' IDENTIFIED BY 'admin4321';

GRANT ALL PRIVILEGES
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;

[atilafj]

Thank you, you saved my life. Such a simple solution, I've been looking for this solution for days. Thanks again

[krd]

Thanks mate, this has been driving me crazy looking for a solution, well done, good job

[luiscordero]

Gracias, despues de pasar todo un dia tratando de configurar este mysql... con este tip lo logre

[loujohnboss]

Looked on a lot of forums and you finally saved me thanks a lot!!!

[darcio]

você foi o cara mais foda do role ate agora man, nao sei se vc sabe ler isso mas tamo junto meu parça.;....

[michelmagloireekanga]

I thank you for your most help at this opportune time. Good may bless you forever

[humansofgojalhumansofgojal]

thank you for a such great video ...i am new ubuntu user .i found this video great and really helped me to login phpmyadmin..

[nanangwahyudi]

Thank you very much. It really helped me, after searching on the internet

[navneetsharma]

Thank you boss... 🤩🤩 I was very frustrated to solve this issue.. but when i try your video. I got serprize.. thanks a lot man

[anbuganeshkannan]

Thank you so much, Love you da chellam

[Trance_Code]

Muchas gracias, Work good bro, thanks from Chile!!!

[omareliotorrescastillo]

Thank you very much, it worked for me, greetings from Mexico!!!

[sergioboronat]

Gracias, soy novato en Linux y me ha ayudado.
Un like para ti :)
Para salir = mysql> exit;

Thx soo much for the tutorial!

[josphatnjoroge]

Much blessings. It has helped me a great deal

[narendrasubramanya]

Thanks a lot for the video. I tried the same with the root and the error was "ERROR 1133 (42000): Can't find any matching row in the user table". What might be the problem? and then I created a new user as you stated in the video.

[cerutti]

Thanks <3 the only tutorial with Ubuntu 18 that worked

[vlogsisita_deepmind]

what a heel man, i try with all videos in youtube, you save my life bro, im now subscribe and like your video, thanks a lote,

[johnezeoha]

this is the error i get after trying to login following your example "mysqli_real_connect(): (HY000/1045): Access denied for user 'Admin01'@'localhost' (using password: YES)", please help

[richardzhang]

Thank you very much. It works for me. Great thanks!!!!

[aztecsavo]

and as a root user it is not possible to login? I don't need to create a user any suggestion or help? thanks greetings!