Devart Forums

Dear,

Our MySQL set the access control that only allow local PC to access. I use my laptop to connect the DB. It reports the error about access denied.

How can I solve this problem?

Thanks & regards,

Timothy

If MySQL server is not located on the laptop, then the specified security settings will not allow you to connect to MySQL server. Otherwise: the 'Access denied for user 'YourUserName'@'YourComputerName'' message is a server response to an authentication fail. This message means that no user with the 'YourUserName' name exists or you have entered an invalid password, or a user with the 'YourUserName' name has no server access rights from the 'YourComputerName' PC.
To solve the problem, you should add the necessary rights to the YourUserName account or create a user with the necessary rights. The needed information can be found in the MySQL reference manual (e.g.: http://dev.mysql.com/doc/refman/5.5/en/grant.html).

Thanks. I grant the access right in MySQL and the problem solved.

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.