Not able to add users to the database.. help?

  • Resolved satpalsharma

    (@satpalsharma)


    16 years, 8 months ago

    I’m getting this error:

    Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the xxxx database.

Are you sure it exists?
Does the user xxx_xxx have permission to use the xxxx database?
On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    I know that the problem is with the Database. Actually I’m not able to add users to the Database and also not able to delete the database.

    I’m using cPanel X on my website. In ‘MySQL Databases’ Page under Current Databases I see one database in the data grid. But there is no user assigned to it in the User’s Column.

    When I try to add User, it shows that the user has been added but doesn’t show up in that datagrid. This is the main reason which is causing trouble while installing.

    I also tried to delete that database so that i can create a fresh one BUT i’m not able to delete it also. I mean it shows me that it has been successfully deleted But when I come back to ‘MySQL Databases’ page it still shows up there in the Current Database Grid.

    Any Idea on how to resolve this?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Well according to the error generated by wordpress, it was able to connect to the host which means DB_HOST value is ok – also it says the user/pass is ok, so obviously you created a good user and the user was added to the database.
    So the only thing missing is DB_NAME must be incorrect.
    with cpanel almost always the first 8 letters of your domain prepend the database name.
    example
    yourhost_blog
    where you just made the name blog, the host prepends it.
    Anyway figure out the correct db name.

    Thread Starter satpalsharma

    (@satpalsharma)

    In the error generated by word press… it also says that.. “Does the user xxx_xxx have permission to use the xxxx database?”

    I think I’m facing problem in this front wherein the usr/pass I created in the DB_HOST are fine but they didn’t get permission to DB_NAME. Because after adding User to this DB_NAME database it doesn’t show up under it.

    In the interface I have these columns:
    Name of the Database | Size | Users | Action
    xxxxx | 0.01mb | | Delete this dabatase

    The Users column remain blank after adding the User and also if I Delete this database it agains show up and somehow doesn’t get deleted.

    Sounds like a problem in you hosting interface. Might talk to your host and tell them you’ve had no luck assigning a user with the proper privileges to the database.

    Thread Starter satpalsharma

    (@satpalsharma)

    Yup the problem was with the hosting interface. I called them up and they fixed the issue. My Blog is now up and running… cheers ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Not able to add users to the database.. help?’ is closed to new replies.