September 10, 2010, 11:31:40 AM
Great New Theme! Thanks, sybil!!! ;)

10 Dec 2008 Creating a MySQL Database using cPanel

Written by Skhilled December 10, 2008, 10:43:00 AM Print
We'll be creating a database in cPanel using MySQL. Please, keep in mind that your screens may appear different if you are using a different version of cPanel or are using a different cPanel theme. However, you should be able to find the same things on your server regardless. This tutorial uses the x3 theme.

For testing purposes, we'll be using "test" as the server name, "user" as the username, and "pass" as the password. Anything with a "_" (underscore) directly after it like this: "test_" is called a prefix and will usually come before something like "test_user". This is very important when creating your database and entering information during the creation phase of your SMF forum. Please, use your own information when actually trying this on your server.
    1. You can usually go to your cPanel by typing: "www.your_site.com:2082" or "www.your_site.com/cpanel" in any browser. This may be different on some servers. Type in your server login information when prompted.

    2. Choose "MySQL Databases" which is usually found under the "Databases" section. This may be shown as an icon or a text link. You could also use "MySQL Database Wizard" to make this process easier. But this tutorial will focus on "MySQL Databases" for those who do not have the wizard.

    cPanel

    3. On the next screen, you can create the database and will also see a listing of your current databases, if any are already created.

    Enter a meaningful name for your new database. This can be anything but should be something that you'll remember and will mean something to you. Making it meaningful will be especially useful if you plan on having multiple databases. You'll want to be able to easily match a database to the website you are working on to avoid confusion. Trust me, it's not pretty if you confuse them. For now, give your database a name under the "Create New Database" section.

    It is important to remember the following. When you create your SMF forum you'll be asked what is the name of the database. It will be "test_databasename". "test_", again, is your server username prefix and "databasename" is what you just named your database.

    Create New Database

    4. Go to bottom of the screen and look for "Add New User". Enter a User Name and Password. Please note the maximum length of the User Name. Your server may vary. You will need to enter the password twice. You can also choose to have the server create one for you. Click on the "Generate Password" button to do this. After you have entered your information click the "Create User" button.

    Please, keep in mind that the higher the password strength is the more secure your password will be. This is important because it will make it harder for hackers to guess it. Save this information elsewhere and keep it safe. You will need it when you create yout forum, blog, or any other software that uses your MySQL database.

    Create New User

    5. Next, you must assign yourself to the database so you permission to add, delete or modify it. Other permissions will also be available to be given to the user(s) that you want to have access to it.

    Choose the user and the database you want them to have access to and then click the "Add" button.

    Add User To Database

    6. Give your user(s) as much or as little privilages as you see fit. You should ALWAYS give yourself "ALL PRIVILAGES". When you check that option you will not have to check any of the rest of them. When you are finished click "Make Changes".

    Manage User Privilages

    Your new database is all set to be used how you see fit.

Enjoy!!!

Courtesy of:
Doc Skillz


Share on Twitter! Digg this story! Del.icio.us Share on Facebook! Technorati Reddit StumbleUpon