koobas.hobune.stream
mystery MYSQL error ..
"What is the meaning "MySqlException: Host '103.247.42.210' is not allowed to connect to this MySQL server" ?"
Hi all, i'm trying to connect my online MySQL database, but i got the error like this?
MySqlException: Host '103.247.42.210' is not allowed to connect to this MySQL server MySql.Data.MySqlClient.MySqlStream.OpenPacket () MySql.Data.MySqlClient.NativeDriver.Open () MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) MySql.Data.MySqlClient.MySqlConnection.Open ()
Does anyone know what's the meaning from this error?
Thanks
It's on the server side. MySQL can be set up to only allow connections from specified IP addresses. Most often this is set to only allow connections from the server itself.
If you are trying to connect from a client on a separate machine you need to alter the MySQL server to allow either your specific ip address, or to allow all IP addresses.
If you are connecting from a client on the same machine as the MySQL server then try connecting to 127.0.0.1 instead of the real IP address.
Thanks MarkFinn for the solution.
I already connect to MySQL server, from the server side i allowed my ip address to connect :D
Cool. Don't forget to select the answer, so folks know that the problem was solved.
