Jump to content

Recommended Posts

Posted

hi guys, I've been wondering why can't I connect my program to remote mysql?

I know already about the "%" thing. I've already added that % in my access host.

My program is fully working, it can connect to my localhost database, and last year, I successfully connected my program to any hosting sites that allows remote-mysql.

 

here is my code:

MySqlConnection.ConnectionString = "database=1269017_rafdb;server=fdb4.awardspace.com;port=3306;user id=1269017_rafdb;password=0q0EVEBGNG"

 

note: sorry I have to remove the code tags, code is getting messy if it is inserted between code tags.

 

do I have to add port? my url in my homepage is: "http://stevie.heliohost.org:2082/frontend/x3/index.html"

so I guess my server would be stevie.heliohost.org and port is 2082 (just a guess).

is my server correct?

 

 

please! looking forward to your answer..I already tried many hosting sites, and none of them works!

Posted

hi admin, thanks for the reply. yes, I already tried with or without port=3306.

I tried connecting my "TESTER" program to connect to helionet remote mysql.

 

here, I attached a screenshot of the error.

 

and here is my code:

 

Server=stevie.heliohost.org;User Id=rafdeato_111;Password=0q0EVEBGNG;Database=rafdeato_db;Port=3306

 

of course this program is 100% working! I tried connecting it to my localhost.

please help.

 

11308_4369979652574_37699285_n.jpg

Posted

Naw, stevie.heliohost.org should be fine for the server. Either one should work though.

 

Does the user rafdeato_111 have access and permissions on the database rafdeato_db?

Posted

admin, its okay. :) That's not my main database.

Sir Shinryuu, I already tried that. :(

still : Access denied for user 'rafdeato_111'@'%' to database 'rafdeato_db'

sigh, any hosting site outputs the same error. I really did successfully connect my program to a remote mysql LAST YEAR! but now, ughhh, I don't know what is happening. .

 

sir krydos, hmmm, last year, someone told me to add "%" to allow any ip address to access the database. and I already did that in heliohost. In Remote Database Access Hosts CPANEL I added this -> "%" to access host. Perhaps since you are an admin here, could you open my account and check for the necessary settings? I know successful connection is at hand :) When I try other hosting sites, the program says unable to conenct to host.

Posted

If you click Shinryuu's link there is a section towards the bottom of the page titled "Add User To Database". Creating a user and creating a database isn't enough. You must also grant permissions to that new user on the database before they will be able to access it.

 

And you might also want to make sure you change your password for that user while you're at it.

Posted

After you click "Add" when adding the user to the database a bunch of permissions are listed and you put a check box next to each one that account will need. It's recommended for security reasons to only give the minimum permissions that each user will need.

Posted

oops! thanks admin!!! :) darn! THANKS! Before I saw your last reply, I already found the way to add users to a database! THANK YOU SO MUCH to you two! thanks thanks. This heliohost is great. Fast and free. thanksss. God Bless

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...