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

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

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

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