Trouble tunneling my local Wordpress install to the mysql database on appfog

Posted by alanmoo on Stack Overflow See other posts from Stack Overflow or by alanmoo
Published on 2012-11-04T17:01:59Z Indexed on 2012/11/24 23:04 UTC
Read the original article Hit count: 197

Filed under:
|
|
|

I've set up a wordpress install on appfog (using rackspace), and cloned the install to my local machine for development. I know the install works (using MAMP) because I created a local mysql database and changed wp-config.php to point to it. However, I want to develop without having to change wp-config.php every time I commit. After doing some research, it seems like the Appfog service Caldecott lets me tunnel into the mysql database on the server, using af tunnel. Unfortunately, I'm having issues with getting it working. Even if I change my MAMP mysql port to something like 8889, and tunnel mysql through port 3306, it looks like it's connected but I still get "Error establishing a database connection" when loading my localhost Wordpress. When I quit the mysql monitor (using ctrl+x, ctrl+c), I get a message stating "Error: 'mysql' execution failed; is it in your $PATH?'. Originally, no, it wasn't, but I've fixed my PATH variable on my local machine so that when I go to Terminal and just type mysql, it loads up.

So I guess my question is 2 parts:

1.)Am I going with the right approach for Wordpress development on my local machine

and

2.)If so, why is the tunnel not working?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Wordpress