How can I access the MYSQL command line with XAMPP for windows? - SOLVED

Make money for being or staying online/internet.
You will get a $5 starting gift when you join using this link:: GET THE OFFER NOW!!
At a large scale this article is meant for students using XAMPP server software.When it's time for exams, the lectures or lecture in a particular subject(Database Management) need a print out of SQL queries used and how it displayed outcome.
By default XAMPP users don't have easy access to this option like the WAMP server users,so i have put together this simple article to solve this.
Common Questions people ask online.
How to connect to mysql database through windows Command Prompt Console.?
Is it possible to connect to mysql database through windows Command Prompt Console.?
Connecting mysql database through CMD - Need Help??
Well, this is the right post/Article to answer all those questions stated above.
For all this content to make sense,i have put together a very simple video with all the steps on 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.
The moment you reach the /bin folder,issue this command below.
mysql -u root -p -h 127.0.0.1
Command Explained
The mysql - This specifies the name of the program that you are running.
The -u - This represents the username used by the xampp software. For this case it's root.
The -p - This represents the password used by the xampp software.It is user defined,so you can leave it blank or set it for security purposes.
The -h - This represents the host or IP address used to access the xammp software control panel/dashboard. For this case it's 127.0.0.1.
Example http://127.0.0.1/phpmyadmin or http://localhost/phpmyadmin
Hope this simple tutorial set the atmosphere free for you guys who were confused on how to access the MYSQL command line with XAMPP for windows.
Subscribe to my channel Oston Code Cypher
Save up to 80% with this Domain & Shared Hosting package deal! 80% OFF - GET OFFER NOW
Related Post(s)
» How can I access the MYSQL command line with XAMPP for windows? - SOLVED
» How to create a simple CMS for HTML and PHP Websites
» Smooth Scroll Back To Top Button - PART 2
» How To Set A Meta Theme Color For Your Website
» Why can't my windows 10 host file be edited - Solution
collections_bookmark Category :: Howtodate_range Published :: 3 years ago At: 04:45 PM
event_note Detailed Date :: Jan 07th, 2019
person Writer :: Code
- RECENT POSTS

A JavaScript library for formatting and manipulating numbers - Numeral.js
Check out this lightweight JavaScript library used for formatting and manipulating numbers.

All Countries Drop Down List | HTML Select Country Name
This simple country dropdown list is freely available for you to copy and use in your project forms.

HTML Entities Code Alphabet Discovery Using JavaScript
In this post I will show how writing just a few lines in JavaScript will allow you to render, browse and discover the alphabetical letters using a set of HTML entity codes.

YTS YIFY MOVIES API - PROJECT PREVIEW
Download YTS YIFY movies using this simple project I created using their API.

Display Random Advice On Your Website or Web App Using Advice Slip JSON API
Here is a short project to display the use of APIs. I decided to work with an advice API because it seemed like a fun one that I haven't worked on before.

How do I get a YouTube video thumbnail from YouTube using PHP
Have you ever been on youtube and admired a thumbnail of a video?

How to recreate Facebook's console warning
When I was inspecting some code on Facebook. I came across this interesting feature. A simple styled console warning message from Facebook to its dear users(products).

How To Create A Stacked Gallery Using HTML And CSS Source Code
In this post I provide you with the source code for the youtube tutorial I made on how to create a Stacked image gallery Using HTML and CSS.
- ADVERTISEMENT