purepast Posted April 26, 2017 Posted April 26, 2017 Hello, I'm having a problem with my remote connection to MySql.Error: MySqlException: Access denied for user 'purepast_root'@'201.17.240.159' (using password: YES) Quote
wolstech Posted April 26, 2017 Posted April 26, 2017 Did you add that IP to the remote mysql list in cPanel? If not, you need to do so before it will work. Also, does a user named purepast_root exist? The default username for mysql on your account is your cPanel username. If you didn't explicitly create it, you should either use your cPanel username (purepast), or create a DB user named purepast_root and assign it to the database. Quote
purepast Posted April 26, 2017 Author Posted April 26, 2017 (edited) Screenshots: https://imgur.com/a/2IT4W https://imgur.com/a/g4mfg https://imgur.com/a/3xKxS Code: (C#) var connString = "Server=64.62.211.131;Database=purepast_bd_compradores;Uid=purepast_root;Pwd=<removed>"; Edited April 26, 2017 by Krydos removed password Quote
wolstech Posted April 26, 2017 Posted April 26, 2017 That first screen shot is wrong. It needs to have the source hostname or IP where your program is (not the destination server), added. You need to add 201.17.240.159 to that list. Quote
purepast Posted April 26, 2017 Author Posted April 26, 2017 Ohh i got it. But only i will can connect in this database? or when i send my program for other people, he will connect too? Quote
Krydos Posted April 26, 2017 Posted April 26, 2017 If you want any IP to connect to the database then put a % there instead of the IP. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.