Unexpected error when trying to make MySQL connection

[fotimember]

Hello

Im using Dreamweaver MX to build a website with a search feature. im using PHP pages and need to connect them to a database i created using the MySQL Wizard on the cPanel. When i try to make the connection i enter the following details:

Connection Name: fotidatabase
MySQL server: localhost
Username: foti1@localhost (this is the username shown on the PHPMyadmin screen)
Password: (password i use to log into PHPMyAdmin)

when i click on the select button to choose the database dialogue appears saying it has connected to the host, then an error message appears saying "an unexpected error has occured". if i enter the name of the database as foti1_fotidatabase then click on "Test" the same happens. can anyone tell me how to correct this?

Thank you in advance
Martin

 

[sunils]

did you give previlages to the above user to use that particular database? The problem could be that also.

 

[fotimember]

did you give previlages to the above user to use that particular database? The problem could be that also.

i've added a new user to the database called foti1_foti1 and given it all privelages but the same problem still happens. could the problem be with my remote connection to the site, is there a specific folder that i should connect to?

 

[DefecTalisman]

Are you trying to connect to the database remotely ? If so then yes that would be the problem. The firewall is setup to block outside connections.

 

[fotimember]

I've tried connecting with the firewall turned off and the same happens

 

[sunils]

He meant, the firewall in our database servers. You cannot connect remotely to the database servers.

 

[tnl2k7]

Sunils is correct, connecting to MySQL remotely isn't allowed; because some users were found with loads of connections and it caused some problems .

-Luke.