How To Connect MySQL To VsCode.. (For Windows)

Learn how to get mysql hooked to vscode and kill some bugs while you're at it👌🏾..
Install MySQL
🔗 dev.mysql/downloads/installer
Create User jess_i
CREATE USER IF NOT EXISTS jess_i@localhost IDENTIFIED BY 'password';
Grant All Privileges to Jess_i
GRANT ALL PRIVILEGES ON . TO 'jess_i'@'localhost';
Create User With Native Password Authentication
CREATE USER IF NOT EXISTS 'jess'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Grant All Privileges to Jess
GRANT ALL PRIVILEGES ON . TO 'jess'@'localhost';
🔗 Hi there🙂👋🏽, Connect with me on LinkedIn
/ jesse-braide-4a2235243

[@faridamomoh3477]

Thank you so much Jesse. So easy and straight forward.

[@jess-inspired]

Glad it helped you💯

[@onwunzoamara]

This was quite helpful... Jess inspired, always the 'go-to' place.

[@jess-inspired]

💯

[@leosmart244]

Thanks man... This is the best video I've found so far on connecting to the mysql database. I really appreciate this one

[@jess-inspired]

Always a pleasure to be of help

[@onwunzoamara]

Thanks Jesse, I've been looking for a way around this.

[@jess-inspired]

Always a pleasure to help..🙌🏾

[@victornwosu5252]

Thanks for this Jess, saved me a lot of research time.

[@jess-inspired]

You're welcome bro💯

[@niranjansai7832]

thanks man so helpful🤘🤘

[@jess-inspired]

Much appreciated 🙏🏾

[@slimysnail6071]

Error opening connection self signed certificate in certificate chain
I had a 'ssl' option with 'disabled' or 'enabled'(with a lot of set up), I chose enable.. But I am not seeing any SSL option in your video.. Plz help

[@ayushsingh6435]

Soooo Helpful

[@jess-inspired]

It's a pleasure 💯

[@mustaphamohammed8537]

Can you please do same for php?

[@Steve-zw1yh]

Could you help test connection is not suported_auth_mode. Client not supported.

[@SurajKumar-ku1lg]

Same problem

[@jess-inspired]

Sorry for the late reply..
If you're yet to get it fixed..
You can run in your mysql shell..
ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
N/B: Go ahead and change 'username' with your specified username and 'password' with yours. You can have an empty string for password if you don't want any..
Hop this helps..

[@Steve-zw1yh]

@@jess-inspired thanks a lot

[@user-fv8or4my6v]

@@jess-inspired how to run in the shell..

[@abcd-rm6zp]

Hii,
I am Sargam from India . I recently started doing works on Ubuntu and now i need to set up my "MySQL Database " in V.S.Code on it and I don't know how these would be done. Can anyone help me to fix out this issues . It's my pleasure that you would help me or you can suggest me a RUclips link.

[@jess-inspired]

Hello.
You can try out this article from digital ocean
www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04
Hope it helps. Also sounds like a great idea for a video. Cheers