Xampp Cmd Mysql

Posted on  by admin

XAMPP is a software distribution which provides the Apache web server, MySQL database (actually MariaDB), Php and Perl (as command-line executables and Apache modules) all in one package. It is available for Windows, MAC and Linux systems. No configuration is necessary to integrate Php. XAMPP - Replacing MariaDB with MySQL. As of XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. MariaDB is not 100% compatible with MySQL and can be replaced with the 'orginal' MySQL server. Backup the old database into a sql dump file; Stop the MariaDB service; Rename the folder: c: xampp mysql to c: xampp mariadb; Installation. Start mysql xampp command line Code Example Get code examples like 'start mysql xampp command line' instantly right from your google search results with the Grepper Chrome Extension.

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


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:xamppmysqlbin, then you should fireup a command prompt in this folder.

That means, fire up “cmd”, and type:

If you want to use mysqldump.exe, you should also find it there.

Log into your mysql server, and start typing your commands.

Hope it helps…


On the Mac, or at least on my Mac using a default install, I accessed it at:


To access the mysql command in Windows without manually changing changing directories, do this:

  • Go to Control Panel > System > Advanced system settings.
  • System Properties will appear.
  • Click on the ‘Advanced’ tab.
  • Click ‘Environment Variables’.
  • Under System Variables, locate ‘Path’ and click Edit.
  • Append the path to your MySQL installation to the end of the exisiting ‘Variable value’. Example:

    or, if you prefer

  • Finally, open a new command prompt to make this change take effect.

Note that MySQL’s documentation on Setting Environment Variables has little to say about handling this in Windows.

  1. Open the XAMPP control panel.
  2. Click Shell.
  3. Type mysql --user=your_user_name --password=your_password.


The reason that you can’t see the other tables is that you need to log in as ‘root’ in order to see them


I am running on windows 7 and had similar issue which I solved by:-

  1. Right click on the Computer icon on your Desktop and choose Properties option.
  2. In the System window click on Advanced system settings in the left pane as highlighted below
  3. In the System Properties window select Advanced tab and click on Environment Variables… button given at the bottom of the window as highlighted below
  4. In the Environment Variables window you will notice two columns User variables for a Username and System variables.
  5. Under System variables there is a Path variable, click edit
  6. At the end of the line, add where you installed your xampp, for my case it is: ‘;C:xamppmysqlbin’
  7. and finally click ok

Cmd Mysql Xampp


Go to /xampp/mysql/bin
and find for mysql. exe

Xampp cmd mysql tutorial

open cmd, change the directory to mysq
after write in cmd

mysql -h localhost -u root


Xampp control panel v2.3.1
I got errors while using -h localhost

So, if you installed xampp as is and did not customize any documentroot, serverroot, etc. then the following works :-

start both the services on the xampp control panel
click shell
enter: # mysql -h -u root

that works just fine.
Below is the logtrail:-


mysql -h localhost -u root -p and enter root pw


Xampp Mysql Command Not Found

To access SQL via the command line we simply navigate to the xampp folder.
the folder is usually on the c: drive.

  1. type: cd c:xamppmysqlbin then press enter.
  2. type: in mysql -u root -p then press enter.
  3. in the new line enter the password of the database.
  4. type: show databases; to see all the databases that you have access to.
  5. once you know what database you want to use type (ex. cms_database), type use cms_data or any other db_name, it should say Database changed

// Bonus Note
you shouldn’t use the root user when working with databases. you would want to create a separate account (ex. cms_user) with special privileges to limit errors.

to do that type:

double check by using the command:


if you already have the name of the user and the specific database you wish to use, change step 2 to this.


In terminal:

Hit ENTER if the password is an empty string. Now you are in.
You can list all available databases, and select one using the fallowing:

Remember about the “;” at the end of each SQL statement.

Windows cmd terminal is not very nice and does not support Ctrl + C, Ctrl + V (coppy, paste) shortcuts. If you plan to work a lot in terminal consider installing alternative terminal cmd line, I use cmder termianl – Download Page


You can access the MySQL command line with XAMPP for Windows

Xampp Mysql Command Line Mac

  1. click XAMPP icon to launch its cPanel

  2. click on Shell button

  3. Type this mysql -h localhost -u root and click enter

Xampp Cmd Mysql Tutorial

You should see all the command lines and what they do

Xampp Mysqldump Command Not Found

Tags: mysql, sql, windows