|
Creating a Database in cPanel
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.
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.
- 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.
- Choose "MySQL Databases"
which is usually found under "Site
Management Tools". This may be shown as an icon or a text link.
- On the next screen you will see a listing of your current databases,
if any are already created. Go to bottom of the screen and look for the
following or something similar.
- 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. Click on the "Create
MySQL database" button to create your new database.
- The note here is important. 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.
Creating a MySQL Database User
- This shows users who may have privileges to one or more of
your existing databases. I.E., "test_user1",
etc. If you wish to use an existing user then you do not need to
enter a "username" nor
a "password" as in step
2. Use the delete icon to permanently delete users from
accessing any databases.
- "Username" and "Password"
are used if you want to create a new user who will access your
databases. Add the name and password in the input boxes provided
and then click on "Create
MySQL user". You still must give the user all or specific
privileges to use them as you will see next.
Granting MySQL Database
Permissions
This will grant one, some, or all premissions from a specific
database to a specific user.
- These 2 drop-down boxes will show you the appropriate
information. "User:"
will list all available users who are allowed to have database
access. "MySQL Database:"
will list all databases on your server. Choose a "User:"
and a "MySQL Database:"
carefully according to who you want to have access to which
database. If the information you seek is not in either of ther
dropdown boxes then you'll have go back and add databases and
users according to the instructions at the beginning of this
tutorial.
- These refers to the actions that a user will be allow to do
in a specific database. You may choose one, many, or "ALL".
"ALL" will allow ALL
premissions to the specified user, checking the other options is
not needed if "ALL" is
checked. Be aware that "ALL"
fill give full access to your databases, so, think first. The
other options are aptly named and will allow the user to do
exacly what they are named. You may click on "Grant
permissions" when ready.
You MySQL database will then be ready for use with your SMF Forum.
If you have problems entering information for you SMF installation
then, please, refer back to this tutorial.
- Good luck!!!
Courtesy of:
|
|
Home
