There are two different ways to connect to a MySQL database. Locally (from a script on the server to the server), and Remotely (from a remote computer, using Shell, ODBC, or Navicat)
Locally, the settings are:
Hostname: localhost
Username: username_dbuser
Password: dbpassword
db_name: username_dbname
db_table: dbname_table
Remotely, the settings are the same, but you must use yourdomain.com in place of 'localhost'. Also, your IP address must be whitelisted on our end in order to get through our firewall. You can whitelist your IP address inside the cPanel under "Remote mySQL".
- 44 gebruikers vonden dit artikel nuttig