Re: can't connect to mysql

The using password:YES it doesn't mean the user require a password (this can be a security hole by displaing this message) ... it means that the user which is trying to connect are using a password to connect to mysql. Second: the error doesn't mean that the user are using a bad password or a password at all (in this case the error is bad password) it means that your user (the root@localhost are a different user then the root@anotherhost) are not authorised to login into the mysql. For each host from which you are trying to connect youi should add from the root@localhost an entry to the mysql database into the host and user tables with the action writes that the user is authorised to do for a db or for every db ... Indeed you should read more careffuly the mysql manual in how to add users, how the password are crypted, and how to give the users appropriate rights. However this is not a php problem ... this is a mysql problem -- ------------------------------------------------- Cristian MARIN - Developer InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 cristic@interakt.ro "Doris Pelger .:. Eva Horner" <insite@zonnet.nl> wrote in message news:003101c341b1$11248a10$f7a9a63e@computereva... > Hi Zicux > Using password: YES, means that you have to use the password when connecting > to the db. > > If you cannot connect with your password, you do not have the proper rights. > You could then turn to the MySql manual and check the "Grant" and privileges > section. > > Cheers, > Doris > > ----- Original Message ----- > From: "zicux" <zicux@navigator.lv> > To: <php-windows@lists.php.net> > Sent: Thursday, July 03, 2003 11:35 PM > Subject: [PHP-WIN] can't connect to mysql > > > > Hello, > > > > I have a problem with connecting to MySQL. It gives out message like > > this: > > "Warning: mysql_connect(): Access denied for user: > 'user@XXX.XXX.XXX.X' (Using password: YES)" > > What the heck does that password YES mean, cause I use another > > password. > > > > -- > > > > zicux mailto:zicux@hello.lv > > > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php >