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

  • Basic Connection, Basic Connection Settings
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

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

How do I create a MySQL database?

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

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

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

Powered by WHMCompleteSolution