Well, my scenario is connecting my ASP.NET 2.0 apps from IIS6 (window 2003 server) to MySQL (Linux) using ADO.NET Connector.
Hit error message when try to connect:
Access denied for user 'userxxx'@'xxx.xxx.xxx.xxx' (using password: YES)
It's quite worry because this is first time trying to connect from a .net web application is IIS to MySQL in Linux.
Prior to that, privileges must be granted in MySQL.
mysql> grant all privileges on *.* to 'userxxx'@'xxx.xxx.xxx.xxx'
identified by 'xxxpasswordxxx' with grant option;
Query OK, 0 rows affected (0.00 sec)
Finally, found that it's my own mistake. I've put in the wrong username and password. Check your username and password seriously before the connection.