Articles

 ) What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

 How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql' Then scroll down to the 'access hosts'...

 How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

 How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In...

 How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

 How do I check the size of my database?

In this section, we will show you how to check the size of your database so you can know if you...

 How do I delete a MYSQL database?

Removing a database will delete that database ENTIRELY from the server. Please make sure you...

 How do I restore a database using PHPMyadmin?

You can restore a database backup in PHPMyadmin by doing the following: 1) After entering...

 How to Optimize database tables?

  Please use following steps to optimize your MySQL tables.   1) Log into your cPanel and...

 How to change password of MySQL user in cPanel?

To change password for mysql user proceed with the steps given below. Step 1: Login to Control...

 How to check and repair MySQL database tables?

In case you stumble across an error like: “Table ‘table_name’ is marked as crashed and should be...

 How to create a table using PhpMyAdmin in cPanel?

Mysql tables can be created using phpMyAdmin by following the steps below. Step 1: Login to...

 How to delete a mysql database in control panel?

To delete MySQL database in control panel, follow the steps given below, Step 1: Login to cPanel....

 How to run / execute mysql queries using phpmyadmin in CPanel?

To execute database queries using phpmyadmin proceed with the steps given below. Step 1: Login to...

 I need a different version of PHP/MySQL

If for some reason you cannot install programs on your server like Joomla, Drupal, WordPress,...

 Is InnoDB available for MySQL?

     YES it is.

 What is Mysql?

MySQL is a Relational Database Management System. A relational database adds speed and...

 What is the default mysql port?

3306 is the default mysql port.

 What is the mysql host name?

Always use 'localhost' whenever asked

 phpMyAdmin: Copying a database table

Let’s learn how to copy a database table with below mention steps  1) Click the database table...

 phpMyAdmin: Creating tables in a database

let’s learn how to create a table within a database   1) Select the database 2) Enter a Name...

 phpMyAdmin: Importing databases and tables

Let’s learn how to import a table into a database   1) Click the database you wish to import...

 phpMyAdmin: Renaming database tables

This Article assumes you’ve already logged in to phpMyAdmin   Now let’s learn how to rename...

 phpMyAdmin: Running SQL queries on a database

Let’s learn how to run SQL queries on a database   1)Click the database table you wish to run a...

 phpMyAdmin: Searching through a database

Now let’s learn how to use the Search feature in phpmyadmin  1) Click the database you wish to...