New to the community? Start here

'wp_global'

Hi there.

I managed to install the Multisite DB and stuck with point 5 – final checking screen.

ERROR

“Database Error: Access denied for user ‘staywith_xxxx’@’localhost’ to database ‘wp_global'”

I know this is not correct, because there is no database with this name. It’s should be “staywith_xxxx_global” if I’m not mistaken. If not, the I created the “global” database wrong.

Anyone that might be able to help me with this?

Sat, 6 Apr 2013 14:51:23
  • Ez
    • The Incredible Code Injector

    Hi there.

    Many thanks for the quick response. My error is different from the above. – the dabase don’t exist and I seem to have some confusion around this.

    ERROR

    “Houston, we have a problem!

    Looks like you need to create your new db’s! If you’re lucky, this link still works – click me

    Database Error: Access denied for user ‘staywith_xxxx’@’localhost’ to database ‘wp_global'”

    NOTES:

    -The error above refers to a “database” named “wp_global”. (“wp_” is table prefix, not a database name)

    -My table looks more like “staywith_xxxxx_global” – installation notes under section 2 that reads with the example:

    “CREATE DATABASE dbname_global DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;”

    -I also check that my detail is correct with installation notes 3.3 that reads:

    “Provide the same name you assigned for your global database in Step 2. example ‘dbname_global’”

    Hope this help and make sense.

  • Jack Kitterhing
    • Code Norris

    Hi there,

    Thank you for the clarification.

    Could you post up the info that you used to create the DB please? Replace the username and passwords with fake ones, if you’d rather you can send it to me via email

    jack(at)coding-monkey.com

    That way I can check all the info looks right.

    Thank you!

    Kind Regards

    Jack.

  • Jack Kitterhing
    • Code Norris

    Hi there @ezras

    I’ve been going through your settings for a while now and could you confirm a a few details for me?

    First of all your global DB name was wrong, you had it set to a table that didn’t exist.

    Next the staywith_xxxxx (the x’s are the rest of your DB name, I have left them out on purpose).

    That is the initial DB you set up to use multisite? With that password the you are using?

    How did you create the DB’s? By the tool we provide? Or another way?

    Thanks!

    Kind Regards

    Jack.

  • Ez
    • The Incredible Code Injector

    Hi there.

    -global DB name was wrong. (Thanks for this)

    -Passwords. (using the same password for all the tables)

    -yes, I created the tables with your tools through MSQL as demonstrate on the website.

    Hope this help!

  • Jack Kitterhing
    • Code Norris

    Hi there @Ezra Steenkamp

    I hope you are well today, I’ve just been going through every setting for the past 40 minutes on your DB, files etc.

    It looks like you have the DB name as the DB user name, I presume the user name isn’t also staywith_wp971 correct?

    Let me know and if you could confirm you have a full backup, as I want to overwrite what you have, as i think this is a username/password issue.

    Thanks for being a WPMU DEV member and have a great weekend!

    Kind regards

    Jack.

  • Ez
    • The Incredible Code Injector

    Hi there.

    Here the screen shots as requested.

    [attachments are only viewable by logged-in members] [attachments are only viewable by logged-in members] [attachments are only viewable by logged-in members] [attachments are only viewable by logged-in members]

  • Ez
    • The Incredible Code Injector

    Hi there Barry.

    Hope you well.

    Please find attach the files as requested again. I only included screen shots of the places where I had to change content.

    Hope this help. Also forwarded all the login details of the test site to the helpdesk before.

    [attachments are only viewable by logged-in members] [attachments are only viewable by logged-in members]

  • Barry
    • DEV MAN’s Mascot

    I know this is not correct, because there is no database with this name. It’s should be “staywith_xxxx_global” if I’m not mistaken. If not, the I created the “global” database wrong.

    Well, there’s your problem right there at the top of your move-blogs.php file.

    $newdb_prefix = 'wp_';

    Which should be set to staywith_xxxx_ if that is the prefix of your databases.

  • Barry
    • DEV MAN’s Mascot

    Also, line 16 and line 25 of the screenshot of your db-config.php fie are wrong. Line 16 should only have the first three parts of the IP (see the comment on line 15) and unless you have a table called staywth_wp971_global in your global database, then that line (25) is going to cause issues.

  • Ez
    • The Incredible Code Injector

    Hi there Barry.

    Many thanks for the help.

    -move-blogs.php – fixed the prefix to staywith_xxxx_

    -ip Address changed to '196.38.40.'

    ?-I don't have any tables in my global database yet, so the prefix is ''

    I still get the error:

    Error establishing a database connection

    The move-blogs.php give this error:

    Internal Server Error

    Any suggestions?

    [attachments are only viewable by logged-in members]

  • Barry
    • DEV MAN’s Mascot

    I still get the error:

    Error establishing a database connection

    Can you paste the exact error?

    The move-blogs.php give this error:

    Internal Server Error

    Make sure you have semi-colons at the end of each line – paste it up again if you can’t spot anything.

  • Ez
    • The Incredible Code Injector

    Hi there Barry.

    Also going step for step through everything again to make sure I done it correct.

    *staywithus.co.za

    Error establishing a database connection

    (The only error I get in Firefox)

    *staywithus.co.za/scripts/move-blogs.php

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, webmaster@staywithus.co.za and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

    When I rename the db.php file under db-config.php the site starts running again.

    Hope this help.

  • Barry
    • DEV MAN’s Mascot

    Error establishing a database connection

    That means either your database name or username / password are wrong in your db-config.php file.

    staywithus.co.za/scripts/move-blogs.php

    Internal Server Error

    That’s a standard error and doesn’t help us much :slight_smile:, want to paste up your move-blogs.php again?

  • Ez
    • The Incredible Code Injector

    Hi there Barry.

    Just some confusion and not sure if this will help.

    *Install notes 3.3 say”

    “Line 25: Provide the same name you assigned for your global database in Step 2. example ‘dbname_global’”

    *Line 24 in db-config.php say:

    “EX: add_global_table(‘something’:wink:;”

    Mine is ” on the moment, because I have nothing in the global database.