The Official PostNuke Installation & Getting Started Guide: Revision 9939 / Preview
Prev |  | Next

# Chapter 20. APPENDIX B: Create the MySQL username and password that PostNuke will use

Follow these steps to set up the database username and password:

- "`mysql -u root -p`"

You will be prompted to enter the root database password. When the MySQL monitor prompt appears, type in the following:

"`GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@<dbhost> IDENTIFIED BY '<dbpass>' WITH GRANT OPTION;`"

- <dbname>: The name of the database that PostNuke will use. Example: "rogue".

- <dbuser>: The username that PostNuke will use to access the database. Example: "web".

- <dbpass>: The password for <dbuser>.

- <dbhost>: The hostname where <dbname> resides. Most users will use "localhost".

Press `RETURN`. If the process was a success, it will be reported as "Query OK, 0 rows affected (0.05 sec)".

If you do not have root access to the database, a database username and password can be created using phpMyAdmin (http://phpwizard.net/projects/phpMyAdmin). To create a database username and password, follow these steps:

- Log in to phpMyAdmin.

- Click "Users".

- Under the section entitled "Add a new user", follow these steps:

  - - Set "Host" to "localhost" (or the host defined in <dbhost>.

  - - Set "Username" to <dbuser>.

  - - Set "Password" to <dbpass>, and re-type it to verify the password.

  - - ALL Privileges should be BLANK (unchecked).

  - - Click the "Go" link below Privileges.

- The user will be created. Next, follow the steps below to grant privileges to the user we just created.

  - - Click "Grants" next to the user that we just created.

  - - Set "Database" to the name of your PostNuke database <dbname>.

  - - Click "Check All" under Privileges.

  - - Click the "Go" link below Privileges.

- The user will be given full access to the PostNuke database, but nothing else.

Prev | Home | Next
APPENDIX A: Create the MySQL database that PostNuke will use |  | APPENDIX C: Configure the webserver