Install MySQL Query Browser and Create the Default User

Before installing Author-it Website Manager you will need to create a user and blank database.The following instructions use the MySQL Query Browser.

To Create the User and Database:

1. Install MySQL Query Browser
2. Login to MySQL Query Browser as the administrator using the following server host and username:

   Server Host: localhost

   Username: root

   Password: (leave blank)

   Schema: (leave blank)

   

3. Choose OK to continue
4. Choose Ignore to open the Query Browser

   

5. Create a blank database called awm by adding the following SQL query to the query area:

   CREATE DATABASE awm

6. Choose Execute to run the query
7. Delete the query text so the query area is blank for the next step
8. Create the database user by adding the following SQL query to the query area (as a single line of text without paragraph breaks):

   GRANT ALL PRIVILEGES ON awm.* TO 'awm_site'@'localhost' IDENTIFIED BY '1234'

   The query creates the user awm_site, with access from localhost using the password 1234.

9. Choose Execute to run the query
10. Close the Query Browser.

The database is ready to be populated with the Author-it Website Manager table structure.