XAMPP for OS X: How to access MySQL from the command line

If you want to access XAMPP’s MySQL shell on Mac OS X, use the following command: /Applications/xampp/xamppfiles/bin/mysql -u root -p This gave me a few headaches in the past, so I’ll leave this here for others to find.

How to fix the “#1046: No database selected” error in phpMyAdmin

Here is a simple solution to the “#1046: No database selected” error when trying to import a .sql file in phpMyAdmin. Solution #1: Before importing In phpMyAdmin, click on the Export tab from the home page of phpMyAdmin, without selecting any database. phpMyAdmin will then include instructions to create and select the database when you […]