Can’t select database

  • Resolved jpcstl

    (@jpcstl)


    17 years, 6 months ago

    I’m trying to install WP for a non-profit and things are working like they should. In the PHP My Admin it said I couldn’t create a new database. But in some documentation provided to me by the non-profit, it mentioned something called Fantastico that said it would install WordPress 2.1.2 to the site. It created a new db and installed the files. Then I uploaded the 2.2.2 files and overwrote what the Fantastico site installed. I then went to the /wp-admin/upgrade.php and got the following error message.

    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 eliotc2_wrdp1 database.

    * Are you sure it exists?
    * 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?

    I checked the PHP My Admin and it shows that the database exists, so I’ve no idea where to go from here. Thoughts?

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

  • Maybe the you have something wrong with the actual database name.

    In the PHP My Admin it said I couldn’t create a new database.

    That’s right. You never create the DB in phpMyadmin. You create it in cPanel (or whatever site admin tool they have).

    Thread Starter jpcstl

    (@jpcstl)

    Moshu, right, I realized that the other day. So at the site admin tool, the data base is there, I see it. I might just delete it and start over and see if I can create it again, that should give me more control on the install that I’m used to (rather than using the screwing online thing).

    Had the same problem, seems that with some installs of Fantastico, it forgets to add the “user” info to the database, which therefore blocks data getting into the database.
    In cpanel click on the “mysql database” button, then it should list the databases you have within your acct. In my case the WP install showed no user info.

    Simply look down the page a bit more, till you see the table of current users. You will see that the user is listed there.

    Just above that table are two dropdowns with the heading “add user to database”
    Select the user in the frist box, then assign them to the database in the next box, then click submit.

    Next screen is to set permissions, i normally select all as it is for me the admin ??

    Hope that makes sense and saves someone the hassle of an hour or two trying to sort it out…

    fred fred

    thankyou thankyou. I was having the same problem and I thought I had done what you had said already but when I did in the second time it worked a treat. At least now I can get in!!!!

    Thanks again
    Lisa

    Hi neillisa

    Glad it helped you. We have used wordpress for a few years as a personal blog but only lately rediscovered the amazing things it can do.
    With the “right” plugins installed for what you do it can work wonders and so easy for clients to learn.

    We plan to transfer over many of our small biz clients to wordpress v2.3 when it is released next week.

    I am having the same problem. Could any of you please explain better how to do this. My host runs Cpanel, I tried to create a database in the mysql administrator but I didnt know what I was doing at all.

    I need the name of the database, what is this name?

    Fredfred This is great advice…really saved my day!

    emc2

    (@emc2)

    I just had this same problem with a manual install of WP on my server, and ended up discovering two things that I didn’t find elsewhere:

    1. When specifying Username/Password in wp-config.php, you *must* enter the combo you set up for the user you added to the database you created in your control panel. It will not work if you use the Master User’s username/password.
    2. When specifying Host you must check to see where your web host has their MySQL installation. If they are running multiple MySQL versions (as mine was), you *must* enter the correct host location. For example, my host was running MySQL 4 databases under “localhost” and MySQL 5 databases under “localhost:/tmp/mysql5.sock”.
    mrkimb

    (@mrkimb)

    EMC2, A thousand thank youzzzzzzz for the tip on the user name and password. May you live the life that other’s only dream of. Thanks again, Kim

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Can’t select database’ is closed to new replies.