How can I access the MySQL command line with XAMPP for Windows? - SOLVED
HTML-код
- Опубликовано: 10 сен 2024
- Pliz, SUBSCRIBE TO MY SECOND CHANNEL:: / @thisis256 (Planning to start Video Editing Tutorials).
How to connect to MySQL database through windows Command Prompt Console.
Your MySQL binaries should be somewhere under your XAMPP folder. Look for a /bin folder, and you'll find the mysql.exe client around. Let's assume it is in c:\xampp\mysql\bin, then you should fire up a command prompt in this folder.
That means, fire up "cmd", and type: mysql -u root -p -h 127.0.0.1
THE WORLD'S LARGEST WEB DEVELOPER CHANNEL:
/ ostoncodecypher
Join Oston code cypher channel today and get your life time tutorials for free!
Learn how to build websites and apps, write code, or start a business on your own. Learn from over 1,000 videos created by himself the expert on web design, coding, business, and much more.
Oston code cypher channel teaches the in-demand technology skills you need to land your dream job.
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.
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.
i'm having a hard time setting up my xampp awhile ago and i really thank you for this. it help me a lot
You are welcome.
I wish you all the best 👍
Finally I found a Uganda with IT tutorials 👍 good work Oston
Thanks very much. I am glad you liked the tutorial. ALL the best 👍
You're welcome
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
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
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:: ruclips.net/video/enEkXJRrJ4Q/видео.html
Finally this video showed how to do it. I was struggling.
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!
Am glad it helped out. Stay blessed and thanks for watching
Thank you man, the lecturer actually wanted us to use wampserver since it uses cmd line yet I have xampp installed on my system.
Am glad that it helped... nice coding & hope you learn more from the channel
Very useful and straight to the point. You should do more videos.
Thanks for helping me out!
You r welcome, glad it helped
Thank you mr. That print trick sure was helpful
Glad it helped, thanks for watching
Thanks for ur explanations about accessing the server with windows Cmd , this video helps me really. Keep doing videos 👍
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:: ruclips.net/video/enEkXJRrJ4Q/видео.html
Thank you so much I've had so much trouble trying to sign in this was perfect!
You r welkam,thanks 4 watching 👑👊👍
Thank You for Your help
This works but when i exit the command prompt and join again i have to write the instructions again how to fix it permanently
You will have to do that every time you want to use it.
His updated solution:: ruclips.net/video/enEkXJRrJ4Q/видео.html
Thank you for this my head was soon bursting
Am glad it helped, here is tutorial:: ruclips.net/video/enEkXJRrJ4Q/видео.html to save you from following the same process every time you need to use the command line.
Devru guru neenu❤️
Nija guru
Very thanks through your lecture about how to connect with database mysql.
Thank you very much i have been thinking about it and now i get solution from your video thanks Man.
Thanks for watching Jitendra..👍👑
Hope you learn more from the channel.
I never set a password and I always typed -p in the cmd. Finally able to deal with it. Thankyou
Love From India ❤️🔥
Very good work brother. Keep it up.
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.
Thanks for the tip!
if i wanna setup maria db that pops up :
ERROR 1044 (42000): Access denied for user 'user'@'%' to database 'password'
For some reason after following these commands it connects to MySQL server not the server from xampp. Can you help
Thanks
What should I do when I couldn't find bin in mysql???
What are you using Xampp or Wamp???
Thank you very much🤩 it's really helpful
Glad it was helpful!
so good but then how can i turn mysql database into laravel project
Very helpful , Thank you
Glad it was helpful!
Thank you so much
You welcome
Thank you man... This was really helpful
Am glad that it helped... Happy Coding
Am glad that it helped... Happy Coding
Thank you bro very helpful go ahead
Glad to hear that
Thank you so much, sir, for this guide....thank u sir again.....
You r welcome dubey,Hope u learn more from this channel 👊👍
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
What are you using XAMPP or WAMP
Very helpful. Kudos!
Very useful
Thanks for watching
thanks for the guide!
Am glad it helped 👍
Thanks...Do I need to do that everytime when I try to open mysql through command prompt.
Yes bro....but with time trust me u will get used to it. 👍
Oston Code Cypher Thank you...
Thanks, perfect video for me!
Thanks for watching 👍
Sir please tell how we can use this same thing ( shell in xampp) on macbook air😭
I think you need to follow the same procedures but according to file locations
You are my Hero :) Thank you very much!
Am glad to hear that...👍
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
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..
Oston Code Cypher sure
love from poland
Thanks very much 👍👊
thanks dude!
THANK YOUUU SO MUCH!! Muito obrigadoooo:D
You r welkam, hope you learn more from the channel..PEACE ✌
Thank you very much bro😊
You're welkam Jose
tankyou so much
You are welcome
I want password spelling sir ? I m not getting password curectly can you help me? Sir
Can anyone tell me how to get back the dropped table ?
You can't get it....You dropped/Deleted it..💣
Xampp not reconginzed internal & external path, how to solve it 😅please!!
Hey Sanjeev did you install xampp on your PC..
@@OstonCodeCypher yes i have installed already in my pc
THANKS .....GOD BLESS YOU..
Thanks Kanu,Bless you too 👍
thanks man;
You are welcome, hope you learn more from the channel.
Thnks ❤️❤️
Am glad you liked it 🤝
thank you
very helpful this tutorial
Glad to hear that
thank you sooooooooooooooooooooo muuuuuuuch , it works :)
Am glad it helped
Thanks Bro
Welcome
Welcome
Thank you man
You r welcome bro...👑👊✌
Great sir
Valeu india vc é brabo!
Thank you!
you r welkam
Excellent Explain !!!!
Glad it was helpful!
Thank you:)
You are welcome 👍
you are messiah man haahaha
Am glad it helped...
Thank you so much🙏, is there any way i can contact you?
alhamdulillah busa makasih kak :)
You are God
Wooow...am really humbled.. Glad it helped U
Xampp shell not open
Why???
Edit:: Did you follow the steps and already have XAMPP installed??
Thank you!
U r welkam..hope you learn more from the channel.
I having error 1045
Read my pinned comment..
but I don't know the password(:
Does your interface require a password??
if not just press enter & continue
Awesome
Thanks for watching.... Hope you learn more from the channel 👍👊
Are you a Ugandan and from Western Uganda???
Ugandan from central
5:08
One more subscribed:D
FUCK THANKYOUUUU!!!!!
open cmd
cd c:\xampp\mysql\bin
>mysql -u root -p
Enter password:
show databases;
Don't forget the
-h 127.0.0.1
for the host.
Very helpful, thank you!
Glad it was helpful!
thank you
Thank you so much
You're welkam bro
Thanks
You are welcome Sam,Hope u learn more with this channel 👍
Thank you sir
You r welkam Naime 👍
Thanks so much. Very helpful!
You're welcome... Glad it helped
Thank u so much
You are welcome