Support / KnowledgeBase

 
Search the KnowledgeBase Search
feedCurrently Browsing: Databases and MySQL
Launch

Export and import MySQL databases Applies to: WordPress Hosting Difficulty: Medium Time Needed: 20 Tools Required: Account Center access 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 hav ... Applies To: All DV, 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

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

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

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

MySQL Binary Logs and Disk Space Applies to: DV 4.0 Difficulty: Easy Time Needed: 10 Tools Required: root access, SSH Overview If your DV 4.0 is running out of disk space and binary logging (replication) is enabled in MySQL, you can purge these logs and disable future logging to prevent this from occurring again. Ch ... Applies To: (dv) 4.0

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