Knowledgebase
You are here: MyAccount Portal > Knowledgebase > MySQL

The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.

Categories

Optimised MySQL Configurations (2)

Articles

Can I access MySQL from my home/office PC? By default, all incoming MySQL connections to our servers are blocked. This is to protect the... Views: 663

Enable MySQL Slow Query Log File MySQL has built-in functionality that allows you to log SQL queries to a file , You can enable... Views: 474

How do I add MySQL databases? How do I create a MySQL database? To create a mysql database in cPanel.... Views: 1546

How do I import a .sql file into MySQL? Views: 717

How do I use a connection string to connect to a MySQL database? Please note: This support article is a guide for our Linux users only and provides only an... Views: 640

How to I optimise my MySQL my.cnf on my VPS/Dedicated Server? Tuning the performance of MySQL can be a really hard job to do. There are many thinks to... Views: 685

How to optimise all databases on a cPanel server If you have root access to your cPanel/WHM server (eg: a dedicated server or VPS), you can... Views: 38

How to optimize a MySQL database using phpMyAdmin It is always a good idea to keep your databases' tables optimized. Fortunately, making this... Views: 509

How to Repair and Optimize MySQL database using cPanel and phpMyAdmin Database Repair using cPanel In some webhosts, they will have an utility via their cPanel to repair a MySQL database if your... Views: 396

I am having problems upgrading from mysql 4.1.22 to 5.0.45. What can I do? In order to resolve this issue, please peform the following commands within SSH: 1) umount... Views: 738

I am receiving an error stating Error while connecting to MySQL. Failover enacted. on my cPanel/WHM. What can I do? If you receive the error:Error while connecting to MySQL. Failover enacted. You are required to... Views: 787