I have been going through a few tutorials where Dreamweaver CS5 connects to a MySQL database. On all occassions, within Dreamweaver i can always connect to the MySQL database (from XAMPP 1.7.3) successfully with the "root" user but when i try to connect with any other user, it fails with the same connection error message of:

MySQL Error#: 1044
Access denied for user 'cs5write'@'localhost' to database 'phpcs5'.

Any advice or suggestions very much appreciated.

Cheers,
kosh

Greetings,

I know it's an old question but the solution is to grant the user 'cs5write' access to the database 'phpcs5' the easiest way to do this is via the MySQL Administration tool.

I was looking up this error, and found this thread, maybe someone is still watching :) I'm actually trying to connect to a specific MySQL cloud db, and I keep getting a similar access denied error. Not sure if this has to do with the external IPs I'm using... This is a tough one.

Greetings,

The user, the account name for the user access the database, needs to be granted permission to connect to the database from either localhost or any other allowed address. You then setup what the user is allowed to do, create table, drop tables etc etc.

The solution is as stated above give the user account you wish to use access to the database, and make sure you grant the minimum priv's so the user can do what they need to and nothing more.