Tell me more ×
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.
up vote 1 down vote favorite

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.

Gracias!

share|improve this question
1  
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
1  
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
1  
take a look here stackoverflow.com/questions/3354046/… – GeoPhoenix Jun 14 '12 at 5:18
show 1 more comment

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

1 Answer

up vote 1 down vote

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

 
discard

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