What are the Basic Connection Settings for MySQL?

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'.


  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:- Login to your control panel...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

There are two ways to do this, one being using phpMyAdmin the other is via SSH. Using...

I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...

How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...

Powered by WHMCompleteSolution