954,593 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

how to make a remote mysql server to be accessed

hi there
when im trying to connect to a remote mysql server im getting an error

i searched for it and i came to know that MySQL database server remote access disabled for security reasons by default
and they provided with lot of steps to enable it

the problem is it is also not working
im attaching the page with it

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

plz anybody help

thank u very much

swapna7999
Junior Poster in Training
84 posts since Apr 2008
Reputation Points: 10
Solved Threads: 0
 

What was the error you got? Did you enable the remote access for mysql user?

mwasif
Posting Whiz
315 posts since Dec 2007
Reputation Points: 29
Solved Threads: 48
 

You need to speak with your webhosting admin if he can do it for you (depends on company policy), this something that you as the client have no access to...

peter_budo
Code tags enforcer
Moderator
15,436 posts since Dec 2004
Reputation Points: 2,806
Solved Threads: 902
 

when i want another website on another server to access my db i do it from cpanel.

cpanel - mysql database - near bottom u see
Host (% wildcard is allowed): ip_here [add host]

amigura
Junior Poster in Training
72 posts since Jan 2008
Reputation Points: 11
Solved Threads: 7
 

T he error is cannot connect to mysql server (ip)

swapna7999
Junior Poster in Training
84 posts since Apr 2008
Reputation Points: 10
Solved Threads: 0
 

when i want another website on another server to access my db i do it from cpanel.

cpanel - mysql database - near bottom u see Host (% wildcard is allowed): ip_here [add host]


i dont understand can u explain

swapna7999
Junior Poster in Training
84 posts since Apr 2008
Reputation Points: 10
Solved Threads: 0
 

do you have cpanel access?
if no then forget wat i said. if you have cpanel access then login and click on mysql database, near the bottom you will see Host (% wildcard is allowed): - add in ip you want to access db.

amigura
Junior Poster in Training
72 posts since Jan 2008
Reputation Points: 11
Solved Threads: 7
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You