Setting Up ExpressionEngine Database

From InstallationWiki

ExpressionEngine

Official Page

Project Documentation

Download

Source Book Building Websites with ExpressionEngine 1.6 ISBN 978-1-847193-79-7 Publisher Packt Publishing Author(s) Leonard Murphy

After installing Xampp,we need to set up the database inorder to install ExpressionEngine. When using a hosting service, the host will often have set up your database for you and provided you with the database name, server address, and username and password.

1. First, navigate to phpMyAdmin (which is installed with XAMPP). Navigate to http://localhost/phpmyadmin/.
2. In the left-hand column there should be a text box that says Create new database. We are going to call our database ee. Then click Create.
   

   
3. We are then brought to our database screen. Notice on the left-hand side that no tables have been found in the database. This is because the tables are created when ExpressionEngine is installed. For now, we are going to create an ExpressionEngine username. Select SQL from the top menu.
   

   
4. Next, type in the following command to create a new user called eeuser with a password of password, which has all rights to the ee database. Click Go.

    GRANT ALL PRIVILEGES ON ee.* TO eeuser@localhost 
      IDENTIFIED BY 'password' WITH GRANT OPTION
   

5. We should then see a message Your SQL query has been executed successfully. If so, you can click the Privileges tab to verify that eeuser has been set up and only has access to the ee database.
   

   

We are now ready to begin installing ExpressionEngine!

For the purpose of installation, the following information will be needed:

• Root of our website: http://localhost/ (files located in c:\xampp\htdocs\)
• MySQL Server Address: localhost
• MySQL Username: eeuser
• MySQL Password: password
• MySQL Database Name: ee