smith
  • Trying to restore a DB from my production server to the new build...


    C:Documents and SettingsAdministrator>mysql -udb -p fourms < C:Inetpubwwwrootscumbagforumsforumbackup-08-14-2005-3.sql
    Enter ********

    ERROR 1044: Access denied for user: 'xxxdb@localhost' to database 'scumbag_fourms'

    C:Documents and SettingsAdministrator>

    I just built a new version of MySQL 4.0.25, PHP 4.4.0 and vB 3.0.8. My production server is MySQL 4.0.23, PHP 4.3.10, and vB 3.0.8.

    I've done this once before without problems.

    I can log into MySQL without problems (it takes my password).

    C:Documents and SettingsAdministrator>mysql -u scumbagdb -p
    Enter ********

    Welcome to the MySQL monitor. Commands end with ; or g.
    Your MySQL connection id is 100 to server version: 4.0.25-nt

    Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
    mysql> quit

    Bye

    The current clean DB is writeable, causing no errors other than when I try to import the DB from the production server.

    Any help would be appreciated.

    WinSvr2003 SP1
    MySQL 4.0.25
    PHP 4.4.0
    vB 3.0.8

    Thanks in advance...

    EDIT: I can dump the current installed DB (a new one) with no problems. I can't re-import that one either. I thought it may have something to do with the DB I am trying to import from my production server, but not that does not appear to be the case.


  • Those are all the known causes of the 'access denied' error that I'm aware of.


  • Please see this:

    http://www.vbulletin.com/forum/showthread.php?t=145385


  • Fixed. I re-installed MySQL and it solved the problem...

    Thanks for the help Steve.


  • OK, I checked those links and none of those situations apply.

    My config.php has all fo the correct entries. I'm not running 4.1 so no dice there.

    I can backup the database, which requires config.php to be correct. I just can't import.

    Anything else I should be looking at?







  • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Access Denied Error , Please add it free.
    • edit