Articles

 Basic MySQL Commands

-Create a database on the sql server. create database [databasename]; -List all databases on...

 How can I monitor what my MySQL server is doing?

A handy little Linux application called Mytop fits this just perfectly. This is a near time...

 How do I backup a MySQL database?

By logging into cPanel >> Backups you can download and restore any individual MySQL...

 How to install MySQL

Every cPanel account now comes with MySQL pre-installed.

 How to reset a mySQL password?

If you have lost your root user password for MySQL, you can reset it with the following...

 MySQL Optimization / Repair Information

How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and...

 Repairing MySQL tables

This should be handled on a case by case basis, but if you are using the default MySQL table type...

 Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...

 What is the best online resource for information about MySQL?

The MySQL website has a complete reference manual with search capabilities available on their...