I'm developing a system that will access the MySql database just to query data. I made reference to mysql.data.dll and am using access through MySqlConnection.
It turns out that the system is returning the following error:
Access Denied for user 'myuser ....'
The interesting thing is that I can access the same database with the same user through SqlYog, but I can not get through .NET.
Is there any user configuration inside MySql to accept access?
Have you checked that MySQL is accepting connections from other hosts? There is a configuration in MySQL that allows it to be accessed only from the machine that is installed, or from other hosts.
It is important to check in the configuration (my.ini or my.cnf, depending on whether your installation is windows or unix) and see if in the [mysqld] section the settings are correct.
Some parameters that may be interesting here are: bind-address (addresses that the connection is allowed) and enable-named-pipe.
