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. In your case the reason is that your 'myuser' user from the 'myhost.mydomain' host doesn't have permissions to access your MySQL server. When I try to connect to a database, I get the following message: 'Access denied for user: Why does it happen?Ī: MySQL server uses client's login ('myuser' in your case) and the name of the host which it tries to set the connection from ('myhost.mydomain' in your case) for the client authentication. If the error message says 'Access denied for user: or 'Host not allowed to connect to server', then the reason is that the user doesn't have permission to access the database. Please check this with your system administrator or ISP. The remote server port can also be closed by ISP, or TCP/IP protocol support is disabled on MySQL server. It often happens that the port through which the connection is set with MySQL server (normally, it's 3306) is closed for the security reasons by local firewall, corporate firewall or remote server firewall. If the error message says 'Can't connect to MySQL server on ‘some host' (10061)' then probably you should check the correctness of port and host name you've entered and also if the remote server is run. A: There could be several possible reasons that prevent you from successful connection to remote database.
0 kommentar(er)
