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
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!!!!!
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
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
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
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!!!!!
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
This video has been a great help. I can't thank you enough! Here to support your future workings.
Clear and easy to follow. Thank you!
great video, such a clear explanation !!
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.
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 RUclips & Agriculture Farming Currently. I Was a Engineering College Drop Out.
thank you so much it worked so helpful ❤❤
good vedio vary help full for me
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.
this is really helpful
Your videos are so helpful ❤
Thank you
Very good tutorial, thank you!
Thank you so much brother!!!
Thankyou bro ❤😊
Hi bro! What can I do about active connection in VSCode??
That was helpful, thank youuu
You're welcome!
This video was very helpful
Thank you very much
Your videos are so helpful
This video helps me alot bro 🤜🤛
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
Can you please tell how we can import csv file data into this vs code extension of mysql
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
Hi, thx its helpful
But can you make git bash as the administrator to run the mysql in gitbash instead of powershell?
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
this literally solve all my problems
Awesome.
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.
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 ?
it saved my time thanks bro
Amazing
Thanks!
Thank you a lotttt
can you do C++ connection with sql using Visual Code Studio?
bro it worked like magic
Yes it does.
Thanks
Thanks bro. U good
Thankyou ❤
How do you create a new database on the side panel from vscode
thank you soo much!!
Access denied for user 'root'@'localhost' (using password: YES), (how to fix this) :)
pleaseee
when i press the + to create new mysql connection, nothing happens
thanks
Where are the links ?
100000 LIKES DUDE!!!!!!!!!!!!!!!!!! Succinct 🙌🙌🙌🙌🙌🙌🙌🙌🥂🥂🍻🍻🥂🥂🍻🍻⭐⭐⭐⭐⭐⭐
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 👍
Bro, the installer of package give me problems
it's not working for me, I tried this several times already
why i dong have developer option?
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
Why am I not getting server in my MySQL folder
Neither I am getting Developer option
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
YOU ARE GREAT!!!!!!!!!!!!!!!!!!!!!
Fatal error : uncaught error: Class "mysqli" not found 😢, hooowww
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
best
How can I get the initial link?
Initial Link ?
I cant create user
where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr
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 ?
@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!
😊
I'm seeing no active connection found
Make sure the MYSQL server is running in the background
❤
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
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