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

How do I 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. CloudTech Can Help! If you’re having trou ... Applies To: All DV

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

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

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

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

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 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. ... Applies To: All DV

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