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)

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)

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 a ... Applies To: (gs), All (dv)

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

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 ma ... 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 use ... Applies To: All (dv)

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)

Using MySQL Report on a (dv) Dedicated-Virtual Server TIP: This page has moved. Please see: How do I generate a MySQL report? Applies To: All (dv)

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 y ... 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 The default character set for MySQL at (mt) Media Temple is latin1, with a default collation of latin1_swedish_ci. This is a common type of ... 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 T ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

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 dev ... Applies To: (gs), All (dv)

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)

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 d ... 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 support ... Applies To: (gs), All (dv)

Why can't I connect to my MySQL database from PHP? Applies to: (gs) Difficulty: Medium Time: 30 Tools needed: AccountCenter access, FTP Applies to: All (dv) Difficulty: Medium Time: 30 Tools needed: Plesk administrator access, FTP Overview This article contains the basic information you need to connect from PHP to your MySQL database ... Applies To: (gs), All (dv)

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 ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

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

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