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.