MySQL settings help (4 posts)

  1. Rainbowjoule
    Posted 11 years ago #

    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.

  2. Mark (podz)
    Support Maven
    Posted 11 years ago #

    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.

  3. moshu
    Posted 11 years ago #

    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.

  4. Rainbowjoule
    Posted 11 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.