new hosting making sence of it

Posted on 2011-04-20
Last Modified: 2012-05-11
hey i just got some hosting for the first time. i am trying to figure out my mysql user pass and host address.

the email they sent me on sign up is as follows:
(i have tried with the user name and password just bellow but no luck and am unsure the host address? also i have added a db to c panel and registered a user to it. i am confused if i need to use the new registered users password to connect?)

Login Details

Username: christop
Password: ***********

Control Panel URL:
Once your domain has propogated, you may also use

Server Information

Server Name: Linux cPanel/WHM ~ Clustered cPanel DNS Network
Server IP:

If you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.

Nameserver 1: (
Nameserver 2: (
Nameserver 3: (

Uploading Your Website

Temporarily you may use one of the addresses given below manage your web site:

Temporary FTP Hostname:

And once your domain has propagated you may use the details below:

FTP Hostname:
Webpage URL:
Question by:helpchrisplz
    LVL 10

    Expert Comment

    login to your domain (CPANEL) and from there look for php myadmin which should control you DB and there you can create new DB and configure user name and pwds.
    LVL 10

    Expert Comment

    It could also be called MySql Administration..
    LVL 11

    Accepted Solution

    There are no MySQL databases or users set up automatically with cPanel, but you you can log in to cPanel and create them yourself.

    1. Go to

    2. Enter your username and password to log into cPanel

    2b. In the left hand column there is a "Stats" box: you may need to expand it, but it will show you how many MySQL databases your hosting account will allow you to create.

    3. Scroll down to the "Databases" box of icons

    4. There are four icons:
         - MySQL Databases
         - MySQL Database wizard
         - phpMyAdmin
         - Remote MySQL
       If you are happy to create a database first, and then add a user to it, you can click MySQL Databases, but I recommend you use the wizard at least the first time.

    5. Once you have clicked on the Wizard icon, it will ask you for a username.  I usually enter something like "webdata".  Click Next Step.

    6. On the next step you need to create a username and choose a password for it.  Let's use the username "webuser", and click the "Password generator" button to make up a password.  It gave me "kPA5z5BXTfQA" so I tick the box to say I wrote it down, it ranks my password as 'Very Strong' and then we click "Create User"

    7. Don't stop yet, else your user won't be allowed to access your database.  On the next step, you can choose what your user will be able to do.  It's good practice to have users on live website not be able to DROP tables for example, but for now, just click "All priviledges" and click "Next Step"

    8. You're done.  Your hosting account's username followed by an underscore prefixes the MySQL database name and database username that you chose, so your new MySQL details will be, using this example:

    Database name: christop_webdata
    Database username: christop_webuser
    Database password: kPA5z5BXTfQA

    Unless your webhost has told you otherwise, the database hostname will be "localhost"

    9. Now you can go back to the cPanel homepage and click on that "MySQL Databases" page - you'll see that you have a list of databases, a list of users, and in the list of databases there is a column showing which users have access to each database.  You can add more users to the database using the double pulldown menus at the bottom.
    LVL 1

    Author Closing Comment

    thx that seems so simple now ! :)

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now