How to Access MySQL Command Line in XAMPP?
September 2nd, 2010 — adminMySQL binaries should be under your XAMPP folder. Look for a /bin folder, and you’ll find the mysql.exe client around. Let’s assume it is in e:\xampp\mysql\bin, then you should fireup a command prompt in this folder.
First, go to e:\xampp, and run xampp_start. If you do not run xampp_start first, the error message “Can’t connect to Mysql server on ‘localhost’” will occur when you go to step 2.
Afer you run the commend prompt of DOS, then enter:
cd d:\xampp\mysql\bin
mysql.exe -u root –password
Enter password:
and enter root password
mysql>
After log into your mysql server, and start typing your commands.
Type “quit” or “exit” to exit mysql
Read the rest of this entry »