There are two different ways to connect to a MySQL database:
Locally - from a script on the server, to the server for which the settings are:
Hostname: localhost
Username: username_dbuser
Password: dbpassword
db_name: username_dbname
db_table: dbname_table
Remotely - from a remote computer, using Shell, ODBC, or Navicat.
The settings are the same as above, but you must use yourdomain.com in place of 'localhost'.
What are the Basic Connection Settings for MySQL? Print
- MySQL, Database
- 3
Was this answer helpful?
Related Articles
What is Web Hosting?
To state it quickly - Web hosting is the act of putting a website online to be accessed by...
What is Bandwidth?
Bandwidth, which is also referred to as transfer, is the amount of data your web host allows...
How do I prevent WordPress from overloading my shared server?
WordPress blogs can be extremely resource intensive if you happen to experience a surge in...
Can I change my cPanel username?
Unfortunately, our system does not allow a change of username as the system uses your current...
How long does it take for my DNS to resolve?
It can take as little as 1 hour for your DNS to resolve, however, we state between 24-48 hours...