I was struggling with the authentication problem in general. I just randomly clicked just like other videos with no expectations that if it could fix my problem but you just nalied it. Finally I can do my work on sql, Huggggggggggggge thanks brother
if still after entering 33060 the error is showing up then install mysql community server from google and then setup it in your terminal or cmd and then come here and type the name of database as - information_schema
OMG you saved my life!!! Thank you so much! I've been trying to find out on how to resolve this problem for days and now I can start to learn SQL. THANKS A LOT!!!!!
Why the terminal doesn't recognize mysql --version? I already add that address on local disk C (ex: C:\Program Files\MySQL\MySQL Server 8.0\bin) to Path on Environment. How do I fix that thing??
This Helps a lot, but when we already have a SQL file , we are not able to use that using this method, this only works when we do the new query after right clicking on the database in vscode, any workaround for this, I have even done use databasename and select database() ---> this is giving me null as result. please help on this.
This is the format of the MYSQL commands to create a new user: *CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';* then grant all privileges by running this command: *GRANT ALL PRIVILEGES ON * . * TO 'USERNAME'@'localhost';* and lastly run *FLUSH PRIVILEGES;*
@5.25 - I am getting this error message in the terminal: "The term 'mysql' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again." Any idea what I'm doing wrong? Cheers!
i installed my sql and click + button the occurs this error massage "Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection." why and how should i overcome this
@@kskroyaltech "Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection." mysql. This error is such a a pain
create user 'root' @'%' identified with mysql_native_password by 'admin'; ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded plss help i am stuck here and cant move forward
![How to Install MySQL 8.0.39 Server & Workbench on Windows 10/11 [2024 Update] | Install MySQL 8.0.39](http://i.ytimg.com/vi/70VxsCC28yc/mqdefault.jpg)
I was struggling with the authentication problem in general. I just randomly clicked just like other videos with no expectations that if it could fix my problem but you just nalied it. Finally I can do my work on sql, Huggggggggggggge thanks brother
Brooooo you’re the greatest man I’ve been trying this for months. Big ups man just followed, God bless
Super .and thank you so much
It shows error 1049 (42000) : unknown database 3306
solution?
Instead of using 3306 use 33060 to create local host port
if still after entering 33060 the error is showing up then install mysql community server from google and then setup it in your terminal or cmd and then come here and type the name of database as - information_schema
OMG you saved my life!!! Thank you so much! I've been trying to find out on how to resolve this problem for days and now I can start to learn SQL. THANKS A LOT!!!!!
This video has been a great help. I can't thank you enough! Here to support your future workings.
Why the terminal doesn't recognize mysql --version?
I already add that address on local disk C (ex: C:\Program Files\MySQL\MySQL Server 8.0\bin) to Path on Environment.
How do I fix that thing??
Close the terminal and reopen and try again.
Clear and easy to follow. Thank you!
great video, such a clear explanation !!
Thank you. I wonder what do you do for a living. You kinda manage a bunch of skills that making me a little bit worship.
Just UA-cam & Agriculture Farming Currently. I Was a Engineering College Drop Out.
THANKS ALOT SIR YOU MAKES A GREAT PINPOINT SOLUTION VIDEO. THANKS MAN
Man, I love your voice! You're just a Chez from Metal Family!
Wow, thank you.
this is what I was looking for exactly, thank you!
Thank you. Excellent tutorial with successful set up.
I tried your steps but while installation , its not showing developer default mode ,
video time-1:43
yes even it did not showing to me
7:50 at this moment after entering localhost root password and everything the localhost database is not showing
Even I am facing the same issue, did you get the solution for this
7:40 I entered the username, password, localhost... and the database is just not showing at all. Like nothing appens. Pls help me !
Same error, did u find the solution ?
Your videos are so helpful ❤
Thank you
thank you so much it worked so helpful ❤❤
good vedio vary help full for me
Hi bro! What can I do about active connection in VSCode??
This Helps a lot, but when we already have a SQL file , we are not able to use that using this method, this only works when we do the new query after right clicking on the database in vscode, any workaround for this,
I have even done
use databasename and select database() ---> this is giving me null as result.
please help on this.
this is really helpful
Very good tutorial, thank you!
Can you please tell how we can import csv file data into this vs code extension of mysql
Hi, thx its helpful
But can you make git bash as the administrator to run the mysql in gitbash instead of powershell?
Your videos are so helpful
How do you create a new database on the side panel from vscode
This video helps me alot bro 🤜🤛
That was helpful, thank youuu
You're welcome!
After Enter password, in terminal its shows error 1049 unknown database 3306
Same problem bro
@@abhinavrnarayan did you find solution,? I m moved on workbench
@@nagarajk3309 no bro I'm also using workbench rn
mysql -h localhost -P 3306 -u root -p.........(before entering the port number its capital 'P' not a small one try checking this)
@@akshitrawat3903 thank you 👍
This video was very helpful
Thank you very much
Thank you so much brother!!!
when i press the + to create new mysql connection, nothing happens
thank you, so helpful
You're welcome!
Great video!! Amazing font bro, could you please me which it is?
Monaco or Avnier next.
Nope, it's neither, I later found out it is Anonymous Pro. Please check properly and lemme know
Thankyou bro ❤😊
can you do C++ connection with sql using Visual Code Studio?
Access denied for user 'root'@'localhost' (using password: YES), (how to fix this) :)
pleaseee
it saved my time thanks bro
Amazing
I've done all the steps. But on vscode, i do the localhost username and password but after clicking enter nothing happens. Please help me if you can
Make sure the MY SQL Server is running and try again.
how do you make sure it's running tho?
@@kskroyaltech
For some reasons localhost database isnt showing on my vscode and i dont know why is that
Which VSCode extension you are using the one I mentioned ?
@@kskroyaltech hey it worked today i dont know how but it did😅 thanks alot
Bro, the installer of package give me problems
it's not working for me, I tried this several times already
While creating a new user it shows "SyntaxError: Unexpected identifier 'user'"
This is the format of the MYSQL commands to create a new user:
*CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';*
then grant all privileges by running this command:
*GRANT ALL PRIVILEGES ON * . * TO 'USERNAME'@'localhost';*
and lastly run
*FLUSH PRIVILEGES;*
thankyou@@kskroyaltech
@5.25 - I am getting this error message in the terminal: "The term 'mysql' is not recognized as the name of a cmdlet, function, script file, or operable program. Check
the spelling of the name, or if a path was included, verify that the path is correct and try again." Any idea what I'm doing wrong? Cheers!
Make sure mysql is installed on your computer and you added its install path to the system environment ..
@@kskroyaltech This is where I screwed up, I didn't correctly add the path to the env. Cheers!
😊
this literally solve all my problems
Awesome.
Why am I not getting server in my MySQL folder
Neither I am getting Developer option
Fatal error : uncaught error: Class "mysqli" not found 😢, hooowww
Thanks bro. U good
bro it worked like magic
Yes it does.
why i dong have developer option?
Hi bro
At 5:45 when i enter password it shows me unknown database 3306 error could you please answer it if possible
same problem here. Did you sorted the issue ?
Thank you a lotttt
thank you soo much!!
How can I get the initial link?
Initial Link ?
Thanks!
where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr
100000 LIKES DUDE!!!!!!!!!!!!!!!!!! Succinct 🙌🙌🙌🙌🙌🙌🙌🙌🥂🥂🍻🍻🥂🥂🍻🍻⭐⭐⭐⭐⭐⭐
Where are the links ?
Links to ?
Thankyou ❤
I'm seeing no active connection found
Make sure the MYSQL server is running in the background
I cant create user
Thanks
thanks
best
❤
i installed my sql and click + button the occurs this error massage "Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection." why and how should i overcome this
Which extension you are using ? at 7:03
@@kskroyaltech
"Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection."
mysql. This error is such a a pain
YOU ARE GREAT!!!!!!!!!!!!!!!!!!!!!
create user 'root' @'%' identified with mysql_native_password by 'admin';
ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded
plss help i am stuck here and cant move forward