1. Open the MySQL connection configuration file or dialog in your program. There is no standard location for this, so consult your program's manual, readme or install instructions file for further directions.
2. Locate the 'Host,' 'Hostname' or 'Database IP' field. Enter 'localhost' if this is a script or program you are uploading to your host. Enter your Hostgator server IP address if connecting from a query browser application. This information was sent to you along with your FTP information in the welcome email.
3. Enter 'cpanelusername_databasename' for the 'Database name' field. For example, if your database is named 'AccountRecords' and your CPanel username is 'muffin342,' your database name is 'muffin342_AccountRecords.'
4. Enter your cPanel and database username for the 'Database username' field. For example, 'muffin342_Accounting' if your MySQL username is 'Accounting.'
5. Supply the password to your database in the 'Database Password' field.
6. Enter the port '3306' using either Transmission Control Protocol (TCP) or User Datagram Protocol (UDP) for the connection protocol.
No comments:
Post a Comment