Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm working from a Mac OSx Lion that is running XAMPP on localhost. I've been trying to find a way to run MySQL through the terminal. Normally I would do mysql -u [username] -p but the command is not recognized.

Am I doomed to use PHPMyAdmin for local development?

I couldn't find anything related to this on the web, hopefully someone can give me a hand.


share|improve this question

migrated from stackoverflow.com Jun 15 '12 at 14:59

This question came from our site for professional and enthusiast programmers.

is mysql installed and running without errors? do you have permissions on running mysql? –  GeoPhoenix Jun 14 '12 at 5:01
@GeoPhoenix Yes, I can use phpMyAdmin perfectly and all the applications connected to MySQL work fine. My terminal just says that the mysql command is not recognized. –  RCorrie Jun 14 '12 at 5:06
Not much of Mac user, but usually when the "command not found" appears and mysql is installed , means that might need some adminstrative rights to access via terminal –  GeoPhoenix Jun 14 '12 at 5:10
@GeoPhoenix well XAMPP is a cross-OS package, it's meant for development and doesn't run as a server. This might be the problem, since it's not running at a global level. But either way, where could I take a look at the permissions for MySQL. –  RCorrie Jun 14 '12 at 5:14
take a look here stackoverflow.com/questions/3354046/… –  GeoPhoenix Jun 14 '12 at 5:18

1 Answer 1

For limited access to MySQL server or port has been blocked by ISP's you can either connect through via SSH or HTTP.

You can use SQLyog-MySQL GUI which has both options to connect to MySQL server if your ISP/MySQL provider disallows remote access, either my blocking the MySQL port or by giving access to “localhost” only.

Using SSH tunnel as well as via HTTP - For HTTP connection you have to copy a file SQLyogTunnel.php to your webserver using any FTP client.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.