MySQL~ Login

[Ashley-Kat]

I have hostees on my site and one just asked for a MySQL database.
I don't want her to use my main Cpanel to login into it...
How can she login without using my main account?

Thank you.

[shadmego]

Ok. I just tested this and it worked, though I am not sure if it will work for your clients. You will need to do a few things to prep remote access to the databases first ... namely, create the database and user name + access level for the database your clients will be using.

You can have your clients download this program:

SQLyog MySQL GUI - Community Edition
(http://www.webyog.com/en/SQLyog)
I only used it to test connections to the database, not modify any table settings. The Community Edition is free, and there are other programs out there that, in my opinion, do not seem as easy to use. I say seem because I have not tested them.

You will also have to add your client's ip addresses to two white lists (I think). Try the first, and if it doesn't work, do the second one as well. The most important whitelist is the firewall whitelist. You can add your own IP address yourself, but any other addresses will have to be added by Support, if they allow it (and they should).


Add the IP address to the whitelist in the firewall yourself -- Note this will only add the IP address of the computer you logged into your account with. To try and add another IP address, you will have to ask Support via Live Chat or email support.

Log into your account
go to www.hostmonster.com (http://www.hostmonster.com)
upper right ... domain name + password
On the topmost menu, click on the "Profile" butto
Scroll down until you see Preferences and click to "Edit Preferences"
Follow the prompts there to add either a range of addresses, or your specific address and save the changes.

Add the client's IP address to the remote MySQL access list
Log into your CPanel
In the Databases, click the "Remote MySQL" link
Enter the IP address you want to allow for remote access and save your changes

Create the databases, usernames, passwords, and access levels for each client. You can either do this as per the client's needs, or make up your own names and give them to the client in an email or other form of communication. Note: Be aware of the naming convention used by HM when adding MySQL databases and usernames. A database named main_db on a domain name of freedatabases.com will actually be named freedata_main_db. Usernames follow the same convention.

Once the backend is preped for remote access, install the above mentioned SQL software, or any other software deemed reliable and easy to use. Connect to the database by entering the IP address of the MySQL database (your server IP address), the database name (remeber conventions!!), username, password, port number (standard 3306) and connect. All should go well.If after following these steps the connection still cannot be made, you will need to check your local firewall/router settings. You should make sure the port listed above (3306) is allowed through.

Hope that answered your question and didn't confuse you too badly. Post again if you have any other issues with this.

~regards,
Shadmego