| Question: |
How to connect to mysql with .net? |
| Answer: |
Hello. Where are Your scripts .net ? do you have a static ip? |
| Question: |
the script to reside on my computer, the ip appears to be dynamic |
| Answer: |
with a dynamic ip you can`t connect. need a static ip. |
| Question: |
well, let`s try with the ip I have now |
| Answer: |
only need static ip |
| Question: |
but to do so would be all the ip to connect is impossible? |
| Answer: |
unfortunately no. |
| Question: |
I have a static |
| Answer: |
inform your IP address, we will add it to trusted, then You will be able to podklyuchitsya. |
| Question: |
193.227.251.148 |
| Answer: |
the IP address is added to trusted. |
| Question: |
thank you |
| Question: |
to connect to http://91.231.84.106/? |
| Answer: |
212.86.107.43 |
| Question: |
thank you |
| Answer: |
Thank you, that appealed to customer support. |
| Question: |
I can`t connect, what`s the problem tell me??MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host `212.86.107.43` for user `pdv_denis` using method `mysql_native_password` failed with message: Access denied for user `pdv_denis`@`lab312.riad.com.ua` (using password: YES) ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user `pdv_denis`@`lab312.riad.com.ua` (using password: YES) in MySql.Data.MySqlClient.MySqlStream.ReadPacket() in MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() in MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() in MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() in MySql.Data.MySqlClient.Driver.Open() in MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() in MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() in MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() in MySql.Data.MySqlClient.MySqlPool.GetConnection() in MySql.Data.MySqlClient.MySqlConnection.Open() in mysql.Form1..ctor() in C:\\Users\\User\\documents\\visual studio 2015\\Projects\\mysql\\mysql |
| Answer: |
check whether you have added a user to the database and password are correct |
| Question: |
\"server=212.86.107.43;user=pdv_denis;database=pdv_test;port=3306;password=08051997d;\" - this string, the password and username correctly, and cPanel added to the database and gave all privileges |
| Answer: |
and what is `lab312.riad.com.ua ? Access denied for user `pdv_denis`@`lab312.riad.com.ua` this server |
| Question: |
I honestly he does not understand what is this site, I just use the connection string in my program there this server |
| Question: |
maybe this is connected both with the fact that I`m using work Internet |
| Answer: |
lab312.riad.com.ua it is not our server. there are no user pdv_denis |
| Question: |
Yes, but you can see what I`m trying to connect to you, why knock such a mistake? |
| Answer: |
check nastroiki script. `lab312.riad.com.u server |
