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

Was this answer helpful?

 Print this Article

Also Read

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

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

Remote Access To MySQL Database Server?

Host name = (use the server IP address) Database name = (cpanelUsername_databaseName) Database...

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

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