Articles

 Connecting to MySQL with PHP

Use the following outline to connect and begin querying the MySQL server from within your PHP scripts.1. Connect to the MySQL serverUse the following statement to connect to the database server. Substitute the username, and password for...


 How to optimize MySQL performance

  Structured Query Language (SQL) is a special purpose programming language used to store, manipulate and retrieve data from databases. Running MySQL at optimal settings for specific resources helps handle larger server loads and helps...


 Importing and exporting MySQL databases using PHPMyAdmin

This article discusses importing and exporting your mySQL databases.   How can I import a MySQL database? Log into your DirectAdmin Control Panel account. Navigate to the "phpmyadmin" section, in the advanced features section of...


 MySQL Databases in DirectAdmin

This document provides information about MySQL databases. Topics include creating databases, removing databases, adding users to a database, changing database passwords, setting up your database with scripts and a short introduction to...