Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

new hosting making sence of it

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: http://85.92.75.157:2082/
Once your domain has propogated, you may also use http://www.christophersowerby.com:2082/

Server Information

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

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: dns1.dnshosted.co.uk (208.43.81.114)
Nameserver 2: dns2.dnshosted.co.uk (50.22.35.226)
Nameserver 3: dns3.dnshosted.co.uk (174.37.183.108)

Uploading Your Website

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

Temporary FTP Hostname: 85.92.75.157

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

FTP Hostname: www.christophersowerby.com
Webpage URL: http://www.christophersowerby.com
0
helpchrisplz
Asked:
helpchrisplz
  • 2
1 Solution
 
aboo_sCommented:
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.
0
 
aboo_sCommented:
It could also be called MySql Administration..
0
 
RedLondonCommented:
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 http://www.christophersowerby.com:2082/

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.
0
 
helpchrisplzAuthor Commented:
thx that seems so simple now ! :)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now