Q&A Regarding Database Password Updates (March 2010) This article has been provided to help answer some of the common questions customers may have regarding the "Database User Password Change" email notification that was sent to (gs) Grid-Service customers. Question: Who does this change affect? Answer: All (mt) Media Temple customers with at ... Applies To: (gs)

What is the root username for MySQL? For (dv) Dedicated-Virtual Servers Plesk renames the 'root' account for mysql to 'admin'. Whenever referring to any documentation regarding MySQL's root user just consider this user 'admin' on your server. This article has been mirrored from the Parallels Knowledge Base as a courtesy to our ( ... Applies To: All (dv)

Using MySQLTuner on your Dedicated-Virtual Server This guide will show you how to install MySQLTuner. This script will provide various tips for optimizing MySQL on your Dedicated-Virtual Server. This article has the following dependencies: If you currently do not have your root user enabled or our Developer Tools installed please visit the ... Applies To: All (dv)

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

Using (remote) MS-SQL databases with PHP on a (dv) This article has the following dependencies: If you currently do not have your root user enabled or our Developer Tools installed please visit the Root Access & Developer Tools section of your AccountCenter. Whenever installing Third-Party software please consult the official documentati ... Applies To: (dv) 2.0, (dv) 3.0

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

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

Upgrade to PHP5 and MySQL 4.1x on (dv) 2.0 Dedicated Virtual Servers This article provides a general walkthrough on how to upgrade to PHP5 and MySQL 4.1x on a (dv) 2.0 Dedicated Virtual Server. If you do not wish to install PHP5 please refer to our MySQL 4.1x article. This article has the following dependencies: If you currently do not have your root user en ... Applies To: (dv) 2.0

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)

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)

Accessing phpMyAdmin The following guide will show you some basic actions you can perform on your MySQL Databases from within phpMyAdmin, which you can access from your AccountCenter. WARNING: Before considering making any changes to your database(s) please read the following article: How can I backup and Restore ... Applies To: (gs)

(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) Database naming scheme All new databases created on the (gs) platform have their named using the following convention: db#####_db_name_here The database username can be found in the AccountCenter under 'Manage Databases' A sample database name would look something like: db0001_wordpress_comments If your site wa ... 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)

Setting up external MySQL connections This walkthrough will show how to enable non-localhost connections to databases. This document does not apply to the (ss) or (gs) product line and is not technically supported by (mt) Media Temple. The authoritative answer on this can be found here: http://dev.MySQL.com/doc/MySQL/en/Access_de ... Applies To: (dpv) Nitro, All (dv)

HOWTO: GRANT privileges in MySQL OVERVIEW: Since Plesk does not allow GRANT privileges to users via the Plesk Control Panel you will need to create those permissions via the command line. NOTE: Changing the grants on your "admin" user could potentially lock you out of your Plesk Control Panel. Should this happen please co ... Applies To: (dpv) Nitro, All (dv)

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)

How do I enable remote access to my PostgreSQL server? The default configuration of PostgreSQL does not allow incoming connections from external machines. This article has been mirrored from the Parallels Knowledge Base as a courtesy to our (dv) Dedicated-Virtual Server customers. As they are the authoritative source of the information covered in ... Applies To: (dpv) Nitro, (dv) 3.0, (dv) 3.5

(dv) HOWTO: Basic MySQL performance tuning (MySQLd) Pre-requisites: (dv)2.0 Dedicated Virtual Server - Only if you have successfully upgraded MySQL via either of the following KB articles Upgrade to PHP5 and MySQL 4.1x on (dv) 2.0 Dedicated Virtual Servers Upgrade to MySQL 4.1x on (dv) 2.0 Dedicated Virtual Servers without PHP5 (dv)3.x Ded ... Applies To: (dpv) Nitro, All (dv)

(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)

auto_increment flag in MySQL tables lost after Plesk migration We have discovered a bug in the Plesk Migration Tool when migrating from a (dv) 3.0 to a (dv) 3.5 server. Imported MySQL databases will lose the auto_increment flag on all of the database tables. The following workaround will automatically re-dump all the data from your source (dv) 3.0 server ... Applies To: (dv) 3.0, (dv) 3.5

(dv) Increasing Max MySQL Connections NOTE: The authoritative source for this information may be found at the following URL: http://dev.MySQL.com/doc/refman/4.1/en/too-many-connections.html Details: To increase the maximum connections that mysql allows, you must edit the file /etc/my.cnf. Log into the server as root, and type t ... Applies To: (dpv) Nitro, All (dv)