Support / KnowledgeBase

 
Search the KnowledgeBase Search
feedCurrently Browsing: Databases and MySQL
Launch

Database Privileges on the Grid Applies to: Grid Difficulty: Med Time Needed: 10 Tools Required: None Overview The Grid's database SmartPool is a shared hosting platform, but still is capable of running quite a bit of complex processes. However, since this is the case, certain database commands can not be run on the Gr ... Applies To: Grid

Launch

Backing Up Site Content on the Grid Applies to: Grid Difficulty: Medium Time Needed: 20 Tools Required: FTP, SSH Overview The Grid doesn't come with built-in backup functionality. In general, you'll want to backup your website data using a third-party FTP client or a specialized backup tool. Below you'll find a list of so ... Applies To: Grid

Launch

Getting started with your MySQL GridContainer Applies to: Grid Difficulty: Easy Time Needed: 10 Tools Required: Account Center 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 GridCo ... Applies To: Grid

Launch

Managing Database Users on the Grid Applies to: Grid Difficulty: Easy Time Needed: 10 Tools Required: Account Center access Overview This article provides instructions on how to change the password for database users on the Grid. You can find more database information within your Server Guide. Database User Types On th ... Applies To: Grid

Launch

How do I change or update account passwords? Applies to: Grid Difficulty: Easy Time Needed: 10 Tools Required: Account Center access Applies to: DV Difficulty: Easy Time Needed: 10 Tools Required: Account Center access, Plesk adminsitrator access Applies to: DV 4.0 Difficulty: Easy Time Needed: 10 Tools Required: Account Center acce ... Applies To: (dv) 4.0, DV, Grid

Launch

How do I generate a MySQL report? Applies to: Grid 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 MyS ... Applies To: Grid

Launch

Errors logging into phpMyAdmin Applies to: Grid 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 you ... Applies To: Grid

Launch

Setting up External MySQL Connections Applies to: Grid 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 N ... Applies To: All DV, Grid

Launch

How do I create a database? Applies to: Grid Difficulty: Easy Time Needed: 10 Tools Required: Account Center access Applies to: DV Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access Applies to: DV 4.0 Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access Overview ... Applies To: All DV, Grid

Launch

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

Launch

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

Launch

Addressing large databases on the Grid Applies to: Grid Difficulty: High Time Needed: 60+ Tools Required: SSH, phpMyAdmin Overview This KnowledgeBase article is intended for Grid users whose database needs exceed the reasonable thresholds of a shared hosting environment. With a standard Grid, the size limit for databases is 4G ... Applies To: Grid

Launch

Default MySQL character set and collation Applies to: Grid 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 common ... Applies To: All DV, Grid

Launch

Making it Better: Basic MySQL performance tuning (MySQLd) Applies to: Grid 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 M ... Applies To: (dv) 4.0, All DV, DV, Grid

Launch

Export and import MySQL databases Applies to: Grid Difficulty: Medium Time Needed: 20 Tools Required: SSH Applies to: All DV Difficulty: Medium Time Needed: 20 Tools Required: SSH CloudTech Can Help! If you’re having trouble with the steps in this article, additional assistance is available via CloudTech, our premium ... Applies To: All DV, Grid

Launch

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

Launch

Why can't I connect to my MySQL database from PHP? Applies to: Grid 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 on ... Applies To: All DV, Grid

Launch

Using MySQLTuner Applies to: Grid 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 make ... Applies To: All DV, Grid

Launch

Dreamweaver - PHP/MySQL Configuration Applies to: Grid 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: All DV, Grid

Launch

Tunnel local MySQL server through SSH Applies to: Grid 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 develo ... Applies To: All DV, Grid

Launch

Create timestamped database backups Overview This article will walk you through how to create timestamped database back-up of your website on the Grid. READ ME FIRST This article is provided as a courtesy. Installing, configuring, and troubleshooting third-party applications is outside the scope of support provided by (mt) Medi ... Applies To: Grid

Launch

How do I connect to a MySQL database using Sequel Pro? Applies to: Grid 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 Grid access domain. You can find ... Applies To: Grid