Programming Forums > Web Development and Design > PHP

ArchAngel · Mar 7th, 2005, 2:27 PM

Yes, that's right, I'm having another problem with MySQL,
I'm trying to connect to MySQL with this code:

[PHP]<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Title here!</title>
</head>
<body>
<?php
$user="usr";
$host="ip";
$password="pwd";
mysql_connect($host,$user,$password);
?>
</body>
</html>[/PHP]

But instead of connecting, I get this little present:

Warning: mysql_connect(): Access denied for user: '****@*******' (Using password:YES)

Anybody know what's wrong?
ArchAngel

Dizzutch · Mar 7th, 2005, 2:52 PM

your MySQL server isn't letting your user connect because
a) your password is wrong
b) the username doesn't exist
c) that user is not allowed to login from the host name it's logging in from
d) any combination of the above
check your MySQL Server

Dizz

ArchAngel · Mar 7th, 2005, 4:47 PM

How pray tell does one check this information?

Pizentios · Mar 7th, 2005, 4:52 PM

in postgresql, you have to set the permissions of the database to allow outside (as in from the net) connections with a certain user. Not sure if you would have to do something like that for mysql. In postgresql the file is called pg_hba.conf or something like that.

BlazingWolf · Mar 7th, 2005, 6:56 PM

If you never set the Username, or password then it is

User: "root"
Pass: ""

No qoutes of course.

The host I assume is running on the machine you are testing your PHP on so it is "localhost".

ArchAngel · Mar 7th, 2005, 8:39 PM

I have username, and password, in my.ini,
and I'm sure I'm using them, but it still doesn't work.

tempest · Mar 7th, 2005, 8:41 PM

Weird. The problem is the database isn't allowing those credentials to pass. MySQL doesn't think that's the right information...

ArchAngel · Mar 8th, 2005, 7:57 AM

Is there any other way to check any other accounts I have besides the one I was trying?

Infinite Recursion · Mar 8th, 2005, 9:11 AM

Add a new user to the User table in MySQL ... change the login information in your script to reflect the new user info. Then try it,

ArchAngel · Mar 8th, 2005, 10:06 AM

'User table'? Sorry but I'm a SQL nub, you mean make a diff account in the ini?

Mar 7th, 2005, 2:27 PM	#1
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	More MySQL errors Yes, that's right, I'm having another problem with MySQL, I'm trying to connect to MySQL with this code: [PHP]<!doctype html public "-//W3C//DTD HTML 4.0 //EN"> <html> <head> <title>Title here!</title> </head> <body> <?php $user="usr"; $host="ip"; $password="pwd"; mysql_connect($host,$user,$password); ?> </body> </html>[/PHP] But instead of connecting, I get this little present: Warning: mysql_connect(): Access denied for user: '**@****' (Using password:YES) Anybody know what's wrong? ArchAngel __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home. Last edited by ArchAngel; Mar 7th, 2005 at 2:30 PM.*

Mar 7th, 2005, 2:52 PM	#2
Dizzutch Professional Programmer Join Date: Dec 2004 Location: Worcester, MA Posts: 441 Rep Power: 4	your MySQL server isn't letting your user connect because a) your password is wrong b) the username doesn't exist c) that user is not allowed to login from the host name it's logging in from d) any combination of the above check your MySQL Server Dizz __________________ naked pictures of you \| PFO F@H stats

Mar 7th, 2005, 4:47 PM	#3
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	How pray tell does one check this information? __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Mar 7th, 2005, 4:52 PM	#4
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	in postgresql, you have to set the permissions of the database to allow outside (as in from the net) connections with a certain user. Not sure if you would have to do something like that for mysql. In postgresql the file is called pg_hba.conf or something like that. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Mar 7th, 2005, 6:56 PM	#5
BlazingWolf Hobbyist Programmer Join Date: Sep 2004 Posts: 207 Rep Power: 4	If you never set the Username, or password then it is User: "root" Pass: "" No qoutes of course. The host I assume is running on the machine you are testing your PHP on so it is "localhost". __________________ _______________________________ BlazingWolf

Mar 7th, 2005, 8:39 PM	#6
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	I have username, and password, in my.ini, and I'm sure I'm using them, but it still doesn't work. __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Mar 7th, 2005, 8:41 PM	#7
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	Weird. The problem is the database isn't allowing those credentials to pass. MySQL doesn't think that's the right information... __________________

Mar 8th, 2005, 7:57 AM	#8
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	Is there any other way to check any other accounts I have besides the one I was trying? __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Mar 8th, 2005, 9:11 AM	#9
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,462 Rep Power: 8	Add a new user to the User table in MySQL ... change the login information in your script to reflect the new user info. Then try it, __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Mar 8th, 2005, 10:06 AM	#10
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	'User table'? Sorry but I'm a SQL nub, you mean make a diff account in the ini? __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

More MySQL errors