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 to create a simple CMS for HTML and PHP Websites

» Setup your Chromebook for Web Development

» How to a create Scroll To Top Button using HTML CSS & JAVASCRIPT

» Why can't my windows 10 host file be edited - Solution

» How To Install Kazam Screen Recorder On Ubuntu

collections_bookmark Category :: Howto
date_range Published :: 4 years ago At: 04:45 PM
event_note Detailed Date :: Jan 07th, 2019
person Writer :: Code
  • RECENT POSTS
8 months ago

How to force the browser to cache a page?

There are several ways to force a web browser to cache an HTML page:


8 months ago

How can i cache pages using php?

You can use the output buffering functions in PHP to cache pages. Output buffering allows you to store the output of a PHP script in a buffer, which you can then manipulate before sending it to the client.


8 months ago

PHP explained in a few lines

PHP is a popular programming language that is widely used for web development. It stands for "PHP: Hypertext Preprocessor" and is a server-side scripting language. This means that it is executed on the server, rather than in the user's web browser.


8 months ago

HTML explained in a few lines

HTML, or Hypertext Markup Language, is the standard markup language for creating web pages and web applications. It is used to structure and organize content on the web, and to create the basic structure and layout of a webpage.


8 months ago

CSS explained in a few lines

CSS, or Cascading Style Sheets, is a stylesheet language used for describing the look and formatting of a document written in HTML. CSS is used to control the presentation of multiple web pages at once, making it a crucial tool for web developers and designers.


2 years ago

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

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


2 years 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.


2 years 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.


Subscribe
  • ADVERTISEMENT

YOU MAY LIKE THESE POSTS

share