The follor error : 1045 Access denied for user ''@'localhost' (using password:NO) indicate that your MySQL user has no enough privilege in order to connect with the server.
After MySQL database was installed, it only allow "localhost" connection by default. Any client computers will be blocked by the remote MySQL server until the user privileges has been configured.
If you want to access your remote MySQL server from any desktop, you would need grant the right privileges.
1. Checks whether your IP address is allowed.
2. Edit the MySQL user with the DreamCoder for MySQL and allow your IP address in the host field.
3. If you not have a static IP address you can use % in the host field.
If your server supports SSH connection, your DreamCoder for MySQL will be able to connect with remote MySQL databases through SSH tunnel without changes to database.
Also you can check the mysql documentation error :
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html
Regards,
Peter
