Install MySQL (MySQL Server) on your Ubuntu 22.04 LTS

In this video i have shown how you can download and install MySQL(mysql-server) on your ubuntu operating system specific on Ubuntu 22.04 LTS or 20.04 LTS or any newer version of ubuntu operating system. I have also shown how to fix the issue To fix Access denied for user ‘root’@‘localhost’ while opening mysql using mysql -u root -p.

Commands Used :
==============
sudo apt update
sudo apt-get install mysql-server

To check the version :
mysql - -version

To fix Access denied for user ‘root’@‘localhost’

sudo mysql -u root -p
show databases;
use mysql
update user set plugin=‘mysql_native_password’ where user=‘root’;

flush privileges;

Then finally Type :
mysql -u root -p

To create database :
create database demo;

Check all the available databases :
show databases;
==================================

Stay Connected :

Join Community :

Follow me on :

#CodeWithArjun #Programming

[lavender]

if u face this error [ERROR 1054 (42S22): Unknown column '‘root’' in 'where clause'
mysql> update user set where user='root';] its because of '‘root’' got different qoutes. so in order for you to fix either type the script by keyboard or use this one. update user set where user='root';

[ShakeelKhan-pzzl]

Nice, simple, to the point, and concise but complete.
Appreciate that bro...

[lilybuisset]

Perfect video, solved all my problems and saved me so much time

[IamDoQtorNo]

Howdy. Great instructions, easy to follow thanks a million. Now that i have it installed, how do I go about moving it to my second 1TB hard so that I can store all my databases there? Do you have a video that covers that? My installing nvme ssd is being used for system data only

[RanjitAdhikari-phy]

easily solved my problem, perfect video

[diogoteixeira]

Right to the point and it worked! Thank you.

[MrTANAPS]

I'm new in Ubuntu and Linux. So the file is already in the system? It's just a matter of install it? You don't need to download it?

[MuhammadMansha-bcpj]

E: Unable to locate package mysql-server?

[suryansh]

because of people like u who thinks these things may help others people like me survive thanks bro from heart❤

[mssphanichandra]

here what is the password should we use in last step when it is asking for password

[easylearning]

When I run this command in WSL it says unable to locate the package and its not installing it

[ParagBadhan-tbjy]

I have followed all of your processes shown on the video, but after writing the final command (mysql -u root -p) it still says "Access denied for user 'root'@'localhost' (using password:Yes).Please help me in finding the solution.

[mxbkfqs]

ERROR 1054 (42S22): Unknown column '‘root’' in 'where clause'

[Sam_sept]

my problem "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"
still exist what to doo?

[mohammedraheelpatel]

Showing :- Error 2002 (HY000) : Can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2). How to solve this issue??

[lemol]

3:00 i have ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) help me plz

[kuhopnv]

not found its showing
not working trick

[emmanouildrosopoulos]

when i use mysql -u root -p at 3:04 i got this ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) i dont know what am doing wrong any idea ?

[jakescott]

You don't need that part with passwords, do you? I only installed mysql and it works with 'sudo mysql' ...

[SATISHKUMAR-eemg]

sudo mysql -u root -p - i m not getting error again after entering this command . Error - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)