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

mysql windows xampp mysqldump
Nathan Long picture Nathan Long · Mar 30, 2009 · Viewed 430k times · Source

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

Answer

Wadih M. picture Wadih M. · Mar 30, 2009

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 fireup a command prompt in this folder.

That means, fire up "cmd", and type:

cd c:\xampp\mysql\bin
mysql.exe -u root --password

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

Related questions

Xampp MySQL not starting - "Attempting to start MySQL service..."

I've just installed XAMPP for Windows - should be the newest version (XAMPP Control Panel v3.2.1). Apache is running just fine on port 80 and 443, but MySQL is not starting. When I press the start button, I get this message: Attempting …

Read More
What is the location of mysql client ".my.cnf" in XAMPP for Windows?

What is the location of mysql client .my.cnf using XAMPP in Windows? Clarification: This file does not exist by default, so when you create it, where should you place it, in order for the command line client to read …

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More