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 = (use the server IP address)
    Database name = (cpanelUsername_databaseName)
    Database username = (cpanelUsername_databaseUsername)
    Database password = (whatever you picked)
    MySQL Connection Port = 3306
    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@microhosting.in 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.




    • 3 Користувачі, які знайшли це корисним
    Ця відповідь Вам допомогла?

    Схожі статті

    How to log into cPanel

    cPanel is used for managing your web hosting account and available on all Microhosting Linux...

    Please read before creating an Addon Domain

    About addon domainsAddon Domains are handled like subdomains as far as the server is concerned,...

    How to generate/download a full backup

    A full backup is a backup of all of your files, e-mail, databases, etc. To run a full backup, you...

    How to change the password of your cPanel account

    There may be times where you would like to change the password of your account. It is...

    I forgot my password and need a reset

    CPANEL /WHMCheck your welcome email for the correct user name and password. If that password is...