How to set the login preference

[tcflam]

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

[ViktorV]

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).

[tcflam]

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

[ViktorV]

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.