[Classic] Database Management

Goal        

A database is a common tool for running a website.  We provide 2 types of databases for our clients: a MSSQL database, and MySQL database.  Please note we only provide one MySQL database; if you need to use the database for more applications, please use a unique prefix in order to segregate the databases. This will be covered in more detail later.

 

Create Database MSSQL

To create a MSSQL database with your account, first log in at http://support.myhosting.com, then click on the Windows Hosting tab up top.

C:\Users\nikolay.petrov\AppData\Local\Microsoft\Windows\INetCache\Content.Word\1.png

Once under the Windows Hosting tab, you will be able to click on the Microsoft SQL Database link on the far left menu tree.

 

 

In most cases, you will not have any databases created yet. You will need to create one: simply click on Add a New SQL Database.  There, you can choose either an SQL 2000, or an SQL 2008 platform.

 

We offer one free 25MB database for MSSQL. If you require a larger database, please choose the appropriate size from the list.

Finally, you will need to create a strong password for your database. Please read the requirements carefully on the password page to ensure your password meets the criteria.

 

 

Create Database MySQL

 

The MySQL database is created automatically when you either sign up for a Linux server or if you have a Linux sub site.  The create the sub site, and database you simply need to click on the Linux sub site tab up top.

If the site is not already created, you will be requested for a subdomain in order to continue.  Simply specify the sub as you want it and complete the creating. Please note that it may take up to 1 hour for you to be able to use the Linux server.

Once available simply click on the MySQL Administration link on the far left menu tree. C:\Users\nikolay.petrov\AppData\Local\Microsoft\Windows\INetCache\Content.Word\5.png

 

 

Simply use the above link to access the mysql database manager called phpmyadmin.  This will allow you to manage the database provisioned for you. Please note we only provide one mysql database per subscription.   Therefore if you need to use another database then you will need to use a unique prefix when doing the install.  All web applications will require that you enter your database information, or mysql databases simply find the section called prefix.  There simply enter any text, which be used as a prefix in from of all database name.

 

Manage MSSQL Database With My Little Admin

If you need to manage your database you can do so with our database management tools.  Access it within the database section, on the left menu tree choose the Microsoft SQL Database

 

 

Once you access the page, just simply click the continue button to open the manager. When you open the manger you will see three folders on the left, expand the User database to access your database.  Once you have expanded ti you will see Tables, this is where you will find your database information stored.

 

 

 

 

Manage MySQL Database With PHPmyadmin

.If you want to manage your mysql database then you will need to first click on the Linux sub site tab up top.  There you can click on the MySQL administration link on the far left menu tree.

 

 

On the next page you will see your mysql login information, you will need this for the next step so record it to make it available. Simply click the administer your mysql account link to open the manager

C:\Users\nikolay.petrov\AppData\Local\Microsoft\Windows\INetCache\Content.Word\5.png

 

You will then be prompted for you login credentials, simply enter them as you saw it on the previous page.  Please note the password for the mysql server is the same as your main account.

 

Once logged in you will see all your tables on the far left, you can simply click on the browse icon to review data stored in those tables.

 

Conclusion

The database is a very powerful tool for storing and managing data.  Most web applications require a database and will not function without them as such databases are now a must in the industry.  Knowing how to manage them is not necessary as the applications will use them.  
That being said knowing how to access them and make minor changes it is handy to know how.

 

Was this article helpful?
0 out of 0 found this helpful

Have more questions? Contact our support instantly via Live Chat