Open source training & tutorials from experienced, passionate people
By A Web Design
The install process of dotProject creates a set of MySQL tables and populates some of them with appropriate (default) data.
It's best to create a separate database named dotproject under MySQL so that dotProject CMS has its own reserved data storage area under MySQL into which it will place its tables and populate them with default data appropriately if so desired.
Additionally, create a MySQL user named dpuser. Protect this user with a password and finally grant this user with full rights to the resources held in the dotProject database.
Open a Command Window:
Start –> Run -> cmd as shown in Diagram 1 and Diagram 2.
Diagram 1
Diagram 2
At the system prompt Login to MySQL with login id and password created at the time of installing MySQL as shown in Diagram 3.
NOTE: I have covered the installation of MySQL in the MySQL section.
Diagram 3
At the mysql> prompt enter:
mysql> CREATE DATABASE dotproject;
Output:
Query OK, 1 row affected (0.03 sec)
Diagram 4
MySQL responds by immediately creating the dotproject database.
Next, create the user dpuser and grant this user all rights on the dotproject database controlled by a password. This information (username, password and database name) will be required at the time of installing DotProject. Write them down and store them safely for future use.
At the mysql> prompt enter:
mysql> GRANT ALL ON dotproject.* TO dotproject @localhost IDENTIFIED BY '{use any password here greater than 8 characters}';
NOTE: Do not forget the single quotes that surround the password value.
NOTE: Upper and lower case are not important. Use all lowercase if you wish. Uppercase has been used to add some clarity to the MySQL command.
Output:
Query OK, 0 row affected (0.06 sec)
Diagram 5
This will create a user dpuser, who can login to MySQL only from the local machine and will be identified by the password {password set above}.
Once complete an empty dotproject database is ready for use. This can only be accessed by a registered MySQL user named dpuser, who has all rights on the dotproject database.
Since these steps are complete all that is left is to run the Dotproject installation PHP scripts within the Dotproject core downloaded earlier.
The next tutorial steps you through the installation of dotProject on your local computer.
Do take a look.
Please wait...