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 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 Optimize database tables?

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

 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.

 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...

 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