"Access denied" error talking to MySQL

Question

I am getting this warning on line 25:

Warning :
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' >(using password: NO) in C:\xampp\htdocs\shadaab\register.php on line 25

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\shadaab\register.php on line 25 Access denied for user 'ODBC'@'localhost' (using password: NO)"

I have following SQL query on line 25:

$result=mysql_query("SELECT email FROM user WHERE email='$email'")or die(mysql_error());

How are you connecting to the mySQL database? Are you connecting at all? — Pekka
– Pekka, Commented Aug 20, 2011 at 18:37
Possibly helpful: Reference: What is a perfect code sample using the mysql extension? — Pekka
– Pekka, Commented Aug 20, 2011 at 18:38
the problem is with the mysql_connect . check the parameters are right. — Mithun Satheesh
– Mithun Satheesh, Commented Aug 20, 2011 at 18:39
@Aditii Was this caused by the same issue as in this question that I helped you with earlier? If so, you may want to flag this post for moderator attention (see the "flag" link below your question) and ask them to merge this question with that one. — anon
– anon, Commented Aug 21, 2011 at 7:48

Sarfraz · Accepted Answer · 2011-08-20 18:44:50Z

1

The error message means:

You have not connected to database (using mysql_connect and mysql_select_db)
If you have specified mysql_connect, you are not specifying correct username and password to the mysql_connect function.

Here is how you can connect to your db before running your SQL queries:

$con = mysql_connect('server address', 'username', 'password') or die(mysql_error());
mysql_select_db('your db name') or die(mysql_error());

More information on official documentation.

edited Aug 20, 2011 at 18:44

answered Aug 20, 2011 at 18:39

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aditii Over a year ago

$localhost="localhost"; $username="root"; $password=""; $dbname="shadaab"; $con=mysql_connect("$localhost","$username","$password"); mysql_select_db("$dbname",$con);

Sarfraz Over a year ago

append or die(mysql_error()) to those function like i have shown to see if there is an error.

Andrej · Accepted Answer · 2011-08-20 18:39:16Z

0

It seems that you provide invalid data in mysql_connect. Check user/password.

answered Aug 20, 2011 at 18:39

Andrej

7,5041 gold badge22 silver badges22 bronze badges

Comments

Joe Flynn · Accepted Answer · 2011-08-20 18:39:34Z

0

Looks like a connection problem, check that you are calling mysql_connect above that line, and that your settings (password, host name, database name) and permissions are correct. Docs

answered Aug 20, 2011 at 18:39

Joe Flynn

7,2346 gold badges34 silver badges44 bronze badges

Collectives™ on Stack Overflow

"Access denied" error talking to MySQL

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related