How To Setup an ODBC Connection To a MySQL Database

What is ODBC ? ODBC stands for Open Data Base Connectivity. It is a connection that is created to define a connection between a computer and a database stored on another system. The ODBC connection contains information needed to allow a computer user to access the information stored in a database that is not local […]

Read more

How to access MySQL databases from Remote or external location

How to access MySQL databases from Remote or external location You can allow access to MySQL databases from an external location by adding its domain name or IP address to the list of hosts that are allowed to access your databases remotely. Additionally, if you would like to manage your database using an application for […]

Read more

Do you have phpMyAdmin installed?

Yes. Login to CPanel. Click the “PhpMyadmin” icon. Your PhpMyadmin interface should open in a new window.

Read more

What is the naming structure of my databases?

The name of your databases will have the form: username_nameofdatabase

Read more

How can I manage my databases?

Login to CPanel and click the “MySQL database” icon. from this screen you can add SQL users and create databases.

Read more

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases’ tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel.   To perform the optimization, log in to your phpMyAdmin and select the database whose tables you wish to optimize.   A list with all the database’s tables […]

Read more

How to Create a Backup of a Database using PHPMyAdmin

Backing up your database regularly is a good idea and should be done. This guide will walk you through the process and help you create a backup (dump) of your database using phpMyAdmin. To do this, you will need to be logged in to the GreenGeeks cPanel and click on the phpMyAdmin icon. Select the […]

Read more

Basic Helpful Tutorials (43)
Cpanel (14)
Domain name (40)
Email (54)
FTP (9)
General FAQ (62)
Home Page (14)
Mysql (7)
Our Reseller Program Tutorials (4)
Pre Sales (25)
Reseller Hosting (5)
Script installations (7)
SSL (24)
TBR (8)
Video Tutorials (7)
Website Builders (29)
Windows Hosting (14)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better. is an
ICANN Accredited Registrar

ICANN Certified Registrar is an Authority (CIRA)
certified .CA Domain Name Registrar is an Authority (CIRA) certified .CA Domain Name Registrar
Click for the BBB Business Review of this Internet Services in Ottawa ON

HACKER SAFE certified sites prevent over 99.9% of hacker crime.
  • Facebook
  • Twitter