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)
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.
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
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.
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?
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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now