Install MySQL 8.0.28 on Linux Ubuntu 20.04LTS [Step-by-Step]

Sir it is giving me this error even when I'm reinstalling it
Skipping password set for root as authentication with auth_socket is used by default.
If you would like to use password authentication instead, this can be done with the "ALTER_USER" command.

you got one sub today :P

sir the siftware installationwas upto the point but honestly ...the issue was after importing a prepared sql file...i did used Create databases;---> but i do not know when the time came for reading tables ..that was in .sql file it failed

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

very clean installation,
thanks

Thank you so much!!

help; tried installing different versions after cleaning the old one still getting same problem; there is no file on the
following path in the error; and when using command : sudo find / -type s: I can't find the .sock file of mysqld so kindly help
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

amazing clarity

Your video is superb. Thank you very much, just one issue, I am trying to install MySQL on Ubuntu Server 22.04, and I keep on getting this error message even after following your steps. ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. Please could you comment on this issue? Thanks

I have trouble error 2002

Can the same process works for mysql5.7 where i have to install in ubuntu 18.04 where architecture of server is aarch64.

Remarkable Job! Thank you very much!

thakyou

Awesome thank you! Liked and subscribed

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) -- I could change password trough this command line inside sudo mysql( ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'newpassword' ) I could set a new password, but when I tried to get access again to mysql trough sudo got this error ERROR 1045 (28000) why?

Very helpful, thank you!

very nice and simple video, Thank you Sir

Thank you very much sir. You explained it very clearly.

thank you bro! much love

Nice one... I am officially your student.

hello there thnx for this video but when I am trying to login this error gets popped up pls help me if you can @PnTutorials by Pradnyankur Nikam
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'newpassword';
ALTER: command not found
harsh@harsh-virtual-machine:~$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
harsh@harsh-virtual-machine:~$
harsh@harsh-virtual-machine:~$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'newpassword';
ALTER: command not found

Sir, after typing sudo apt update this is what am getting
Reading packaging lists...Done
Building dependency tree
Reading state information...Done
5 packages can be upgraded. Run 'apt list--upgradable' to see them.

God bless u

root acces denied solution

Sir after installation my gui of Ubuntu is gone please help

hi bro, thanks a lot subscribed :)

It's amazing bro , I never expected such a premium explanation, from a video having less views.

Nice tutorial

... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. showing this after pressing y confirms change of password

i'm getting this error after after the password status => ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.

Thank you so much sir…..nicely done

Man I am so glad i watched your tutorial !!!! Thank you so much. First I watched your video how to uninstall mysql and then i followed this one. Believe me, finally sign of relief.

Sir, I have selected strong length password which causes error. I want to change it into low length password. But there is no options ... again. only type your password option

mysql -u root -p instead of sudo mysql >>> newer versions

Great help! Thanks!

I still got some erros but I just googled and solved them. Perfect tutorial, should get way more views.

hi, when I try to set the password for the mysql_secure_installation it appears "...FAILED! Error SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters." How do I fix it?

thank you dude I was pissed I couldn't configure a connection

hey bro, thank you for this tutorial

how to download mysql workbench