man this helped me a lot.. i have been having problem with mysql database installtion and i did not get any clear video on this topic. and this video pops up in my feed which is crystal clear, concise. thank you very much
Hi @ProgrammingKnowledge ! I don't know who you are and where you're from, but I really want to thank you for the very concise and to the point instruction !! I spent many hours going through mySQL documentation and still couldnt do it properly. I've hit the like and subscribe button, please keep doing what u do!!!
ERROR: snap "mysql-workbench-community" is not available on stable for this architecture (arm64) but exists on other architectures (amd64). How to fix this problem....
my connection doesn't work, all i receive is a user interaction error? I followed all the steps and I am even using chatgpt to help but nothing is My version: ;Server version: 8.0.35-0ubuntu0.22.04.1 (Ubuntu)
When i am running sudo systemctl start mysql.service then i get following error Error:- system has not been booted with systemd as init system(PID 1). Failed to connect to bus:host is down Please send me solution for this error
At the password validation stage, i entered yes and selected password medium strength 2. Then the system said "Skipping password set for root as authentication set for auth_socket by default. If you would like to use password authentication, use the alter user command." How do I go about this. I have been unable to set a password and I don't have the default password.
Installed successfully and worked fine for the first time. After restart showing the error: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" Plz help...
Using this command in MySql Monitor it will work SET GLOBAL validate_password.policy = LOW; Also check how the password should be according to the policies using SHOW VARIABLES LIKE 'validate_password%'
one thing i would skip was that part where it return error, because then i had to guess what password to type in, and the many questions popped when it did not on your video besides that thank you ps. i typed in root when it wanted password
when i am running "sudo snap install mysql-workbench-community" command @10:13 then i am getting following error error: cannot perform the following tasks: - Run configure hook of "mysql-workbench-community" snap if present (run hook "configure": cannot locate base snap core22: No such file or directory)
After installation i am getting error in the place of giving password it was showing like cannot connect to database server How can I resolve this problem
@@jordanholmes6814 After installing the workbench when i click on the local instance 3306 it gives me the error Access denied for user 'root'@'localhost' can you pleasee help me solve this error
man this helped me a lot.. i have been having problem with mysql database installtion and i did not get any clear video on this topic. and this video pops up in my feed which is crystal clear, concise. thank you very much
concise and to the point...just what is needed and just what most of these tutorials lack!
Hi @ProgrammingKnowledge ! I don't know who you are and where you're from, but I really want to thank you for the very concise and to the point instruction !! I spent many hours going through mySQL documentation and still couldnt do it properly. I've hit the like and subscribe button, please keep doing what u do!!!
One of the best instructor I have ever seen. Sir whoever you are , You are doing a great Job.. Thanks for such amazing channel
ERROR: snap "mysql-workbench-community" is not available on stable for this architecture (arm64) but exists on other architectures (amd64). How to fix this problem....
Hi can you explain below topic pls
1)Binary installation steps.
2)Backup Strategy before upgrade.
3)Mysql upgrade 5.5,5.6,to 5.7 steps.
hey i am getting problem with that root command it would deny my access, do you know how to fix that?
The best tutorial for installation guide of mySql server in Ubuntu. very easy and step by step. Thanks for creating this tutorial.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
I kept having this error - ERROR 1819 (HY000): Your password does not satisfy the current policy requirements............. pls what do I do?
thanks man when i decided to skip ubuntu forever ,this video popped out
my connection doesn't work, all i receive is a user interaction error? I followed all the steps and I am even using chatgpt to help but nothing is
My version: ;Server version: 8.0.35-0ubuntu0.22.04.1 (Ubuntu)
i have already try this trick but it's not working trick.
it's showing mysql not found in command
I got this after installing the mysql-server :----
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
same
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Thanks brother it's really work 😊@@jordanholmes6814
When i am running sudo systemctl start mysql.service then i get following error
Error:- system has not been booted with systemd as init system(PID 1). Failed to connect to bus:host is down
Please send me solution for this error
what distro you use?
At the password validation stage, i entered yes and selected password medium strength 2. Then the system said "Skipping password set for root as authentication set for auth_socket by default. If you would like to use password authentication, use the alter user command."
How do I go about this. I have been unable to set a password and I don't have the default password.
The ALTER USER 'root' @'localhost' IDENTIFIED WITH mysql_native_password BY 'new password' is not working. It just moves to a new line
I have a problem is saying :
Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
Same problem .....
Installed successfully and worked fine for the first time. After restart showing the error:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
Plz help...
same
ky kre any solution
Thanks everthing in working after setups followed !!
Muchas gracias. Está tam bien explicado que hasta sin saber mucho el inglés pude hacerlo.
Thank you so much!! you brought back light in my life!! I was so stuck!
😁😁😁 it was dark is it?
@@chiunamagesa3808 very!
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
I solved my problem using UNINSTALL COMPONENT 'file://component_validate_password';
Me too
Using this command in MySql Monitor it will work SET GLOBAL validate_password.policy = LOW;
Also check how the password should be according to the policies using
SHOW VARIABLES LIKE 'validate_password%'
@@Xdenderman_1113 are you sure ?
snap work bench is gettting error for some systems check once bro
Broo its showing --- unabyto locate pakage mysql-server
great video sir .But how to initialize data directory for mysql 8.0....? or How to change default directory mysql 8.0....?
that setting is in /etc/mysql/mysql.conf.d/mysqld.cnf file
can you stop writing commands below the screen area? :/
Great detailed tutorial, that was awsome
straight forward, thank you!
When i used Alter user with root password...it was showing error that your password doesn't satisfy the current policy requirements
Try using dificult password
E: Package 'mysql-server' has no installation candidate
Great tutorial, and workbench is also great, I am new to it. thank you so much.
one thing i would skip was that part where it return error, because then i had to guess what password to type in, and the many questions popped when it did not on your video
besides that thank you
ps. i typed in root when it wanted password
Thanks for the detailed video.
Done. Very helpful. Thank you!
how do get my project to accept "gem mysql 0.5. 5"
Hey thank you. I was going to comment under the previous video.Please, for Ubuntu to do MySQL...🎉
Very helpful, thank you!
when i am running "sudo snap install mysql-workbench-community" command @10:13 then i am getting following error
error: cannot perform the following tasks:
- Run configure hook of "mysql-workbench-community" snap if present (run hook "configure": cannot locate base snap core22: No such file or directory)
thank you very helpful!
Thank you guys , you by helped verynow
Thanks for the video. It worked great.
thank you very much. I was pulling my hair out. Now I have to figure out why Workbench did not find running sqlserver. Maybe the port # is incorrect.
No SQL server on ubuntu 22.04.
great video man, thank you!
Thanks man! Its working
Really usefull video, saved me a lot of time!
Great!!!!!Thanks so much!
Wow, this video is very helpful 💥
thank you so much you just earned a new sub!
Thanks mate u helped me so much
really helpful
Awesome, thank you
work fine, ty
Thank you !
THANK YOU VERY MUCH!!!!!
thank you sir
thanks a lot, man
thank you so much
Perfect Thanku
Thank you very much ♥♥
Thank you so much
thank you broo
network connect nhi ho raha hai
thank you bhai
Thanks a lot for this tutorial. It's very helpful 🥲
much love tyvm
thank you
After installation i am getting error in the place of giving password it was showing like cannot connect to database server
How can I resolve this problem
I am getting the same error, did you get a solution for that?
did any of you find a solution? i'm having the same problem @dhanusree-123 @devyanshgarg6156
Thanks
Gracias bro
great 😀
👍
Security Config
I just wished Linux looked better and felt less sluggish.
Negawat
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
thanks
@@jordanholmes6814 After installing the workbench when i click on the local instance 3306 it gives me the error Access denied for user 'root'@'localhost' can you pleasee help me solve this error
Awesome work
Thank you very helpful!
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Thank you !
thanks a lot 😍