Jump to content

[Answered] Remote Mysql To Vb.net


Recommended Posts

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!

Link to comment
Share on other sites

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.



Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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


In other words, check: http://stevie.heliohost.org:2082/frontend/x3/sql/index.html


Under "Current Databases" does the row with rafdeato_db have the rafdeato_111 user associated with it?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...