Trying to set priledges in MyPHP and can't HELP!!

[kemistry]

Hi,

Im trying to setup the backend for my wordpress blog..
I have created the MySQL databases and granted full access to the user.

When i connect to MyPHP it says

Create new database: "No Privileges"

I don't see the privileges page to modify the priviledges so what to do?

Am i going nuts that i dont see it? Or am i missing something?

[Pethens]

By "MyPHP" do you mean PHPMyAdmin?

And if you successfully created the database already, why are you getting the error "Create new database - No privileges". At this point, you shouldn't be trying to create a database anymore.

Or maybe I have misunderstood what you are saying.

In any case, keep this in mind: you can't create a database with PHPMyAdmin. The only way we have to create databases is with cPanel > MySQL Databases. I assume this is because Bluehost wants to keep track of how many databases we create. Once you have created a database and added a user using this method, you just have to copy the db info (name, user, password) to the appropriate place in Wordpress (either a config file or a setup screen). You don't need PHPMyAdmin.

Hope that helps,

Stephen

[siguie]

If you used "MySQL Databases" in CPanel to create the database ... then after you create it you need to set the "User" priveleges.

It's really simple so if you haven't created a user yet go down to the bottom of the page or search for "Users:" then create a user.

Once you create one or want to use one that you created previously go to "Add User to Db" ... it's near the bottom and just above "Users:". Select the User from the pulldown menu and the database that you want associated with the user (presumably the wordpress DB). Make sure "ALL" is checked (or whatever privileges you want to give the user over the DB but ALL is easiest). Then click "Add User to Db".

Then go finish your WordPress setup :)