MySQL Dilemma

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • juicylinks
    So Fucking Banned
    • Apr 2001
    • 122992

    #1

    MySQL Dilemma

    Ok

    I got all the db name , user , pass shit correct but i get this


    Warning: Access denied for user: 'root@localhost' (Using password: NO) in /usr/........../setup.php on line 3

    Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /usr/home/........./setup.php on line 3
    Could not connect

    I must be all fucked cause of this Nyquil but am I mising something here?
  • liquidmoe
    Confirmed User
    • Mar 2002
    • 4994

    #2
    Add -p if you are running from command line, otherwise mysql will think you are trying to access the username/db without a password as if there wasnt one on the account.

    Take Luck!

    Comment

    • Babaganoosh
      ♥♥♥ Likes Hugs ♥♥♥
      • Nov 2001
      • 15841

      #3
      If you just added the user or changed the password you may have to reload mysql before the changes will take effect. I forget to reload a lot.
      I like pie.

      Comment

      • JSA Matt
        So Fucking Banned
        • Aug 2003
        • 5464

        #4
        Originally posted by juicylinks
        (Using password: NO)
        Apparently, you didn't add the password to the script or messed something up because MySQL is not recieving a password.

        Comment

        • pornanza
          Confirmed User
          • Jul 2003
          • 238

          #5
          Originally posted by JSA Matt


          Apparently, you didn't add the password to the script or messed something up because MySQL is not recieving a password.

          Yep, this error is very common. If the MySQL details are correct, then make sure that that setup file is being included

          ryan
          Eskimo Hoe
          QuickWank
          Pornanza!

          Comment

          • CS-Jay
            Confirmed User
            • Oct 2003
            • 1794

            #6
            use this one:

            if(!($dbcon = mysql_pconnect("localhost", "username", "password")))
            {
            print("Failed connection 1 \n");
            exit();
            }
            //select db
            if(!mysql_select_db("dbname", $dbcon))
            {
            print("Failed connection 2 \n");
            exit();
            }

            and don't forget to flush privileges.

            and as a tip, you should not be using root to connect to your db, you should create another user.
            I do stuff - aIm CS_Jay_D

            Comment

            • avion
              Confirmed User
              • Jan 2003
              • 1403

              #7
              it says: Using password: NO

              check how did u setup ur pass...

              Comment

              • fuzebox
                making it rain
                • Oct 2003
                • 22369

                #8
                I'm guessing you're not passing any of your authentication information to MySQL, since I doubt you meant to connect as root and it thinks you are, plus the no password note.

                What are you installing?

                Comment

                • Hansm
                  Confirmed User
                  • Jun 2002
                  • 871

                  #9
                  Register_global errors maybe?

                  Comment

                  Working...