MySQL Web Hosting Options

Now Featuring MySQL 5.0! The MySQL database server is the world's most widely used open source database and can be added to any of our PHP or ASP.NET hosting packages. Its ingenious software architecture makes it an extremely fast and easy-to-use hosted database. Running on Dell Dual Xeon, RAID 5 servers, our MySQL Servers are backed up on a daily basis and optimized for MySQL database hosting security and performance. See below for directions on ordering a MySQL Server database hosting plan.

Web Designers and Resellers Host 7+ websites plus MySQL 5.0 with a single MultiPlan account and gain the benefits of Ensim Pro for Windows - the next generation Control Panel platform that provides web designers and hosting resellers with automated site provisioning, administration and management.

If you wish to add a MySQL database option to your hosting account, simply add the option when you order your hosting account. If you only need a MySQL Server database without a website, please contact our Sales Department and they will be happy to assist you.

Once your hosted MySQL database is setup by Alentus, you may need to connect directly to it and create your tables and perform other database managment tasks. If you have a pre-written PHP or ASP/.NET application, you will likely need to connect to the MySQL database and run scripts or perform other tasks needed to install the application database on the MySQL server. The sections below describe the tools available and will help you get your initial connections working.

To manage your hosted MySQL database from our on-line management console, you can use the Alentus MySQL Console (refer to your database welcome kit for specific information regarding the MySQL server you need to navigate to).

In addition to our MySQL managment console, there are a number of other tools freely and commercially available that can remotely connect and manage MySQL. If you find a tool you wish to use and it supports remote MySQL connections, most likely you will be able to use it with our server.

All Alentus web hosting plans support PHP and ASP and ASP.NET. Once your MySQL database is setup and ready for use, you can connect to it using your application software or PHP or ASP/.NET. To connect to your database you will need to code the connection strings as well as any queries and other data management functions.

To connect to the database from your application software or PHP code, you can use any of the following methods:

• Via an ODBC DSN
• ADO DSN-less connection
• Directly through PHP

In general, the connection code will be part of your web site application and you will need to set it up to connect to the correct server using your user name and password. If you are using PHP, you can connect with ODBC but it is recommended that you use the direct method instead. ASP does not support a direct connection to MySQL in the same manner that PHP does, for this you need to use ODBC or a DSN-less connection.

You may choose to any of the above methods to access the MySQL Server. If you plan to use an alternate method of connecting to your database, please contact our support department to ensure we can support the particular method you have in mind.

For information on using MySQL, MySQL Console and other MySQL database management tools, please see the following section of our Technical Support Center:

Using PHP with MySQL

---