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