Open source training & tutorials from experienced, passionate people
By A Web Design
The install process of Joomla! creates a set of MySQL tables and populates some of them with appropriate (default) data.
It's best to create a separate database named joomla under MySQL so that Joomla 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 joomla. Protect this user with a password and finally grant this user with full rights to the resources held in the joomla database.
Open a Command Window:
Start –> Run -> cmd as shown in diagram 1 and 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 and Diagram 4.
NOTE: I have covered the installation of MySQL in the MySQL section.
At the mysql> prompt enter:
mysql> CREATE DATABASE joomla;
Output:
Query OK, 1 row affected (0.00 sec)
MySQL responds by immediately creating the joomla database.
Next create the user joomla and grant this user all rights on the joomla database controlled by a password. This information (username, password and database name) will be required at the time of installing Joomla. Write themdown and store them safely for future use.
At the mysql> prompt enter:
mysql> GRANT ALL ON joomla.* TO joomla@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.03 sec)
This will create a user joomla, who can login to MySQL only from the local machine and will be identified by the password {password set above}.
Once complete an empty joomla database is ready for use. This only be accessed by a registered MySQL user named joomla, who has all rights on the joomla database.
Since these steps are complete all that is left is to run the Joomla installation PHP scripts within the Joomla core downloaded earlier.
The next tutorial steps you through what you need to do on your local computer just prior actually going through with installing Joomla CMS on your local computer.
Do take a look.
Please wait...