Install MySQL (MySQL Server) on your Ubuntu 22.04 LTS
ฝัง
- เผยแพร่เมื่อ 18 ธ.ค. 2024
- 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;
==================================
PayPal : paypal.me/code...
Patreon : / codewitharjun
➡️ Subscribe : / codewitharjun
Stay Connected :
➡️ LinkedIn : / arjungautam1
➡️ Github : github.com/arj...
Join Community :
➡️Discord : / discord
Follow me on :
➡️ Medium: / codewitharjun
➡️ Dev.to : dev.to/codewit...
#CodeWithArjun #Programming
if u face this error [ERROR 1054 (42S22): Unknown column '‘root’' in 'where clause'
mysql> update user set plugin='mysql_native_password' 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 plugin='mysql_native_password' where user='root';
same
While doing the copy paste of the command from the description , manually type the inverted commas . It will work
thanks mate, it worked
Shortest and most precise guide on install MySQL on Ubuntu 👏👏
Glad you think so!
Nice, simple, to the point, and concise but complete.
Appreciate that bro...
Glad it helped
3:00 i have ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) help me plz
I got the same error
I remove and reinstall the mysql, then did 1. sudo service mysql start 2. mysql : which shows 1045 error 3. mysql -uroot -p : which shows 1698 error 4. sudo mysql -uroot -p : it works.
@@MSEEchen reinstal all vps helped me
@@lemol4938what is vps and how can i remove and reinstall all of em?
Thank you very much for the fix. I have searching for hours on how to fix the password issue.
Glad it helped!
my problem "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"
still exist what to doo?
Same issue but password: No can your issue resolved
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.
when you enter the password just press enter, don't put anything
I have the same issue...can someone resolve?
@@Sriiiiii start with sudo
When I try mysql -u root -p, I keep getting "'ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)". Everything worked fine up until that point. Anyone know how I could fix this?
Perfect video, solved all my problems and saved me so much time
because of people like u who thinks these things may help others people like me survive thanks bro from heart❤
Means a lot. Keep coding
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 ?
can you explain how did u solve it?
Same here
sudo mysql
E: Unable to locate package mysql-server?
here what is the password should we use in last step when it is asking for password
Thank you very much 🙏🙏🙏
You saved me at the last
The Error occured is
Package mysql-server-8.0 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
mysql-server-8.0
mysql-server
Please Help
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
Right to the point and it worked! Thank you.
Glad it helped!
When I run this command in WSL it says unable to locate the package and its not installing it
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?
ERROR 1054 (42S22): Unknown column '‘root’' in 'where clause'
Thank you so much sir for your help
Always welcome
easily solved my problem , perfect video
Thanks, how to start the database?
You don't need that part with passwords, do you? I only installed mysql and it works with 'sudo mysql' ...
yeah that part isnt here
How to make it like an app?
is this secure for deployment ?
Simple and helpful 👌🏻
Glad it was helpful!
thank you so much sir. it worked.
How to lunch sql workbench
perfect simple and to the point
Keep up the good work brother
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)
i'm still getting error after using password: YES
what I'm I doing wrong?
i swear these people make wrong tuts just to fuck with people
Do not enter any password, just press enter . Hope that helps
Thanks zombie-@@braineaterzombie3981
not found its showing
not working trick
Thank u so much brother
Welcome
thank you, it worked!!!
Its working thank you
nepali coder bro
Thank you
Great!
Good job!
Thanks!
i fucking love you!
hey can I have moderator on your server, there are abusers in chat and I need to fix them.
my username is "a good moderator"
Showing :- Error 2002 (HY000) : Can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2). How to solve this issue??
same
Thank you so much!!!!
Glad it helped!