Since you are using phpMyAdmin, I would suggest taking a look at the
user table in the mysql database. I would suspect that you do not have the
proper permissions in the user table. If this 'admin' user should have full
rights to the database, you will need to make sure that you have two entries
for 'admin'. One entry should have the 'host' field entry of 'localhost',
the other entry should define any remote connections like '%.test.com' to
connect from any system in the 'test.com' DNS domain. Both of these entries
should then have 'Y' for all of the 'priv' values.
I hope this helps, and I hope I am correct. Someone please let me
know if I have screwed something up here.
-----Original Message-----
From: Damiano Ferrari [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 1:39 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] another problem with mySQL server
Hello everybody,
I am having again problems with the mySQL server. I wrote one simple
.php page with the following lines:
<?
mysql_connect("localhost","admin","password") or die("Could not connect to
server");
?>
When I call the script, I get this error:
Warning: Access denied for user: 'admin@localhost' (Using password: YES) in
D:\Inetpub\wwwroot\test.php on line 2
Warning: MySQL Connection Failed: Access denied for user: 'admin@localhost'
(Using password: YES) in D:\Inetpub\wwwroot\test.php on line 2
Could not connect to server
I started having problems while I was updating some tables through
phpMyAdmin. I suspect this must be a problem related to mySQL, but how
do I verify that and how can I fix the problem? Any idea/help would
be, again, much appreciated.
Damiano
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
