MySQL Dilemma - GoFuckYourself.com

Juicy D. Links · 12-29-2003, 05:58 PM

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 · 12-29-2003, 05:59 PM

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 · 12-29-2003, 06:04 PM

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 · 12-29-2003, 06:11 PM

Quote:

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 · 12-29-2003, 06:48 PM

Quote:

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 · 12-29-2003, 06:59 PM

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 · 12-29-2003, 07:05 PM

it says: Using password: NO

check how did u setup ur pass...

fuzebox · 12-29-2003, 08:26 PM

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 · 12-29-2003, 11:51 PM

Register_global errors maybe?

12-29-2003, 05:58 PM	#1
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	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?

12-29-2003, 05:59 PM	#2
liquidmoe Confirmed User Join Date: Mar 2002 Location: NY Posts: 4,994	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!

12-29-2003, 06:04 PM	#3
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	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.

12-29-2003, 06:59 PM	#6
CS-Jay Confirmed User Join Date: Oct 2003 Location: Command Central, West Palm Beach, Fl Posts: 1,794	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

12-29-2003, 07:05 PM	#7
avion Confirmed User Join Date: Jan 2003 Location: right next to u Posts: 1,403	it says: Using password: NO check how did u setup ur pass...

12-29-2003, 08:26 PM	#8
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,115	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?

12-29-2003, 11:51 PM	#9
Hansm Confirmed User Join Date: Jun 2002 Posts: 871	Register_global errors maybe?