Re: MySQL Username and Passwords

phpMyAdmin has an option to "reload mysql" too. It won't work until that is done. Where did you get the idea, that the username worked? It just tells, that access has been denied ... the same message would be sent if the user didn't exist at all! Thomas On Sun, 9 Feb 2003 12:40:12 -0500 webmaster@melchior.us (Stephen Craton) wrote: > I'm not sure how except through shell which isn't enabled. Even if I didn't > reload it, why would the username work but the password not? > > > ----- Original Message ----- > From: "John Nichel" <jnichel@by-tor.com> > To: "Stephen Craton" <webmaster@melchior.us> > Cc: "PHP List" <php-general@lists.php.net> > Sent: Sunday, February 09, 2003 12:29 PM > Subject: Re: [PHP] MySQL Username and Passwords > > > > Did you reload MySQL after you added the new user? > > > > Stephen Craton wrote: > > > It's me again, trying to get some more help. > > > > > > My boss is hosting sites now for games and I need some help with setting > up > > > phpMyAdmin privelages for certain MySQL users and such. Right now, my > > > problem is setting up a new MySQL username and password. > > > > > > I add a new user in phpMyAdmin, I type in the details, everything is > fine. > > > When I go to test the connection with those connection details, I get > this > > > error: (I copied and pasted the username and password so they are the > same > > > for both the script and when I entered them into phpMyAdmin.) > > > > > > Access denied for user: 'd2sector@localhost' (Using password: YES) > > > > > > My code is as follows: > > > > > > <?php > > > if(@mysql_connect('localhost', 'd2sector', '**Edited > > > Out**')) { > > > header("Location: index.php"); > > > } else { > > > echo '<font color="red">Unable to connect to database. Error as > > > follows:</font><br>'.mysql_error(); > > > } > > > ?> > > > > > > Does anyone have a clue as to why this happens and how to fix it? I'll > need > > > to know how to fix this for future users as well. Thanks in advanced. > > > > > > > > > Thanks, > > > Stephen Craton > > > http://www.melchior.us > > > > > > > > > > > > > > > -- > > By-Tor.com > > It's all about the Rush > > http://www.by-tor.com > > > > > > > > -- Thomas Seifert mailto:thomas.seifert@myphorum.de http://www.MyPhorum.de