What are the Basic Connection Settings for MySQL?

Portal Home > Knowledgebase > Databases > 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 adollaradayhosting.com.au in place of 'localhost'.

Add to Favourites Print this Article

Also Read

Do I use localhost or remotemysqlhost for my mysql connection? (Views: 322)

How can I connect to a MySQL database from Dreamweaver? (Views: 357)

How do I create a MySQL backup? (Views: 335)

I would like to dump the Table Structure for my MySQL Database, but none of the data. (Views: 334)

I can't log into MySQL from a remote computer using a MySQL admin tool. (Views: 352)