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

  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

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

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 create a MySQL database?

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

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

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

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...