Announcement

Collapse
No announcement yet.

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource

    If you are getting the above error during installation, this means either:

    1. One or more of the following is wrong in your config.php file:
    $servername (except in rare cases, this should almost always be left as 'localhost' or '127.0.0.1')
    $dbusername
    $dbpassword
    $dbname

    If you are unsure of what the appropriate values are then you will need to ask your web host.

    2. Or that this db user is not assigned to that database or does not have permission to access MySQL to create or access a database. You may need to first manually create the database and assign the db user to it. Since each web host is different, if you do not know how to do this then contact your web host for help.

    3. Or you are running MySQL 4.1.x. As of MySQL 4.1.X there is a new password hashing system. PHP4 does not have builtin support for it as of yet, however PHP5 does. In order for your old PHP4 MySQL clients to be able to connect to the MySQL 4.1.X database you need to set an OLD_PASSWORD. You should be able to run the following Query to make it possible for PHP4 to access the MySQL 4.1.X database.

    SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('password');

    More info is here:
    http://dev.mysql.com/doc/mysql/en/password-hashing.html
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.



  • #2
    #3 worked perfect for me running:

    vB 3.6.10
    IIS6
    MySQL 4.1.22
    PHP 4.4.8

    Might be a good sticky item Thanks!

    Comment


    • #3
      why would I get #1044 - Access denied for user anyone?

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X