WordPress.org

Ready to get started?Download WordPress

Forums

The following errors were found : The MySQL Database could not be selected. (11 posts)

  1. fbgiant
    Member
    Posted 1 year ago #

    In my Host i am allowed to create only 2 databases, that already i created.
    I want to install 3,4 WordPress sites in my host.
    I am trying to do it using Softaculous., When i click install i am allowed to choose my domain, when i do it, some other fields are automatically filled. They are
    In Directory - WP
    Database Name - a random number like wp34,wp28,wp894,etc..
    Table Prefix -wp_
    But when installation continues it show error "The following errors were found :
    The MySQL Database could not be selected".

    Now help me please to overcome this error situation.

  2. JungleSpace.net
    Member
    Posted 1 year ago #

    Softaculous will create the database for you. You do not need to create it manually.

    You would need to free up one database for Softaculous by deleting one you have just created.

  3. fbgiant
    Member
    Posted 1 year ago #

    i can not delete my database because it is already in use for my existing website

  4. drsohel
    Member
    Posted 1 year ago #

    I don't have totally similar issue. But I have problems with selecting database issue. So I'm writing my problem, whether I could find any solution here.... I recently moved one of my site from one hosting package to another hosting package of same hosting provider. After moving files when tried to get into my sites, I got the following messages:

    We were able to connect to the database server (which means your username and password is okay) but not able to select the go******_w***1 database.

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

    I couldn't understand the suggestion provided in the error message...

    I've edited the wp-config.php file with newly created database info. I followed instruction from:
    http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_Within_Your_Site

    Can anyone give any solution?

  5. fonglh
    Member
    Posted 1 year ago #

    @drsohel

    Start your own topic.

    @fbgiant

    You can install WordPress into an existing database by putting the database credentials in the wp-config.php file. You might want to consider doing a manual install instead of using Softaculous as your case is a little different.

  6. drsohel
    Member
    Posted 1 year ago #

    @fonglh
    Thanks for the advice...

  7. michael.mariart
    Member
    Posted 1 year ago #

    Remember to check the setting for
    $table_prefix = 'wp_';
    in your wp-config.php file and make sure that the prefix that you are uisng isn't used in the database that you're running.

  8. brijesh-soft
    Member
    Posted 1 year ago #

    Hi,

    I am from the Softaculous team.
    The error "The MySQL Database could not be selected" appears when Softaculous is unable to create database.
    As you said that you are allowed only two databases which you have already used. So we recommend you either delete one of the database which you do not want to. So you can ask you host to allow few more databases to you maybe for a fee.

  9. fbgiant
    Member
    Posted 1 year ago #

    I Tried to install using filezilla.
    I created a database and created 2 users for that database using my cpanel-mysql.
    Then i installed wordpress for my website-1 using user1 username and password.It worked fine.
    But when i tried to install my website-2 using user2 username and password , when tried to create account in wordpress it shows an error

    "Already Installed

    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

    Log In"

    What can i do to solve this issue?..
    Isn't it possible to install wordpress in 2 domains using only 1 database?...

  10. fbgiant
    Member
    Posted 1 year ago #

    Any one please reply..

  11. Shahroon
    Member
    Posted 1 year ago #

    "sql error and The MySQL Database could not be selected" It happens when you have exceeded the number of databases allowed to you by your hosting package.

    I got the same issue while i tried to install wordpress the 3rd time in some directory while 2 databases already exists.It says

    "sql error and The MySQL Database could not be selected"

    This problem occurs when your hosting package allows the number of databases you have already reached to.As I have changed my hosting package to a package having 3 databases,installation is now successful.

Topic Closed

This topic has been closed to new replies.

About this Topic