I have all the necessary info... I can read pretty much any code, not afraid of syntax... just not sure why I keep getting errors trying to remotely connect to a mysql server. Error: Access denied for user 'myuser@myip... ' (using password: YES) via mysql workbench... Error: ERROR 2005 (HY000): Unknown MySQL server host 'myhost prefix,' (11001) via command prompt. With that said yes a Windows environment, and for sure correct credentials via my php file... just at a loss. I have ensured the default port is open 3306, and just trying to help a buddy out debug an issue so hoping for some help here... first time ever doing this, but read many a forums, so all I can provide, the code runs on it's host fine... as I mentioned debugging an issue locally so need to access the db and can't as aforemented... any advice would be appreciated.
-
-
Hey.
Do you have access to the computer running the MySQL server?
If so, then what kind of system is it?
Many MySQL servers - especially those on computers hosting websites - are restricted to local connections only. You may want to check that out. Makes sure that:- The server allows traffic through the port MySQL uses (usually 3306)
- That the bind-address directive in the my.cnf/my.ini file is set correctly (to the outbound IP of the server, rather than localhost or a network IP).
- That the skip-networking directive is not set.
- That the user you are connecting through is allowed to connect remotely.
Comment