mysql_connect - Access Denied to DB or DB doesn't exist?

Question

So I connect to my MySQL database using the following code:

function dbConnect($h,$u,$p,$n) {
  if (!$con = @mysql_connect($h,$u,$p)) {$err = err("There is a problem connecting to the database. ".mysql_error());}
  else if (!@mysql_select_db($n,$con)) {$err = err("The database \"{$n}\" could not be found. Check your spelling, make sure the database exists, and that your database credentials allows you access to this database.");}
  return (isset($err)) ? $err : "";
}

The problem is, if they put in a wrong username, mysql_connect will not see anything wrong with it and try to connect to the database, which outputs an error for the mysql_select_db().

So I found this link. Now normally removing the "any" user would be doable but I'm creating a phpMyAdmin-like tool and will be connecting to different databases with all types of configurations. How can I tell which username can actually connect? And how can I differentiate between the database name not existing and the username not having access to it?

And you're not returning the connection on success either, you're returning the error. — Dale
– Dale, Commented Apr 17, 2012 at 23:21
What the... there is nothing wrong with the way I'm using mysql_connect(). I don't return the connection because I call the function which makes the connection to the database. I've tried and tested this and it works. — Err
– Err, Commented Apr 17, 2012 at 23:21

Andreas Linden · Accepted Answer · 2012-04-17 23:09:15Z

1

use mysql_errno()

see error codes here

answered Apr 17, 2012 at 23:09

Andreas Linden

12.8k7 gold badges54 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

mysql_connect - Access Denied to DB or DB doesn't exist?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related