Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. #1
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\Inetpub\wwwroot\www.xxxxxxxxx.com\db_connect.php on line 9
    Could not connect to MySQL
    Ive had this error before. I know it has to do with the new security mesures or something.... Help?

  2.  

  3. #2
    Senior Member megablaz0r's Avatar
    Join Date
    Jul 2004
    Location
    Cheyenne, Wyoming
    Posts
    508
    Member #
    6548
    permissions set correctly?

  4. #3
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    yes, everything is setup properly. I managed to fix it. It was to do with setting the user table's password. Thanks anyway.

  5. #4
    Banned
    Join Date
    Mar 2005
    Posts
    45
    Member #
    9233
    It's a bad idea to mess with the user table manually! I would reinstall MySQL. It probably would be faster for you, than trying to backtrack where you messed up the table!

    Regards, Drew
    Captain Media

  6. #5
    Senior Member Eddy Bones's Avatar
    Join Date
    Jan 2004
    Location
    Washington, USA
    Posts
    1,054
    Member #
    4651
    Reinstall mysql over a table? I don't think so.

  7. #6
    Banned
    Join Date
    Mar 2005
    Posts
    45
    Member #
    9233
    Installing MySQL is easy.

    Regards, Drew
    Captain Media

  8. #7
    Senior Member mossoi's Avatar
    Join Date
    Apr 2003
    Location
    Englandshire, United Kingdomsville y'all!
    Posts
    1,111
    Member #
    1206
    Liked
    1 times
    but hardly a fix for a simple password problem.

  9. #8
    Senior Member rosland's Avatar
    Join Date
    Jul 2003
    Location
    Norway
    Posts
    1,944
    Member #
    2096
    Assuming you have installed the new MySQL 4.1.x series,
    you have probably used the old_password() fix, to make PHP's mysql-extension work. That is a perfectly 'legal' fix (presented by mysql.com themselves) to avoid rewriting all your files to adhere to the new encryption algorithm.

    The new mysqli-extension in PHP5.0, adheres to the stricter password hash found in the 4.1.x series.
    (If you add a new user through a GRANT statement, you can use mysqli to build your queries later. They support a much broader range of sophisticated features in the 4.1.x series, than the old mysql-extension.
    S. Rosland

  10. #9
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    Thanks guys for the help. What Rosland says about the old password fix is what I did. But that didnt seem to fix the problem.

    But guys, dont laugh. The reason why it wasnt working was.....the password was incorrect. Me = dumbass. :classic:

    BTW, Why was Captain dude banned?

  11. #10
    Senior Member Eddy Bones's Avatar
    Join Date
    Jan 2004
    Location
    Washington, USA
    Posts
    1,054
    Member #
    4651
    Advertising, I believe. Least, that's what it seemed like to me. He kept saying in threads that he created this, that, and the other thing, and if we knew anyone that needed it.

    Aside from that, his answers were anything but helpful and did not contribute to the community.


Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:04 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com