Mysql Remote Access

[mriffey]

Hi,

 

I have simple reseller account, among others:)

 

I have looked around in the FAQs for this info but cannot find it. I need to access my reseller account's MySQL databases via a program here on my machine. I do this all the time with our MSSQL databases, but cannot connect via any MySQL tools to our databases at TCH.

 

I suspect that this is because access has not been enabled for my databases or userid or machine or <g>.

 

How can I get this done (as I think - hmm, this should be a help desk ticket most likely).

 

Mark

[borfast]

Hi Mark, and welcome to the family!

 

You can configure MySQL access permissions on cPanel by following the "Manage Mysql" link on cPanel "Databases" section.

 

If you have any other problems, don't hesitate to ask!

[mriffey]

Hi Raul,

 

I realize that configuration is done via Cpanel:)

 

The issue isnt configuration, its actually updating and reading through the database from a remote location. Remote configuration using MySQL Front and similar tools would be a bonus of having remote access, but that is not the prime reason for needing to access the database programmatically from a remote location. Data access is.

 

Mark

[TCH-Bruce]

Take a look at this Great Links post it may help.

[mriffey]

Hi Bruce,

 

Thanks for the link. Unfortunately, that too is an administrative tool.

 

To clarify, my need is this:

 

Using a Windows or Linux program here on my desk, I need to be able to open my databases hosted at TCH and read/write data in their tables.

 

Typically it is necessary to grant access via MySQL to my computer/IP in order to allow this sort of processing. I know how to do this when I have root access to MySQL, but I obviously dont have that sort of access to TCH-hosted MySQL:)

 

I'll file a support request.

 

Mark

[TCH-Bruce]

OK, I did a search of the forum and found this thread that may help.

[borfast]

Hi Mark

 

Either I'm missing something obvious here or I didn't explain myself well in my last post.

 

If you click the "Manage MySQL" link on cPanel, you'll be presented with a page where you have a "Access Hosts:" section. You may specify the hosts there.

 

Let me know if this is what you need.

[kahill]

Is there an online resource or tutorial for definitions or examples of how to set up remote connection to mysql?

 

I also have Navicat and a programming utility that needs

host

username

password

database

 

I am very unclear as to what to put into "host" - my IP or the "web host server IP" or what? I also don't understand how to use PHPmyadmin to set the host (if that is how it is established). A detailed tut with examples would be good for a newb like me :Nerd:

[TCH-Rob]

host = localhost

username = cpanelname_username

pass = pass

db name = cpanelname_dbname

 

PHPMyAdmin

 

Create DB

Create user

Add user to DB

Edit program config file

Connect to DB

Treat yourselt to Krispy Kreme for 5 minutes well done

[kahill]

My KK has to wait - I still get the error message:

"no connection could be made because the target machine actively refused it".

 

I've done almost every possible connection imaginable for 2 hours. still no go.

 

I bought what seems to be a pretty cool utility for php form generation and need this type of access to upload the files generated to the server. I'm afraid that since I'm new to networking issues - I don't understand how to configure the fields properly. I think it is a classic case of information overload