MySQL Dilemma

[Juicy D. Links]

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]

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.

[Babaganoosh]

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.

[JSA Matt]

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.

[pornanza]

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

[CS-Jay]

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.

[avion]

it says: Using password: NO

check how did u setup ur pass...

[fuzebox]

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?

[Hansm]

Register_global errors maybe?