Q&A Regarding Database Password Updates (March 8, 2010) This article has been provided to help answer some of the common questions customers may have regarding the "Database Password Update" email notification that was sent to a select group of (gs) Grid-Service users on March 8, 2010. Question: Who does this change affect? Answer: Your database ... Applies To: (gs)

How can I tunnel a local MySQL server through SSH? This article details how to tunnel MySQL connections through SSH. This is handy when trying to execute MySQL commands from a location other than your server or when developing applications remotely. Step 1 - Set up the tunnel First we must set up a local tunnel on a port so local commands wil ... Applies To: (gs)

How can I Backup and Restore a MySQL database? Details METHOD 1 - PHPMyAdmin You can use PHPMyAdmin to backup/restore your database if it is relatively small (~10MBs) If your database is larger than that please skip to METHOD 2 - command line BACKUP: Select the database you'd like to back up from the column on the left Click on "Export" ... Applies To: All Service Types

Connect to MySQL on the (gs) Grid-Service using Sequel Pro The following article will show you how to setup Sequel Pro to make a secure connection to your MySQL Databases. Things you will Need: Your (gs) Grid-Service Access Domain: You can find your access domain within the Server Guide which is located in your AccountCenter. Your access domain sho ... Applies To: (gs)

Dreamweaver MX - PHP/MySQL Configuration NOTE: This article will help you configure a PHP/MySQL testing server in Macromedia Dreamweaver. Although this is Third-party software, and we do not support Third-party software configurations, we have created this article as a courtesy to our customers. DETAILS: First, create a "Site" t ... Applies To: All Service Types

(gs) External MySQL Database Access using desktop-based software Summary: When attempting to connect externally to your MySQL server through a database-management software, such as Navicat or MySQL GUI Tools, you will run into problems being able to connect. Typical error messages include "Lost connection to MySQL server" or "Access Denied", or some other te ... Applies To: (gs)

MySQL Container my.cnf editor NOTE: Unsupported Article The methods described in this article are to be attempted by EXPERT USERS ONLY. The only support provided for this advanced configuration is the "Revert to Original" option which will restart your MySQL container with your original default values. Please consult ou ... Applies To: (gs)

(gs) MySQL 3.23 to 4.1 breaks table collation NOTE: This article is written in response to a Drupal issue, but it may be applicable to other applications as it addresses an issue with certain applications not using the default collation set for MySQL databases. If you are seeing an error message such as this after migrating from (ss) to the ... Applies To: (gs)

Getting started with your MySQL GridContainer DETAILS: The new MySQL containers are designed for customers who demand guaranteed performance and absolute reliability for their hosted database systems. For more general details on our MySQL Containers. Below is a table that explains RAM size, MySQL User limits, and MySQL Connection limits for ... Applies To: (gs)

Generating a MySQL report for your MySQL container The following will show you the steps to run a MySQL Report on your MySQL GridContainer. This report generates a large, comprehensive report that displays values for practically every MySQL server statistic available, along with explanations. Use this report to analyze specific areas of your My ... Applies To: (gs)

Why can't I connect to my MySQL database from PHP? The following information can help you resolve connectivity issues with your databases on your (mt) Media Temple service. NOTE: Text in this color is used as an example. Please be sure to replace this text with the proper information for your site or server. Be sure to replace #### with your ... Applies To: (gs), (ss)

Default MySQL character set and collation DETAILS: All versions of MySQL on (mt) Media Temple server are installed with the default character set 'latin1'. The default collation for latin1 is 'latin1_swedish_ci' which in most cases does not cause any problems. If you have a (gs) Grid-Service and wish to change the character set of a M ... Applies To: All Service Types

(gs) How can I create a MySQL/PostgreSQL Database? This article will explain how to create a MySQL or PostgreSQL Database on the (gs) Grid-Service. Create a Database Login to your AccountCenter Click on your Primary Domain Click on Manage Databases Click on the Add a Database tab Type in your database name, and choose your database ty ... Applies To: (gs)

(gs) How can I create a Database User and set permissions? This article will show you how to create a database user on the (gs) Grid-Service. It will also show you how to change permissions for that database user as well. Create a Database User Login to your AccountCenter Click on your Primary Domain Click on Manage Databases: Click on Global Se ... Applies To: (gs)