TurnKey Linux Virtual Appliance Library

LAMP - MYSQL - Dreamweaver - mysql database 'manager' blocked'

sales's picture

I am running a LAMP server..  It runs fine, including PHP connecting to my database.  i wrote some 'custom' code and the php code can connect to the database fine and display the data.  

However, I am trying to bring over a dreamweaver site and run that on the server.  Dreamweavers GUI cant find the mysql server.  It returns a error that it would normally returns if PHP was not enabled.  I triple checked all the mysql settings.

I am thinking it is something that is locked down in the standard LAMP install that is blocking dreamweaver.  I realize this is in no way a LAMP bug but after 3 hours I am losing my mind.  Anyone have any experience dropping a PHP site on a LAMP sever and had any issues getting dreamweaver to find the mysql server?

Jeremy Davis's picture

I have no experience with dreamweaver

But my first guess when reading that the dreamweaver GUI can't find MySQL suggests to me that you are attempting a remote connection to your LAMP appliance. By default MySQL in the LAMP appliance is bound to localhost, so it doens't listen for remote connections. Have a look here.

rich z's picture

Thanks...  I actually already

Thanks...  I actually already had the ports open and the database enabled for differnt hosts since I was using a sql manager from my desktop box.  

It turned out it was just some random dreamweaver error.  After trying everything for another two hours I ended up printing the settings, deleting the site and adding them back in and it worked fine.

But as pointed out the exact change you mentioned is what others would need to do to enable this.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)