PHP Script installation:
A. Create/Remove a Database through cPanel
There are 3 steps to creating a database through cPanel..
Login to your cPanel with your account username/password. Then find and click
on "MySQL Database" icon.
You'll see the MySQL Account Maintenance Panel. To create a database you
need to perform the following
3 steps in the panel:
Step 1. Create the database- type in the desired database name in the create
database box and click
"Create
Database".
Step 2.Create a database user- type in the desired username/password in the
user section and clicking
"Create User".
(You have to write down the password since you need to use it to access the
database you created).
Step 3. Add the database user you created in step 2 to the database you created
in step 1- do this with
the drop down menus
to make the user name in contrast to the database name and click on "Add
User to Database".
In the processing, cPanel will automatically add your cPanel username to both
the database name and the database
user name. For example, if your account username is 'mywebsite' and you created
the database 'mydbase' and the
database user ''test" with a password of "test123". Your database
information would be showed in current database section like:
Database Address: localhost
Database Name: mywebsite_mydbase
Database User: mywebsite_test
Database User Pass: test123
You can delete, check or repair the database/user by click the mark behind
it. You can also use the last MySQL
Account Maintenance section phpMyAdmin to administrate your MySQL databases
in a web based environment.
B. How to CHMOD a file/folder?
What is chmod?
CHMOD (change mode) is a Unix command that tells the server what kind of access
it can grant to a file
or a folde(permissions). There are three types of user: owner, group and public.
Each type of user can have
three levels of access: read, write and execute.There is a numerical value assign
to read (4), write (2) and
execute (1). Each permission is a combination of numerical value on read, write
and execute for user , group
and public: It can be a matrix like,
User
Group Public
Read
4
4 4
Write
2 2
2
Execute
1 1
1
E.g. a permission sets to 755,
Represents: : User-7 (4+2+1=7) , Group-5 (4+1=5),
Public-5 (4+1=5).
Means: "User" can read, write and execute. "Group" and "Public"
can read and execute only.
In cPanel => File Manger, you can see each file and folder listed has a
permission value behind it.
If you click on the file/folder name, it will show the "change permission"
on the right column.
Click it and there will be a calculater table for you to set the permission.
You don't need to fill in
numbers. Just check the related box and the permission value will be calculated
itself.
Calculater Table: ( for the example of permission 755)
| MOD | User | Group | World |
| Read | X | X | X |
| Write | X | ||
| Execute | X | X | X |
| Permission | 7 | 5 | 5 |
Now you can try to set permission 777, 655
and 666 for practicing in your web hosting control panel
(e.g. cPanel=> File Manager, or directly right click on the folder/file to
select the function through your ftp client software).