• I don’t know where the problem is. It’s been driving me crazy all day!
    Please help.
    ———————————————————————
    This is the error message:
    We were able to connect to the database server (which means your username and password is okay) but not able to select the ****** 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_wordpress. Could that be the problem?

    ——————————————————————-
    This is my wp-config.php file:

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘******’); // The name of the database
    define(‘DB_USER’, ‘@@@@@’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘——‘); // …and password
    define(‘DB_HOST’, ‘******.db’); // 99% chance you won’t need to change this value–>I changed it!
    define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);

    // Change each KEY to a different unique phrase. You won’t have to remember the phrases later,
    // so make them long and complicated. You can visit http://api.ww.wp.xz.cn/secret-key/1.1/
    // to get keys generated for you, or just make something up. Each key should have a different phrase.
    define(‘AUTH_KEY’, ‘[email protected]{)o_}m*O\\_;\”xqQLTvxT_ $FFur =Dtw)[xs(|JwAdl(M8y’); // Change this to a unique phrase.
    define(‘SECURE_AUTH_KEY’, ‘6DN%zzFiz97L_XA|MLJ&t8W&!<6_6PacqCgF)\”7)\Md1y+]gi\”A-C5R*Y(Xsg8yB’); // Change this to a unique phrase.
    define(‘LOGGED_IN_KEY’, ‘I75A~9FHcg;p&f8 :1Mf\]*=[:;5+jz-h2OR%\\yFC7s +K!q+ !*)m’); // Change this to a unique phrase.

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-content/languages.
    // For example, install de.mo to wp-content/languages and set WPLANG to ‘de’
    // to enable German language support.
    define (‘WPLANG’, ”);

    /* That’s all, stop editing! Happy blogging. */

    if ( !defined(‘ABSPATH’) )
    define(‘ABSPATH’, dirname(__FILE__) . ‘/’);
    require_once(ABSPATH . ‘wp-settings.php’);
    ?>
    ———————————————————————
    This is my MySQL information set up with NearlyFreeSpeech.net:

    MySQL Processes
    DSN ******.db
    Status Runnable
    Running Running

    DSN (or “Hostname”) ******.db (never use “localhost”)
    Default Admin Username @@@@@
    Default Password (Your member login password)*

    ——————————————————————
    Please help! I would really appreciate your reply!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Who is your host – maybe we can help?
    Do you need to append the user name?
    user_sometheing.db

    Thread Starter rain_coat

    (@rain_coat)

    This is my MySQL information set up with NearlyFreeSpeech.net:

    MySQL Processes
    DSN ******.db
    Status Runnable
    Running Running

    DSN (or “Hostname”) ******.db (never use “localhost”)
    Default Admin Username @@@@@
    Default Password (Your member login password)*

    The MySQL information specifically says not to use “localhost”.
    So I’ve put ******.db exactly as displayed in the DSN infromation for ‘DB_HOST’

    With nearlyfreespeech you create the database and typically that is your account name with .db at the end.

    Please read your host’s directions for creating the database and database user. If necessary, call nearlyfreespeech.net because their control panel is confusing when dealing with MySQL databases.

    How to install at nearlyfreespeech
    http://danweinstein.net/dantoday/?p=68

    New location for WordPress on Nearlyfreespeech.net installation guide:
    http://teaching.nfshost.com/dantoday/?p=168

    I am getting the same error message as Raincoat; “We were able to connect to the database server (which means your username and password is okay) but not able to select the ****** database”
    In my case I already have a domain name which I want to keep.
    I have downloaded the wp file, modified the wp-config.php file per instructions.
    My host is Profitgate.net who I have used for over 10 years, but I have an ‘el cheapo’ plan with no tech support. I navigated the cpanel easily, found the MySQl and entered the database name, username and password. MySQL appended the database name and password.
    Since I had an existing website, I found the public_html folder, emptied it and uploaded the WordPress files.
    I got an email from profitgate telling me that WordPress has been installed, but when I try the Admin URL: http://@@@@@@@@.com/WordPress/wp-admin/ I get the error message described above.

    Any suggestions?

    Yep ETEC – Your MYSQL DB_USER name is incorrect in your wp-config.php file.

    Keep Guessing – Maybe you’ll get lucky 🙂

    OR – You might try logging into your mysql data base, find the folder that has your wp_ files in it.

    And that folder name may be your DB_USER name? Worth a shot anyways.

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

The topic ‘Can’t select database: not able to select the ****** database’ is closed to new replies.