Articles

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

 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?

Using the below mentioned steps, we will show you how to check the size of your database so 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 optimze mysql in Cpanel?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

 How do I optimze mysql in plesk ?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

 How do I restore a database using PHPMyadmin

You can restore a database backup in PHPMyadmin by following th given steps: 1) After entering...

 How many MySQL databases come with my hosting plan?

It depends on the plan which you select. For more details please check our plans...

 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 are the connection settings for my MySQL database?

MySQL host Address: IP address where your account is hosted. MySQL database name:...

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

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

 phpMyAdmin: Searching through a database

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