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

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create a MySQL database?

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

Do I use localhost or remotemysqlhost for my mysql connection ?

You can view whether your account is using localhost or remotemysql host in your cPanel...

How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...

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

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