Installation – DB Connect Error

  • gast

    (@gast)


    19 years, 2 months ago

    I have installed three wordpress instances, three are working, one is not.

    The three working are named:
    asparagazette
    linksoftheweek
    niuviewpoints

    The one that is not working:
    friendsofniuview

    I have one wordpressuser account for all instances (wordpressuser) and I created a db (via mysql) that is the same name as the wordpress instance.

    This is the error:
    Error establishing a database connection

    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at locahost. This could mean your host’s database server is down.

    I dbl checked and everything is named appropriately:

    define(‘DB_NAME’, ‘friendsofniuview’);
    define(‘DB_USER’, ‘wordpressuser’);
    define(‘DB_PASSWORD’, ‘xxxxxxxxx’);
    define(‘DB_HOST’, ‘locahost’);

    Is there a naming length limitation?

    Thanks in advance for your help!

    ~George

Viewing 3 replies - 1 through 3 (of 3 total)
  • MichaelH

    (@michaelh)

    19 years, 2 months ago

    As long as each wordpress blog has a different $table_prefix in wp-config.php you could install hundreds of blogs using the same database, user, password.

    If the database is already created with the user granted the proper privileges, length of the name should not be the issue.

    Maybe the database server is actually down!

    Resource:
    Installing_Multiple_Blogs

    Thread Starter gast

    (@gast)

    19 years, 2 months ago

    The db server is up. The other three blogs work fine. The only issue is getting this fourth one up. Each has their own db, but I went ahead and modified $table_prefix but still the same:
    the other three work fine, I cannot get this fourth one to work…

    ~George

    MichaelH

    (@michaelh)

    19 years, 2 months ago

    If you’ve used a different $table_prefix you should be getting ‘thrown’ into a new installation process.

    So the database server specified in DB_HOST is running, and you’ve confirmed nothing is wrong with the DB_USER and DB_PASSWORD by using phpMyAdmin to access your database(s).

    Did you confirm the database privileges for your DB_USER?

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

The topic ‘Installation – DB Connect Error’ is closed to new replies.

Tags