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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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… – GeoPhoenix Jun 14 '12 at 5:18

Your Answer


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