 |
 |
 |
 |
 |
 |
 |
 |
Support Area: MySQL
Control
Center icon:
Control Center Category: Advanced Tools
NOTE: There is a comprehensive User Guide included with this tool. You can access it from within the DB Manager tool in your Control Center.
What is MySQL?
MySQL quota
Installing MySQL (the first Database)
Connecting to your database
Adding additional MySQL databases
Creating database users
MySQL Resources and Documentation
Since the bulk of the information regarding the MySQL Database Manager tool is contained in your Control Center, this page is an overview only. Specific information on running queries, managing tables, and performing advanced MySQL tasks are contained in the User Guide. You can also check the Knowledge Base MySQL category here.
MySQL is an open-source relational database management system that is fast and powerful. In conjunction with programming and scripting languages such as PHP, Perl, CGI and C++, you can create dynamic content for your web sites. We offer 2 tools for use with MySQL: the DB Manager and the advanced NetBuilder tool which is part of the PowerScriptz! program.
MySQL
Quota
Although you can have unlimited MySQL databases in your account,
there is a quota for the data itself. The MySQL quota is SEPARATE from
the disk allocation and does NOT count against it.
The SimplePlan includes 50 MB of dedicated MySQL storage allocation, and more can be purchased in blocks of 50MB for $2/month. If you exceed your MySQL quota, you will need to prune your database content, or purchase additional MySQL quota. You can do this via the "Add Package" tool in your Control Center.
Installing MySQL (First Database)
When you click the MySQL button for the first time, you will see something like this:
Simply click the "Add" button and the server will create the first database for you. The first DB is always named $domain_$ext. In our example above, the domain "demosite.com" will have the first database named "demosite_com".
Allow at least 10 minutes for the server to process your request.
Most modern programs interface with MySQL via the PHP scripting language. Others still in use include Perl and CGI. Here's what you need to know regarding the connection string and other settings you may need for connecting to your databases from your web pages or software:
MySQL server
or host name: 'localhost'
IMPORTANT NOTE: The above is valid for the FIRST
(main) database you installed. For all other databases in your account,
the hostname or server name would be '$domain.com'
where '$domain.com' is your domain name without the 'www' in front.
MySQL database
name: takes the form of 'domain_ext', so for example www.xyz.com would
have a MySQL database name of 'xyz_com'
MySQL Username and Password: When first enabled, these are the same
as the Control Center username/password. You can change these if you
wish. For connection strings, enter the password exactly, including
case (lowercase/UPPERCASE etc).
Adding
additional MySQL databases
You can add as many databases as you like, subject
to the MySQL quota limit as mentioned above. Each additional DB will
take the form of $domain_$ext_$db. In the example below, the new database
will be named 'test' so the full name is 'demosite_com_test".
Creating
database users
You can now
create additional database users with specific privileges (such
as read-only, read/write, and administrator). It's easy using the
DB Manager interface:
MySQL Resources and Documentation
Want to learn more about MySQL (and PHP too)? Here are some valuable links for you:
5DollarHosting.com
Knowledge Base:MySQL
www.mysql.com
PHP/MySQL
Tutorial
PHPMyAdmin site
Back to Support Library
Can't find what you're looking for? Check out the Support FAQ & Knowledge Base or visit the new Assistance Center!
©2005
5DollarHosting.com®, all rights reserved
Terms and Conditions
