Where to find your database credentials

Hostinger

hPanel → Databases → Management / Remote MySQL

1. 1

   Open the Databases page

   Log in to hPanel, choose your website, then open Databases → Management in the left menu.

2. 2

   Create or find the WordPress database and user

   Your existing WordPress database appears in the list below the creation form; its name and user usually look like u123456789_wp. To make a dedicated ThinkGraph user, fill in a database name, user name and password under “Create a new MySQL database and database user”. Hostinger shows the final prefixed names — copy them. If you create a new database it will be empty; ThinkGraph needs the one that WordPress itself uses.

3. 3

   Enable Remote MySQL

   Open Databases → Remote MySQL. In “IP (IPv4 or IPv6)” enter % (any host), choose your database in the dropdown and click Create. The page then lists your MySQL hostname (something like srv123.hstgr.io) — that is the Database host for ThinkGraph. Port is 3306.

GoDaddy

cPanel hosting → Databases → MySQL / Remote MySQL

1. 1

   Open cPanel

   Sign in at godaddy.com → My Products → Web Hosting → Manage next to your hosting plan, then click cPanel Admin.

2. 2

   Create a database user (MySQL Databases)

   In cPanel open Databases → MySQL® Databases. Under “MySQL Users → Add New User” create a user with a strong password (for example tg_readonly). Note the full name — cPanel prefixes it with your account name, e.g. acct123_tg_readonly.

3. 3

   Give the user SELECT-only access

   Scroll to “Add User To Database”, pick the new user and your WordPress database, then click Add. On the privileges screen untick ALL PRIVILEGES and tick only SELECT (add SHOW VIEW if you like). Save with “Make Changes”. A SELECT-only user cannot change or delete anything on your site.

4. 4

   Allow ThinkGraph to connect (Remote MySQL)

   Open Databases → Remote MySQL® and add an access host. ThinkGraph runs on servers whose IP addresses change, so a single fixed IP can’t be given. Enter % (any host) — this is safe only because the user is SELECT-only. If your host refuses %, ask their support to enable remote MySQL for your account.

5. 5

   Find the host name

   Use your server’s host name or IP, not “localhost”. In cPanel look at the right-hand “General Information / Server Information” panel (Shared IP Address, Server Name), or use the Remote MySQL page, which lists it. Port is 3306 unless your host says otherwise.

HostGator

Customer Portal → cPanel → MySQL Databases / Remote MySQL

1. 1

   Open cPanel

   Sign in to the HostGator Customer Portal → Hosting, choose your plan and click Manage, then open cPanel (or use yourdomain.com/cpanel).

2. 2

   Create a database user (MySQL Databases)

   In cPanel open Databases → MySQL® Databases. Under “MySQL Users → Add New User” create a user with a strong password (for example tg_readonly). Note the full name — cPanel prefixes it with your account name, e.g. acct123_tg_readonly.

3. 3

   Give the user SELECT-only access

   Scroll to “Add User To Database”, pick the new user and your WordPress database, then click Add. On the privileges screen untick ALL PRIVILEGES and tick only SELECT (add SHOW VIEW if you like). Save with “Make Changes”. A SELECT-only user cannot change or delete anything on your site.

4. 4

   Allow ThinkGraph to connect (Remote MySQL)

   Open Databases → Remote MySQL® and add an access host. ThinkGraph runs on servers whose IP addresses change, so a single fixed IP can’t be given. Enter % (any host) — this is safe only because the user is SELECT-only. If your host refuses %, ask their support to enable remote MySQL for your account.

5. 5

   Find the host name

   Use your server’s host name or IP, not “localhost”. In cPanel look at the right-hand “General Information / Server Information” panel (Shared IP Address, Server Name), or use the Remote MySQL page, which lists it. Port is 3306 unless your host says otherwise.

Bluehost

Hosting → Advanced → cPanel → MySQL Databases / Remote MySQL

1. 1

   Open cPanel

   Sign in to Bluehost → Hosting (or Websites → Settings) → Advanced and open the cPanel tools, then continue below.

2. 2

   Create a database user (MySQL Databases)

   In cPanel open Databases → MySQL® Databases. Under “MySQL Users → Add New User” create a user with a strong password (for example tg_readonly). Note the full name — cPanel prefixes it with your account name, e.g. acct123_tg_readonly.

3. 3

   Give the user SELECT-only access

   Scroll to “Add User To Database”, pick the new user and your WordPress database, then click Add. On the privileges screen untick ALL PRIVILEGES and tick only SELECT (add SHOW VIEW if you like). Save with “Make Changes”. A SELECT-only user cannot change or delete anything on your site.

4. 4

   Allow ThinkGraph to connect (Remote MySQL)

   Open Databases → Remote MySQL® and add an access host. ThinkGraph runs on servers whose IP addresses change, so a single fixed IP can’t be given. Enter % (any host) — this is safe only because the user is SELECT-only. If your host refuses %, ask their support to enable remote MySQL for your account.

5. 5

   Find the host name

   Use your server’s host name or IP, not “localhost”. In cPanel look at the right-hand “General Information / Server Information” panel (Shared IP Address, Server Name), or use the Remote MySQL page, which lists it. Port is 3306 unless your host says otherwise.

Any other host: read wp-config.php

Every WordPress site stores its database details in wp-config.php in the site’s root folder. Open it with your host’s File Manager or FTP and look for:

define( 'DB_NAME',     'acct123_wp' );        // Database name
define( 'DB_USER',     'acct123_wpuser' );    // Database user
define( 'DB_PASSWORD', '••••••••' );          // Password
define( 'DB_HOST',     'localhost' );         // see note below
$table_prefix = 'wp_';                        // Table prefix

DB_HOST is often localhost, which only works from the hosting server itself. ThinkGraph connects from outside, so use the host’s remote MySQL host name or server IP instead (your host’s docs call it “Remote MySQL” or “external database access”).

Making a SELECT-only user with SQL

If your panel has no privilege checkboxes but gives you phpMyAdmin or a MySQL console and your plan allows GRANT, run this (replace the names and password):

GRANT SELECT ON your_database.* TO 'tg_readonly'@'%' IDENTIFIED BY 'a-strong-password';
FLUSH PRIVILEGES;

Shared hosts often block GRANT. If so, ask support to create a SELECT-only user for you.

Connection failed?

Ready? Connect your site →