Client Area
All-in-one service management,
billing & support, conveniently & securely
in one single feature rich place.

Portal Home > Knowledgebase > Windows Hosting > Windows (Helm USA) > Databases > How do I edit my MySQL database?


How do I edit my MySQL database?




There are two ways to edit your MySQL Database.

A. You can connect to your databases online by visiting http://db.yourdomain.com/. There you can choose PHPMyAdmin, a full-featured web management tool for MySQL. On the login screen, choose the DB server your DB was created on (this can be found by clicking the Database Manager icon in Helm from your domain's main menu, then clicking the DB you want to edit), and the username and password of the MySQL database you have already set up in Helm. You will then have web-based ability to edit your database such as creating new tables, running queries, and inserting data.

B. You can download and use a tool such as MySQLFront (visit http://www.mysqlfront.de/).  This tool is an excellent DB management tool that you install on your computer, very much like MS SQL Enterprise Manager.

To connect using a client tool, do the following steps:

Open a web browser and connect to https://72.29.120.108 (the http part is necessary) and enter "emanager" for both username and password. You will receive a "successfully authenticated" message. You need to do this every time before you can connect to the MySQL servers.

Once you have authenticated, you can connect with your 3rd party client db management tool.  The basic info you'll need are as follows:

For Server, enter the following (depending on which database server your DB was created on) :

72.29.120.101 for INFDB1
72.29.120.112 for INFDB2
72.29.120.250 for INFDB3
72.29.120.130 for INFDB4
72.29.120.124 for INFDB5

Enter your DB name as the exact username and password you created when you created the MySQL DB through Helm.  The port to use is 3306.

Remember, you will need to authenticate to the website above before you can connect to the MySQL servers.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read