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.

  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to my database from a website not hosted at DigiServ.biz?

No, we do not allow linking to your database from a website hosted elsewhere. This is in...

I need to move my MSSQL or MySQL database over from another host

You will need to provide us with a MSSQL .bak file or all the MySQL database files from your old...

Can I connect to MySQL using my 3rd party tool?

Yes, you may.  Please read the following KB article which details how to connect using...

How do I connect to my database in my scripts?

To connect to your database from your scripts, use the connection information found on the...

How do I reduce the size of my MS SQL Log Files?

MS SQL Server Databases are set to Simple backup mode, so you shouldn't see large log...