Results 1 to 5 of 5

Hybrid View

  1. #1
    Join Date
    Aug 2003
    Posts
    2,004

    Adding a MySQL database in CPanel (X2 Theme)

    This is taken from one of my CPanel articles I wrote several months back. I think this is one of the more helpful topics as people often have problems with MySQL, so here it is.

    How do I add a MySQL database in CPanel?
    *This article assumes you are already logged into CPanel*

    Adding a MySQL database: In the 3rd row, 3rd to the right you will see an icon labeled as MySQL Databases. Click on it.

    This will take you to a new page where you will see:

    DB
    Username
    Password
    Host


    In the box marked as DB, this is where you will enter the name of the database. Do so now and click on the button labeled as Add DB. The database will then be created.

    Now, in the Username and Password boxes enter the username and password which will be used for to access the MySQL database. Once you have done so, click on the button labeled as Add User.

    In the Host box, if the MySQL server is on the same server then type in localhost and click on the button labeled as Add Host. If it isn't, then enter the IP/server name instead.

    You now have a MySQL database and a user. So now you must add the user to the database in order to access it. At the top of the page there are 2 boxes across from each other. One will have the username in it and the other has the MySQL database name in it. If they are not already selected, click the drop down box and select your user and/or MySQL database. Once you have done this click on the button labeled as Add User to Db.


    The user is now added to the database and you can start using it.

  2. #2
    Join Date
    Jul 2003
    Location
    UK
    Posts
    1,887
    1stStrike - Nice in-depth tutorial, well done, I'm sure many users will find this helpful!

  3. #3
    good job ..! keep it up

  4. #4
    It is indeed a good article..! But one of the things that I have experienced is that people forget assigning users to databases, which creates problem and throws a database login error.
    Especially newbies need to take care about that ..!

  5. #5

    Re: Adding a MySQL database in CPanel (X2 Theme)


    Now, in the Username and Password boxes enter the username and password which will be used for to access the MySQL database. Once you have done so, click on the button labeled as Add User.

    The user is now added to the database and you can start using it.
    Does it matter what user/pass you select or should you select your cpanel user/pass?

    thanks,
    SHG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •