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

Register a Domain Name Canada

contact us is an ICANN Accredited Registrar

ICANN Certified Registrar is a CIRA Certified Registrar is an Authority (CIRA) certified .CA Domain Name Registrar is a BBB Accredited business

BBB Business Review of this Internet Services in Ottawa ON