Support / KnowledgeBase

System Paths for (dv) 4.0 TIP: This page has moved. Please see: System Paths. Applies To: (dv) 4.0

Making it Better: Basic MySQL performance tuning (MySQLd) Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, phpMyAdmin access Applies to: All (dv) Difficulty: Medium Time Needed: 20 Tools Required: SSH, root, vi knowledge Introduction The following is just one simple way to get started with optimizing your ... Applies To: (gs), All (dv)

Dreamweaver - PHP/MySQL Configuration Applies to: (gs) Difficulty: Easy Time: 10 Tools needed: Dreamweaver Applies to: All (dv) Difficulty: Easy Time: 10 Tools needed: Dreamweaver Overview This article will help you configure a PHP and MySQL testing server in Dreamweaver. READ ME FIRST (mt) Media Temple does not suppor ... Applies To: (gs), All (dv)

Setting up external MySQL connections Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, SSH Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: SSH Introduction When attempting to connect externally to your MySQL server through a database-management software, such as ... Applies To: (gs), All (dv)

Tunnel local MySQL server through SSH Applies to: (gs) Difficulty: Medium Time Needed: 10 Tools Required: SSH Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: SSH Overview This article explains how to tunnel a MySQL connection through SSH. This is useful when you want to execute MySQL commands or deve ... Applies To: (gs), All (dv)

What is the root username for MySQL? Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: vi knowledge, root access Overview 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 ad ... Applies To: All (dv)

Export and import MySQL databases Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: SSH Applies to: All (dv) Difficulty: Medium Time Needed: 20 Tools Required: SSH Overview This article will show you how to export a copy of your MySQL database, and how to import an SQL database backup file to your da ... Applies To: (gs), All (dv)

Managing a MySQL database with phpMyAdmin Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: AccountCenter access, database user login Applies to: (dv) 4.0 Difficulty: Medium Time Needed: 20 Tools Required: Plesk administrator access, database user login Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 20 Too ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

(gs) Backing Up Site Content Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: FTP, SSH Overview This list is not meant to be comprehensive, but rather more of an introduction. There are other tools available for your operating system that would work equally well. These can range from both manual ... Applies To: (gs)

How do I increase the MySQL connections for my server? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: None Applies to: (dv) 4.0 Difficulty: Medium Time Needed: 10 Tools Required: SSH, vi knowledge Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 10 Tools Required: SSH, vi knowledge Overview The MySQL SmartPool v.2 ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

Using MySQLTuner Applies to: (gs) Difficulty: Medium Time Needed: 60 Tools Required: SSH, MySQL GridContainer Applies to: All (dv) Difficulty: Medium Time Needed: 60 Tools Required: SSH, root Overview MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and mak ... Applies To: (gs), All (dv)

Default MySQL character set and collation Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: None Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: None Overview The default character set for MySQL at (mt) Media Temple is latin1, with a default collation of latin1_swedish_ci. This is a commo ... Applies To: (gs), All (dv)

(gs) Database naming scheme Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Introduction All new databases created on the (gs) Grid-Service follow this naming pattern: db00000_dbname Viewing databases You can view all of your database names in the AccountCenter. Log into ... Applies To: (gs)

HOWTO: Change or update various account passwords Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Applies to: (dv) 4.0 Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, Plesk adminsitrator access Applies to: (dv) 3.5 Difficulty: Easy Time Needed: 10 Tools Required: AccountCent ... Applies To: (gs), All (dv)

How do I install PostgreSQL on my server? Applies to: (dv) 4.0 Difficulty: Medium Time Needed: 10 Tools Required: SSH, root access, vi knowledge Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 10 Tools Required: SSH, root access, vi knowledge Overview PostgreSQL is an open source object-relational database system. Postg ... Applies To: (dv) 3.5, (dv) 4.0

How do I create a database? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Applies to: (dv) 4.0 Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access Applies to: (dv) 3.5 Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access ... Applies To: (gs), All (dv)

Create a MySQL database for (dv) 4.0 TIP: This page has moved. Please see: How do I create a database? Applies To: (dv) 4.0

Getting started with your MySQL GridContainer Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Overview The MySQL GridContainers are designed for customers who demand guaranteed performance and absolute reliability for their hosted database systems. For more general details on our MySQL GridCon ... Applies To: (gs)

How do I generate a MySQL report? Applies to: (gs) Difficulty: Medium Time Needed: 30 Tools Required: AccountCenter access, MySQL GridContainer Applies to: All (dv) Difficulty: Medium Time Needed: 60 Tools Required: SSH, root or sudo access Overview The following will show you the steps to run a MySQL Report on your ... Applies To: (gs)

Accessing phpMyAdmin TIP: This page has moved. Please see: Managing a MySQL database with phpMyAdmin. Applies To: All Service Types

HOWTO: GRANT privileges in MySQL Applies to: All (dv) Difficulty: Medium Time Needed: 20 Tools Required: SSH, root access 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 "adm ... Applies To: All (dv)

How to install PostgreSQL on your (dv) 3.5 TIP: This page has moved. Please see: How do I install PostgreSQL on my server? Applies To: (dv) 3.5

How do I enable remote access to my PostgreSQL server? Applies to: All (dv) Difficulty: Medium Time Needed: 10 Tools Required: SSH, root or sudo access, vi knowledge, PostgreSQL installed Overview The (dv) Dedicated-Virtual Server does not come with PostgreSQL pre-installed. The default configuration of PostgreSQL does not allow incoming co ... Applies To: All (dv)

Errors logging into phpMyAdmin Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: MySQL database user login credentials Symptoms It's not unusual to type in an incorrect username or password when logging into phpMyAdmin. However, a failed login can sometimes lead to a frustrating experience: When y ... Applies To: (gs)

FAQs on PostgreSQL EOL Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, SSH Overview EOL is an acronym for End Of Life. Hosting related technology and services develop quickly and are constantly changing. Periodically, some products become antiquated or deprecated due to ... Applies To: (gs)

Database users on the (gs) Grid-Service Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Overview This article provides instructions on how to change the password for database users on the (gs) Grid-Service. You can find more database information within your Server Guide. Database User T ... Applies To: (gs)

Edit my.cnf for MySQL GridContainer Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: AccountCenter access, MySQL GridContainer Overview The MySQL my.cnf editor allows you to directly edit your MySQL server's my.cnf configuration file. Editing this file can dramatically increase your MySQL performanc ... Applies To: (gs)

How do I connect to a MySQL database using Sequel Pro? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: Sequel Pro Overview The following article will show you how to setup Sequel Pro to make a secure connection to your MySQL Databases. Requirements Before you start, you'll need: Your (gs) Grid-Service access domain. ... Applies To: (gs)

(gs) How do I create a database? TIP: This page has moved. Please see: How do I create a database? Applies To: (gs)

Setting up external MySQL connections TIP: This page has moved. Please see: Setting up external MySQL connections. Applies To: (dv) Nitro, All (dv)

auto_increment flag in MySQL tables lost after Plesk migration Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 20 Tools Required: SSH, root access, vi, Developer Tools Overview 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 ... Applies To: (dv) 3.0, (dv) 3.5