Knowledge Base

MySQL

Get solutions and answers to your MySQL development questions here.

Connecting to MySQL from the command line

You use the mysql program to connect directly to MySQL from the command line. Learn how here.

Connecting to MySQL using PHP

There are several ways you can connect to a MySQL database using PHP. Learn how here.

Connecting to MySQL using Python

There are several ways you can connect to a MySQL database using Python, and this article shows you how.

Connecting to MySQL using Perl

Learn how to connect to a MySQL database using Perl.

Connecting to MySQL using Microsoft .NET

Learn how to add MySQL support to Visual Studio, and develop .NET applications that can access MySQL databases on A2 Hosting servers.

Import and export a MySQL database

Learn how to import and export a MySQL database. If you already have a database that you want to install on an A2 Hosting server, or you want to back up your database, this article shows you how.

Remote MySQL connections

There are two options for connecting to MySQL databases remotely. Learn about them and how to set them up here.

MySQL client applications

You can use MySQL client applications to manage your MySQL databases remotely. These client applications are often faster and easier to use than cPanel or the command line.

Managing MySQL databases and users from the command line

Learn how to do common MySQL administration tasks from the command line. Please note that this article only applies to semi-managed products.

Convert a MySQL database to UTF-8

Learn how to convert a MySQL database's character set to UTF-8 (Unicode) encoding.

Convert the MySQL time zone

By default, A2 Hosting's servers are set to use US Eastern Standard Time. Learn how to convert the time zone in MySQL to another time zone here.

MySQL database backups using cron jobs

Learn how to set up a cron job that automatically backs up a MySQL database at defined intervals.

MySQL database backups using AutoMySQLBackup

The AutoMySQLBackup tool enables you to quickly and easily create MySQL database backups. You can specify backup intervals, rotate backups, and even send backup files to e-mail accounts.

The information_schema database

When you view MySQL databases in phpMyAdmin or by using the mysql command-line program, you may also notice an information_schema database. Learn about this database and its purpose here.

Reset MySQL root password

If you have forgotten your root password for MySQL, this article shows you how to reset it. Note that you must have root access to your server to accomplish this.

MySQL runs out of memory or does not start

MySQL server may run out of memory or not start at all on a server with limited memory. Learn how to work around this problem here.

MySQL user privileges on shared servers

Due to the nature of shared hosting environments, some MySQL privileges are restricted on user accounts. This means some MySQL features, such as the Event Scheduler, are not available on shared hosting accounts. Learn more here.

MySQL stored functions and procedures

Learn how to set up and invoke MySQL stored functions and procedures on your A2 Hosting account.

MySQL views

MySQL views enable you to store predefined queries. Learn how to create and use them on your A2 Hosting account.

MySQL triggers

MySQL triggers are a powerful tool that you can use to add advanced database functionality. Learn how to create and use them here.

Working with MySQL database engines

Learn how to determine the database engines your tables use, how to change engines, and much more.

Determining the size of MySQL databases and tables

This article demonstrates some ways to determine the size of MySQL databases and tables.

Repairing MySQL databases and tables

Learn how to repair MySQL databases and tables. Please note that this article only applies to accounts that have root access to the server.

Enabling the slow query log in MySQL

The slow query log in MySQL can help you determine which database queries take a long time to run.

Renaming a MySQL database

There are scenarios such as data migration or site development where you may want to rename a MySQL database. Although MySQL itself does not provide a way to rename a database in one operation, you can do this using other methods. Learn how here.

Using indexes to improve MySQL query performance

Indexes can help improve MySQL database query performance. Learn more in this article.

Restricting MySQL port access

Port 3306 is open on some Linux distributions after you install MySQL on a semi-managed server. This article demonstrates how to restrict access to port 3306, or how to block it altogether.

Installing phpMyAdmin on managed hosting accounts

Learn how to install phpMyAdmin locally on a managed hosting account. You may want to do this if you need to run a version of phpMyAdmin newer than the version included with cPanel.