I'm running Windows XP on a laptop. I installed wamp server 2.1 (compising php 5.3.5, apache 2.2.17 and mySQL 5.5.8) and Flash Builder 4. I'm now learning to connect data to a mySQL database (called mySQLdatabase) which I set up using myPHPadmin.
After creating a new Flex 4 project, based on PHP server tehnology in Flash builder I selected,
Data > connect to Data/Service > PHP > next > click here to generate sample PHP
then filled out the service generator form as follows:
Host name: localhost
Server Port: 80
I clicked 'Connect to Database' to generate a PHP class file and got this error message:
unable to connect to database, using specified connection information:
It's left me scratching my head! I've checked my database info (which is fairly standard: Username, Password, Host name, localhost, Server Port and Database name) and it all checks out! I just can't figure out what's wrong!!
I thought it might be folder permissions where my WAMP softwares installed. I checked the security settings there too, and made sure everything was set to full control. That didnt work.
I wonder if anyone can tell me how to resolve the problem?
try changing server port to 3306
looks like you are trying to connect to mysql database on port 80. This is incorrect. Port 80 is typically used for HTTP. Mysql dabases typically communicate on port 3306 by default. So I am assuming the WAMP installation installed everything using default configurations you should specify port 3306 for your DB connection settings.
(MYSQL DB COMMUNICATIONS) Port :3306
Database Name: dbname
Hope that helps.