Re: MySQL Username and Passwords

You see, I ran a sample script. I typed in the username and passwords to connect. It fails if I have a password entered. If I leave it blank, it works... ----- Original Message ----- From: "Thomas Seifert" <thomas.seifert@myphorum.de> To: <php-general@lists.php.net> Sent: Sunday, February 09, 2003 5:24 PM Subject: Re: [PHP] 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >