How can I access the MySQL command line with XAMPP for Windows? - SOLVED

[@OstonCodeCypher]

Please guys you will forgive me for the silly mistake I made in the video. You don't need to put your password after -p. Only enter the password when you are prompted to do so. Syntax:: mysql -u root -p -h 120.0.0.1 Then Enter Password.

[@zygotedermechatronik3448]

Thank you very much for this reminder. It is awesome. Far back in school I simply wrote the commands our teacher showed us without even understanding. But now years after graduation I want to relearn MySQL and after installing Xampp, I could not remember how to enter Maria DB. And your tutorial just saved me.

[@tefie00]

i'm having a hard time setting up my xampp awhile ago and i really thank you for this. it help me a lot

[@OstonCodeCypher]

You are welcome. I wish you all the best 👍

[@KampirePamella]

Finally I found a Uganda with IT tutorials 👍 good work Oston

[@OstonCodeCypher]

Thanks very much. I am glad you liked the tutorial. ALL the best 👍

[@pamellakampire3584]

You're welcome

[@salindasandaruwan1872]

Finally this video showed how to do it. I was struggling.

[@melaniescrybaby8382]

Thank you so much! I forgot how to use this because it’s been 3 years since the last time i did database and you help me a lot!

[@OstonCodeCypher]

Am glad it helped out. Stay blessed and thanks for watching

[@nm56342]

Very useful and straight to the point. You should do more videos.

[@tweteisepeter8183]

Thank you man, the lecturer actually wanted us to use wampserver since it uses cmd line yet I have xampp installed on my system.

[@OstonCodeCypher]

Am glad that it helped... nice coding & hope you learn more from the channel

[@castlejayce5505]

God thank you so much, been having a problem setting up mysql in cmd, my friend said because i use c drive in installing the xampp but i only have c drive because my pc is not capable having more than one ports

[@OstonCodeCypher]

Am glad it helped friend. Incase you don't want to follow those steps every time you want to connect to MySQL. Watch this batch tutorial:: kzbin.info/www/bejne/m5-onIuAh9d9arM

[@sanjaip7962]

Thanks for ur explanations about accessing the server with windows Cmd , this video helps me really. Keep doing videos 👍

[@OstonCodeCypher]

Am glad it you friend, incase you don't want to follow the same process every time you want to access the MSQL shell. Watch this tutorial:: kzbin.info/www/bejne/m5-onIuAh9d9arM

[@mr.positive4569]

Devru guru neenu❤️

[@kumarbunny7283]

Nija guru

[@fryingpan5431]

Thank you so much I've had so much trouble trying to sign in this was perfect!

[@OstonCodeCypher]

You r welkam,thanks 4 watching 👑👊👍

[@hanizulhilmi570]

Thank you mr. That print trick sure was helpful

[@OstonCodeCypher]

Glad it helped, thanks for watching

[@souvikrakshit232]

Thanks...Do I need to do that everytime when I try to open mysql through command prompt.

[@OstonCodeCypher]

Yes bro....but with time trust me u will get used to it. 👍

[@souvikrakshit232]

Oston Code Cypher Thank you...

[@hooriafatima-bf1ot]

What should I do when I couldn't find bin in mysql???

[@OstonCodeCypher]

What are you using Xampp or Wamp???

[@prossygwokyalya5128]

Thank you for this my head was soon bursting

[@OstonCodeCypher]

Am glad it helped, here is tutorial:: kzbin.info/www/bejne/m5-onIuAh9d9arM to save you from following the same process every time you need to use the command line.

[@devangperiwal4031]

I never set a password and I always typed -p in the cmd. Finally able to deal with it. Thankyou

[@chandansharma324]

Love From India ❤️🔥

[@sitiaishahnoor6964]

hi, Thank You for your tutorial very helpful. But i will already try on my laptop but when i enter it's say can't connect my sql server. Can i know how to solve this problem ? thank You

[@OstonCodeCypher]

What are you using XAMPP or WAMP

[@adityadeshmukh1689]

Thanks for helping me out!

[@OstonCodeCypher]

You r welcome, glad it helped

[@muhammadmustafa1353]

Very thanks through your lecture about how to connect with database mysql.

[@jitendraruley]

Thank you very much i have been thinking about it and now i get solution from your video thanks Man.

[@OstonCodeCypher]

Thanks for watching Jitendra..👍👑 Hope you learn more from the channel.

[@sanjeevshirsate7760]

Xampp not reconginzed internal & external path, how to solve it 😅please!!

[@OstonCodeCypher]

Hey Sanjeev did you install xampp on your PC..

[@sanjeevshirsate7760]

@@OstonCodeCypher yes i have installed already in my pc

[@sejalpatil3247]

This works but when i exit the command prompt and join again i have to write the instructions again how to fix it permanently

[@OstonCodeCypher]

You will have to do that every time you want to use it.

[@Thisis256]

His updated solution:: kzbin.info/www/bejne/m5-onIuAh9d9arM

[@subhadipsur7561]

Very good work brother. Keep it up.

[@wiskjekeke5193]

Sir please tell how we can use this same thing ( shell in xampp) on macbook air😭

[@OstonCodeCypher]

I think you need to follow the same procedures but according to file locations

[@patbre]

Hi Oston. I like your video. Not 100% sure however when you create a new database you might use " CREATE DATABASE IF NOT EXISTS youtube". This way if you try to create a new database you will not over write a database that you may have created with the same name already. You should get an error. If you had a database called "youtube" and you create a new database called "youtube" the second will delete the first and you will lose your data from the first. Hope this is helpful. Patrick.

[@OstonCodeCypher]

Thanks for the tip!

[@AJ0802]

For some reason after following these commands it connects to MySQL server not the server from xampp. Can you help

[@swapnilchinchwalkar6107]

Can anyone tell me how to get back the dropped table ?

[@OstonCodeCypher]

You can't get it....You dropped/Deleted it..💣

[@daniel029-]

if i wanna setup maria db that pops up : ERROR 1044 (42000): Access denied for user 'user'@'%' to database 'password'

[@soujanyabk4832]

Thank you very much🤩 it's really helpful

[@OstonCodeCypher]

Glad it was helpful!

[@kaushalyalakshitha9682]

Thank You for Your help

[@jasirischoolapp1158]

so good but then how can i turn mysql database into laravel project

[@samrudhimohanty1556]

Thank you man... This was really helpful

[@OstonCodeCypher]

Am glad that it helped... Happy Coding

[@OstonCodeCypher]

Am glad that it helped... Happy Coding

[@KTech22775]

Thank you so much🙏, is there any way i can contact you?

[@nazrulislam-kp4pn]

Thank you bro very helpful go ahead

[@OstonCodeCypher]

Glad to hear that

[@SY-rr8pz]

5:08

[@dheerajdubey5371]

Thank you so much, sir, for this guide....thank u sir again.....

[@OstonCodeCypher]

You r welcome dubey,Hope u learn more from this channel 👊👍

[@jeremyheng8573]

thanks for the guide!

[@OstonCodeCypher]

Am glad it helped 👍

[@OstonCodeCypher]

Your kind support would buy me the necessary fuel (coffee) and time so I can dedicate myself more to making extra free content. dashboard.flutterwave.com/donate/oiwdp0yfkk5d

[@eliteny0]

Thanks, perfect video for me!

[@OstonCodeCypher]

Thanks for watching 👍

[@bratbalal9042]

Entering password in the command line is insecure and it might not work and give error message Enter. Mysql -u root -p. and press enter Then once password is prompted enter the password

[@OstonCodeCypher]

Thanks for tip - I also realised it later but am glad you noticed it.. Let me pin this comment so that every body See's it.. Thanks once again..

[@bratbalal9042]

Oston Code Cypher sure

[@jeevanjose1510]

Thank you very much bro😊

[@OstonCodeCypher]

You're welkam Jose

[@ashwininayak3387]

I want password spelling sir ? I m not getting password curectly can you help me? Sir

[@oimatheusmesquita]

You are my Hero :) Thank you very much!

[@OstonCodeCypher]

Am glad to hear that...👍

[@Sichuanbeef]

Thanks so much. Very helpful!

[@OstonCodeCypher]

You're welcome... Glad it helped

[@paco1914]

Very helpful. Kudos!

[@leeson3263]

I having error 1045

[@OstonCodeCypher]

Read my pinned comment..

[@RahulYadav-yn7ep]

Xampp shell not open

[@OstonCodeCypher]

Why??? Edit:: Did you follow the steps and already have XAMPP installed??

[@imranhosain7394]

very helpful this tutorial

[@OstonCodeCypher]

Glad to hear that

[@diegosoutoh]

THANK YOUUU SO MUCH!! Muito obrigadoooo:D

[@OstonCodeCypher]

You r welkam, hope you learn more from the channel..PEACE ✌

[@cassio44peia53]

thank you sooooooooooooooooooooo muuuuuuuch , it works :)

[@OstonCodeCypher]

Am glad it helped

[@isaactaremwa001]

Are you a Ugandan and from Western Uganda???

[@OstonCodeCypher]

Ugandan from central

[@vithushan9043]

Thank you so much

[@OstonCodeCypher]

You're welkam bro

[@amashasarindi5134]

Thnks ❤️❤️

[@OstonCodeCypher]

Am glad you liked it 🤝

[@kanuraina4448]

THANKS .....GOD BLESS YOU..

[@OstonCodeCypher]

Thanks Kanu,Bless you too 👍

[@romelash211]

Thank you man

[@OstonCodeCypher]

You r welcome bro...👑👊✌

[@gazziro2916]

Valeu india vc é brabo!

[@SamUddin4u]

Thanks

[@OstonCodeCypher]

You are welcome Sam,Hope u learn more with this channel 👍

[@tommasobellone2899]

Very useful

[@OstonCodeCypher]

Thanks for watching

[@Irhasyahya]

alhamdulillah busa makasih kak :)

[@srnaime3805]

Thank you sir

[@OstonCodeCypher]

You r welkam Naime 👍

[@noone5733]

but I don't know the password(:

[@OstonCodeCypher]

Does your interface require a password?? if not just press enter & continue

[@bes5164]

thanks dude!

[@atairabbi496]

Excellent Explain !!!!

[@OstonCodeCypher]

Glad it was helpful!

[@darkman8939]

Thank you!

[@OstonCodeCypher]

you r welkam

[@ramandeepkaur4201]

Thank you:)

[@OstonCodeCypher]

You are welcome 👍

[@refaldybagas]

tankyou so much

[@OstonCodeCypher]

You are welcome

[@ruggeddog3103]

thank you

[@sanish007]

thanks man;

[@OstonCodeCypher]

You are welcome, hope you learn more from the channel.

[@aishwarysaxena5301]

you are messiah man haahaha

[@OstonCodeCypher]

Am glad it helped...

[@34_santoshkalshetty52]

Great sir

[@agustinlawtaro]

You are God

[@OstonCodeCypher]

Wooow...am really humbled.. Glad it helped U

[@bilalmohammad4242]

Thank you!

[@OstonCodeCypher]

U r welkam..hope you learn more from the channel.

[@diegosoutoh]

One more subscribed:D

[@yotammkandawire3602]

Awesome

[@OstonCodeCypher]

Thanks for watching.... Hope you learn more from the channel 👍👊

[@utharasubhasingha3431]

❤❤❤

[@OstonCodeCypher]

🤝🤝

[@Nibilworld]

open cmd cd c:\xampp\mysql\bin >mysql -u root -p Enter password: show databases;

[@OstonCodeCypher]

Don't forget the -h 127.0.0.1 for the host.

[@sewerynolszewski6137]

love from poland

[@OstonCodeCypher]

Thanks very much 👍👊

[@MaryOppong-eg4yy]

Thanks

[@SharaPk]

Very helpful , Thank you

[@OstonCodeCypher]

Glad it was helpful!

[@ManishaKumari-wi6kg]

Thank u so much

[@OstonCodeCypher]

You are welcome

[@AtulYadav-ml4hk]

Thanks Bro

[@OstonCodeCypher]

Welcome

[@OstonCodeCypher]

Welcome

[@techlead6083]

thank you

[@sixtusushahemba9419]

Very helpful, thank you!

[@OstonCodeCypher]

Glad it was helpful!