Articles

  How to import and export a database via SSH

You can easily import/export your database using phpMyAdmin menu in cPanel. To do so, follow the...

 How to Duplicate a Database using phpMyAdmin

To duplicate the database follow these steps: 1. Log into cPanel >> Databases section...

 How to connect to a database using Sequel Pro

Although remote MySQL connection is disabled on our shared servers due to security reasons, you...

 How to connect to a database using the Workbench MySQL client

Remote MySQL connection is disabled on our shared servers due to security reasons, but you can...

 How to connect to database using NaviCat MySQL client

Remote MySQL connection is disabled on our Shared servers due to security reasons, but you can...

 How to create and maintain MySQL Databases in cPanel

This tutorial describes the process of creating and managing MySQL Databases in cPanel. There are...

 How to empty a MySQL database

There are two ways to empty a MySQL database: via phpMyAdmin and SSH.NOTE 1: By default, SSH...

 How to grant remote access to a single MySQL database

When it comes to granting someone (e.g., to a friend or a website developer) an access to MySQL...

 How to import and export a database via phpMyAdmin ('Access denied create database db_name' error)

In cPanel you can import and export databases using the phpMyAdmin menu which you can find in the...

 How to manage databases with phpMyAdmin

phpMyAdmin is an application for MySQL databases management. With it you can create, alter, drop,...

 How to optimize website database

Database can store a tremendous amount of information – all the posts, pages, comments, menus and...

 How to remotely connect to a MySQL database located on our shared server

Due to security reasons, remote MySQL connection is disabled on our Shared Hosting servers....

 SQL

SQL (can be pronounced either as see-kwell or as separate letters) is an abbreviation for...