Jump to content
Sign in to follow this  
tweakbox

Remote Access Of Mysql Database

Recommended Posts

Is it possible to access my MySQL database remotely? I want to access it from a program I'm writing, but I don't know what the IP or port number is that I need to connect to.

Share this post


Link to post
Share on other sites

Hi,

 

yes it is possible.

 

In cpanel, manage mysql, you need to add the IP address you wish to access from to the list of permitted hosts.

 

You then access it via your domain name / IP address and port 3306

Share this post


Link to post
Share on other sites

Another quick question. What if my IP address is not static or I don't know the IP of everyone that I want to grant access via the program? I was reading something that said you can set up the username to accept connections from any host using the grant command. Is it possible to do that?

Share this post


Link to post
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.

Guest
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.

Sign in to follow this  

×
×
  • Create New...