Managing MySQL in myhosting.com onCloud(tm) for Shared Hosting

This article will help you manage your myhosting.com Shared Hosting MySQL database in our new onCloud(tm) Control Panel. For help managing your MySQL database in your myhosting.com Classic Control Panel, here.

 

Accessing and Managing MySQL

All database management must be done through the browser-based tool, phpMyAdmin

1. Login to your customer control panel at https://manage.myhosting.com 
2. Click on Home tab
3. Click on Databases under More Services
4. Click on the database you wish to manage or click Add New Database to create one.
5. Click on the link provided in Browse database manager
   

 

Number of Databases

Customers receive 3, 5 or 10 MySQL databases free depending on what plan they signup for. Additional MySQL databases can be purchased for $1.00 per month per database.

 

Connecting with ASP.NET

Customers will be able to connect to their MySQL database with ASP.NET using MySQL Connector/NET.

 

Importing MySQL Data

If you have exported MySQL data in a text file, you can import it to your MySQL database by following these steps.

1. Browse to your MySQL database administration through your customer control panel.
2. Once logged in, on the left frame at the top you should see a phpMyadmin logo, and below that the text "Home". Just below that you should see the name of your database, which would be your applicable "domain_com". Click on that link.
3. Click on the "SQL" tab which will load in the right frame.
4. Click on the "Browse..." button to locate your MySQL file, and import the data to your database.

NOTE: There is a limit of 8 MB per file. If you need to import more than 8 MB at a time, you'll need to split the data up into multiple files.

 

MySQL Documentation

There is plenty of documentation available to you in the browser-based tool phpMyAdmin which you can find in your account control panel by clicking on MySQL Administration under the Site Managementsection in the Linux Account link. You can also find lots of information at http://www.mysql.org or http://www.phpmyadmin.net.

 

Error Message #1044 - Access denied for user: 'username_com@localhost' to database > databasename'

The above error message is displayed because you are attempting to create a database in addition to the one you were provisioned with when you signed up for a MySQL database. Simply remove the code you used to create your new database and modify the database you were provisioned with to include information you want displayed in your database. All database management must be done through the browser-based tool, phpMyAdmin, which you can access easily by browsing to http://yourdomain.com/phpMyAdmin.

 

Managing VPS MySQL with Plesk

Managing your VPS MySQL with Plesk

 

Managing VPS MySQL with cPanel

Managing your VPS MySQL with cPanel