When I try to register a database, I get the following message: Access denied for user: myuser@myhost.mydomain. Why does it happen?
MySQL server uses client’s login (‘myuser’ in your case) and the name of the host from which it tries to set the connection (‘myhost.mydomain’ in your case) for the client authentication. In your case the reason is that your ‘myuser’ user from the ‘myhost.mydomain’ host doesn’t have permissions to access your MySQL server. It’s quite possible that you successfully connected to your database with the same login and password in your PHP scripts or with the help of phpMyAdmin, but in this case MySQL server recognizes you as the ‘myuser’ user from the ‘localhost’ host who has the necessary permissions and allows you the access. To solve this problem you should grant the necessary permissions to user myuser@ myhost.mydomain. You can do this with the help of phpMyAdmin or with sql commands: /*!50003 CREATE USER ‘myuser’@ ‘myhost.mydomain’*/; GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@ ‘myhost.mydomain’ IDENTIFIED BY ‘user_password’; Or, you can apply to your system administrator. (http://dev.my
Related Questions
- Why am I getting the following error message when more than one user on a network tries to access a program: Program is already in use by another user. Access denied.?
- When I try to register a database, I get the following message: Access denied for user: myuser@myhost.mydomain. Why does it happen?
- When I try to register as a new DataWeb user, I get an error message and the registration fails. What is wrong?
