: Connecting to my new server I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database. Now everything

@Sims2060225

Actually when using hosting management software like cPanel, it installs MySQL with default and commonly used configurations:


MySQL host = 'localhost'
MySQL port = '3306'
MySQL User = 'cpanelusername_mysqluser' [1]
MySQL password = 'password' [2]
MySQL database = 'cpanelusername_database' [3]


More explanations about the host address:


If your script or program is going to be accessing the hosted database locally, meaning script and database are on same account, the server/host address will always be: localhost, just like that, lowercase and one word.
If you are using remote database management software, the server would either be your domain name: example.com or the shared server IP (preferred choice). The shared server IP is found in the Stats section of the cPanel on left side.


Remote database connection setup:


Databases in cPanel can be accessed remotely, or by other web servers or from your home computer to manage the database with MySQL software like Workbench or Dreamweaver.
To specify remote servers able to access MySQL databases on your server:


Login to cPanel.
Locate Remote MySQL Icon under Databases.
Type your public IP or server IP address into the Add Access Host field.

To disallow a host from accessing databases on your server:


Click the X icon next to the IP address.
If you are sure you wish to prevent the server from accessing your databases, click Yes.



[1] Your cPanel username followed by an underscore '_' followed by your MySQL user you have configured in cPanel

[2] Your MySQL password you have configured in cPanel

[3] Your cPanel username followed by an underscore '_' followed by you MySQL database you have configured in cPanel

Vote Up Vote Down

@Carla537

To clear up the localhost thing -- we almost always use localhost to connect to the MySQL server, because it's a separate service on the SAME MACHINE. (Think of it as having a washing machine and a dryer; you put the clean but wet clothing in the dryer which is in the same house (localhost) as the other machine. You don't need to specify your house's address to get the clothing into the dryer. The purpose of this is to save bandwidth, and deliver the fastest speed possible. Why waste time routing outside the server and then back into it?

The standard webserver port is port 80, SSL is 443, FTP is 21, SSH is 22, MySQL is 3306, etc. You would log into the cPanel, and somewhere in the menus or on the right or left column, is the details about the IP address of the server. If you are managing your own DNS records vs. using the system built into cPanel, then you will need to specify where they are located.

It sounds like in your situation, that you registered a domain name to use with the web hosting, and should use that to connect to your site. Server name (if you mean the physical server name) is not important to you, since it's likely on a shared hosting account, where one server can serve a multitude of various peoples' websites.

If you need answers to specific questions regarding cPanel, consult the FAQ or helpdocs: docs.cpanel.net/
Else, try to contact your hosting provider. Most quality-webhosts have a support-ticket system, and are generally quick in responding.

If you have any technical questions, feel free to post them and (we) will try our best to assist you.

Vote Up Vote Down