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....
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
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)
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%'
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...
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!
One of the best instructor I have ever seen. Sir whoever you are , You are doing a great Job.. Thanks for such amazing channel
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!!!
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.
The best tutorial for installation guide of mySql server in Ubuntu. very easy and step by step. Thanks for creating this tutorial.
Thanks everthing in working after setups followed !!
thanks man when i decided to skip ubuntu forever ,this video popped out
straight forward, thank you!
Great detailed tutorial, that was awsome
Great tutorial, and workbench is also great, I am new to it. thank you so much.
Very helpful, thank you!
great video man, thank you!
Thanks man! Its working
thank you very helpful!
Thanks for the detailed video.
Done. Very helpful. Thank you!
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....
Muchas gracias. Está tam bien explicado que hasta sin saber mucho el inglés pude hacerlo.
Really usefull video, saved me a lot of time!
Thanks for the video. It worked great.
Thank you so much!! you brought back light in my life!! I was so stuck!
😁😁😁 it was dark is it?
@@chiunamagesa3808 very!
Wow, this video is very helpful 💥
Thank you guys , you by helped verynow
thank you so much you just earned a new sub!
Thanks a lot for this tutorial. It's very helpful 🥲
Great!!!!!Thanks 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 mate u helped me so much
hey i am getting problem with that root command it would deny my access, do you know how to fix that?
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
thanks a lot 😍
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Awesome, thank you
Hey thank you. I was going to comment under the previous video.Please, for Ubuntu to do MySQL...🎉
Thank you !
really helpful
THANK YOU VERY MUCH!!!!!
work fine, ty
snap work bench is gettting error for some systems check once bro
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.
thank you so much
Perfect Thanku
I kept having this error - ERROR 1819 (HY000): Your password does not satisfy the current policy requirements............. pls what do I do?
thank you sir
much love tyvm
Thank you so much
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)
thank you broo
i have already try this trick but it's not working trick.
it's showing mysql not found in command
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 ?
thank you
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
thank you bhai
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
can you stop writing commands below the screen area? :/
Broo its showing --- unabyto locate pakage mysql-server
E: Package 'mysql-server' has no installation candidate
Thanks
Awesome work
Gracias bro
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
great 😀
how do get my project to accept "gem mysql 0.5. 5"
No SQL server on ubuntu 22.04.
network connect nhi ho raha hai
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)
👍
Security Config
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
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
Thank you very helpful!
thanks a lot, man
Thank you !
Thank you very much ♥♥
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';