MySQL

From myhosting.com Wiki

Jump to: navigation, search

Contents

Accessing and Managing MySQL

All database management must be done through the browser-based tool, phpMyAdmin, which you can access easily by browsing to http://www.yourdomain.com/phpMyAdmin.

Replace "yourdomain.com" in the above URL with your actual domain name.

You will be prompted to login, please note that your username will be the same as your administrative username, except in lowercase. Also, replace any dots with an underscore character. For example: yourdomain_com. Your password will be the same as your account password.

All MySQL database server daemons listen on localhost. Thus, when configuring a website to use a MySQL database, please ensure that the Host parameter is set to localhost. Please note that this means that it is not possible to connect to your MySQL database from a remote host.

Number of Databases

Customers who have subscribed to the FREE MySQL database are allowed to have ONE (1) database .

Connecting with ASP.NET

At this time it is not possible to do this directly from ASP.NET to MySQL. If you want to make a direct connection from ASP.NET to a MS SQL database, you would need to subscribe to one of our Windows hosting plans and use the available MS SQL option.

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 http://www.domain.com/phpmyadmin. Make sure you replace "domain.com" with your actual domain name.
  2. You will be prompted to log in. Your username will be your applicable domain_com, and your password is the same as your hosting account admin password.
  3. Once logged in, on the left frame at the top you should see a phpMyadmin logo, and below that a row of buttons. Just below that you should see the name of your database, which would be your applicable "domain_com".
  4. Now click on the little "SQL" button which will open a popup window.
  5. Click on the "Import files" tab.
  6. Click on the "Browse..." button to locate your MySQL file, and click "Go" to 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.

Retrieved from "http://myhosting.com/wiki/MySQL"
Personal tools