Trying to install WordPress...trouble with SQL database

[mattslyk]

Hey all,

I'm trying to install wordpress onto my website. I currently run a different news program (cutenews) and want to do a trial run of wordpress before completely switching over.

I'm going through the install steps, and I'm stumped already when it comes to creating a new user in the database. I can create a user just fine, but I am unable to give them full privileges.

Once I create the user I can login to myPHPadmin with that user and can get to that stuff, but my privileges are all restricted. Can anyone tell me how to log into myPHPadmin with full privelages?

Here are the installation instructions for WordPress:

Using phpMyAdmin

If your web server has phpMyAdmin installed, you may follow these instructions to create your WordPress username and database.

Note: These instructions are written for phpMyAdmin 2.6.0; the phpMyAdmin user interface can vary slightly between versions.

1. If a database relating to WordPress does not already exist in the Database dropdown on the left, create one:
1. Choose a name for your WordPress database ('wordpress' or 'blog' are good), enter it in the Create new database field, and click Create.
2. Click the Home icon in the upper left to return to the main page, then click Privileges. If a user relating to WordPress does not already exist in the list of users, create one:
1. Click Add a new User.
2. Chose a username for WordPress ('wordpress' is good) and enter it in the User name field. (Be sure Use text field: is selected from the dropdown.)
3. Choose a difficult-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and enter it in the Password field. (Be sure Use text field: is selected from the dropdown.) Re-enter the password in the Re-type field.
4. Write down the username and password you chose.
5. Leave all options under Global privileges at their defaults.
6. Click Go.
3. Return to the Privileges screen and click the Check privileges icon on the user you've just created for WordPress. In the Database-specific privileges section, select the database you've just created for WordPress under the Add privileges to the following database dropdown. The page will refresh with privileges for that database. Click Check All to select all privileges, and click Go.
4. On the resulting page, make note of the host name listed after Server: at the top of the page. (This will usually be localhost.)

[Alvin M.]

Matt....

Whenever you creates the My SQL database, it always ask for the 'Privileges' (Permissions) of the database users. You can assign the database 'Privileges' from there.

[Zephoon]

Agree with Alvin M.