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

by

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…

More Related Contents:

  1. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  2. how to delete data from table A besides the customer service and director data in table B?
  3. How to solve “Error: MySQL shutdown unexpectedly”?
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. xampp MySQL does not start
  6. mysql2 gem compiled for wrong mysql client library
  7. MySQL error 1064 syntax but everything seems fine
  8. How can I get rid of these comments in a MySQL dump?
  9. mysql configuration stops at “starting server”
  10. Import SQL file into mysql
  11. How can I change MariaDB to MySQL in XAMPP?
  12. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  13. Restore the mysql database from .frm files
  14. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  15. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  16. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  17. How repair corrupt xampp ‘mysql.user’ table?
  18. Mysqldump launched by cron and password security
  19. How to force case sensitive table names?
  20. MySQL my.ini location
  21. access denied for user @ ‘localhost’ to database ” [closed]
  22. How to turn on/off MySQL strict mode in localhost (xampp)?
  23. Where does MySQL store database files on Windows and what are the names of the files?
  24. XAMPP – Error: MySQL shutdown unexpectedly
  25. Xampp-mysql – “Table doesn’t exist in engine” #1932
  26. How to get back Lost phpMyAdmin Password, XAMPP
  27. Select the 3 most recent records where the values of one column are distinct
  28. Difference in MySQL JOIN vs LEFT JOIN
  29. Get most recent row for given ID
  30. ALTER TABLE ADD COLUMN takes a long time

Leave a Comment