WordPress.org

Support

Support » Installation » MySQL settings help

MySQL settings help

  • I’ve read posts on here dealing with the troubles I’m having and done what those said to do, but I still can’t get the wp-config file to work. Every time I change something and try it, I end up with the “Error establishing a database connection!” message.
    Here’s what I have for the settings right now:
    define(‘DB_NAME’, ‘rainbowjoule_mysql’); // The name of the database
    define(‘DB_USER’, ‘rainbowjoule_evilcb’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘*********’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    I’ve changed this around many times and still haven’t gotten it to work. I know my username and password are correct, and that I need “mysql” for the database name, but I’m not sure if the “rainbowjoule_” parts are needed or not (but again, even without them nothing works) and I have a feeling I’m going to have to change the host name, but I’m not sure.
    I know my database is running and working and everthing, but I still can’t figure this out. Any help would be great. Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Check your cpanel.
    Look for a ‘connection string’ – it’s sometimes in italic small letters – and it will have something like:
    DBI:mysql:-your mysql database name-:-your username:-<password>:localhost
    That’s a typical format.

    RJ, check out this thread http://wordpress.org/support/2/11546#post-10 – especially if you have CPanel.
    You have to click the ADD USER button.

    Okay, I was searching through links on my phpMyAdmin on my server, and came across a chart titled “Process list”. In it it lists my user name, host and database as things I’ve tried before (evilcb, localhost, mysql). The only other thing I can find that might list the user and everything differently is the line “MySQL 3.23.49 running on rainbowjoule.net as evilcb@localhost” on the front page. I’m confused.
    Sorry for all the questions. Usually I can work my way through a new computer program, but this one has me stumped.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL settings help’ is closed to new replies.
Skip to toolbar