Can't Select Database

  • nac82

    (@nac82)


    9 years, 10 months ago

    I’ve seen this posted a couple times and I think I have an idea of what I’m doing wrong but I don’t know how to solve it. I get the screen that says

    +We were able to connect to the database server (which means your username and password is okay) but not able to select the /Dungeon database.

    Are you sure it exists?
    Does the user ***** have permission to use the ***** database?
    On some systems the name of your database is prefixed with your username, so it would be like username_/Dungeon. Could that be the problem?

    If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Forums +

    but I think what I’ve failing to do is create a user with the proper credentials to access the site. How do I create a new user using FileZilla because I initially thought it meant use my username and password for the website but that obviously isn’t working.

    If that isn’t the case in the database selection, if I have my database “Dungeon” inside the /public_html do I need to put the domain as /public_html/Dungeon? or do I still just put Dungeon? Or do I put /Dungeon?

    Sorry for the block of questions I’m just stuck.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator James Huff

    (@macmanx)

    9 years, 10 months ago

    This your MySQL database, it’s not a file nor is it accessible via FTP.

    Look for something named MySQL Databases in your hosting account’s control panel, and if you can’t find it there consult your hosting provider’s documentation and/or support department.

    ScottyMitch

    (@scott_mi)

    9 years, 10 months ago

    Many hosts provide a control panel, with cPanel being the most common.

    If that is your case, there is a Database category in the main interface. You can create a user for your database using the ‘Create Database’ tool.

    When attaching the user to the database, you will have the option of assigning privileges for that user. There should be a checkbox for ALL. That will help then assign the user to the database with full permissions.

    If you do not have cPanel, there should be something similar in your host interface.

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

The topic ‘Can't Select Database’ is closed to new replies.