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.

copy

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 :: Howto
date_range Published :: 3 years ago At: 04:45 PM
event_note Detailed Date :: Jan 07th, 2019
person Writer :: Code
  • RECENT POSTS
11 months ago

A JavaScript library for formatting and manipulating numbers - Numeral.js

Check out this lightweight JavaScript library used for formatting and manipulating numbers.


1 year ago

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.


1 year ago

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.


1 year ago

YTS YIFY MOVIES API - PROJECT PREVIEW

Download YTS YIFY movies using this simple project I created using their API.


1 year ago

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.


1 year ago

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?


1 year ago

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).


1 year ago

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.


Subscribe
  • ADVERTISEMENT

YOU MAY LIKE THESE POSTS

share