How to Connect to the MySQL Database


Note: If connecting from your home computer, you need a MySQL client like Navicat, phpMyAdmin, or Dreamweaver.

 

Configuration Settings:

Host name = (localhost)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306 (But not required)
TCP or UDP, either is fine.

Before you can connect:

Many of our servers block port 3306 inbound, if you are getting a "Connection Refused" error when trying to connect please submit an email to support@cubehostindia.com requesting that we open port 3306 for Your Ip address to be able to connect to MySQL remotely.

Also, before you can connect to MySQL from another computer, you must enable your computer as an Access Host. It may sound confusing, but cPanel makes this very simple.

 

  1. When using X3, login to cPanel and click the Remote MySQL icon, under Databases.
  2. Type in the connecting IP address, and click the Add Host button.
  3. All done, try connecting remotely.
-or-
  1. When using X, login to cPanel and click the MySQL Databases icon, under Databases.
  2. Scroll all the way to the bottom and type in the connecting IP address where it says "Host (% wildcard is allowed):", and click the Add Host button.
  3. All done, try connecting remotely.
  • 50 Users Found This Useful
Was this answer helpful?

Related Articles

Does it cost extra to park domains?

As long as you have a Silver plan or higher, you may park domains to your existing primary...

How to host domain from other registrar to CubeHostIndia by changing Nameserver

Most of the users have a domain from various domain registrars and they are willing to host their...

Apache Handlers, running html as php

Apache handlers allow you to control what Apache will do with certain file types. When Apache...

Accessing Web Disk and WebDav

Web disc (also known as WebDAV) is a drag-and-drop interface which allows you to access your...

Working with temporary URL on cPanel

Our Shared hosting server is running on fcgi php handler with the suEXEC enabled, due to security...