Re: issue with connecting to DB
| From: | Joel Colombo | Date: | Mon, 31 Mar 2003 02:18:07 +0000 |
| Subject: | Re: issue with connecting to DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-141663@lists.php.net to get a copy of this message | ||
did u change the password with 'phpmyadmin' ?
u did ? ok then restart mysql !!!!
the passwords load when mysql starts up... at least when u change it via 'phpmyadmin'
havent played much with command line password mods... may not need the restart.
i just pounded my head with the prob last week... running redhat with mysql PHP combo.
all worked after i restarted the mysql service from command line.
Joel Colombo
"Jennifer Fountain" <JFountain@rbinc.com> wrote in message news:4986B9AA97C37D4D91E554CA8D84415B1628B5@rbnt1.rb.net...
Here is the code:
<?php
$link = mysql_connect("xxx", "xxxxx", "xxxxx")
or die("Could not connect: " . mysql_error());
print ("Connected successfully");
mysql_close($link);
?>
WhenI try to connect, I get the following error:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'xxxx@xxxx'
(Using password: YES) in /xxx/xxxx/xxxxx/xxxx/testdb.php on line 2
Could not connect: Access denied for user: xxxxx@xxxx' (Using password: YES)
I know the userid and password work because I can connect to the db via phpmyadmin, etc.
version
mysql 3.23.52
php 3
I have google searched and archived searched but I cannot find anything on this error. We
recently changed the password.
Does anyone have any idea what is happening?
Thanks