What are the connection settings for my MySQL database? What is my database name, my database username, and my database password? Where do I connect to?

The hostname to connect to is "localhost"; without the quotes. The database username and password needs to be entered exactly as it appears in the MySQL manager in your control panel (CPanel) ie username_dbname, etc. When you create a username in cpanel, please be aware that there is an 8 character limit. Extra characters will be dropped.

Additionally, please make sure you have added the database user to the access list for the corresponding database. For best results if you do not have a static ip address you need to add a single % sign to the access host list in the sql manager of your cpanel. The port is 3306

  • 0 Korisnici koji smatraju članak korisnim
Je li Vam ovaj odgovor pomogao?

Vezani članci

How do I rename a table in phpMyAdmin?

Here is a step-by-step for renaming a table: 1. Log into cPanel 2. Click on "MySQL Databases"...

Does your MySQL server support extended character sets, foreign character sets, and collation sets?

In the control panel's left-hand side of the page, there should be a MySQL version for your...

Can I backup my MySQL database? How do I backup my database?

You can backup your database two ways. 1. Click on Backup in Cpanel then click on the database...

Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...

Can I use MySQL Front to access my database?

You can remotely connect to your database by using your domain name as the host you are...