20 Jan
2004
20 Jan
'04
11:12 p.m.
Hi,
Ticknor.Scott(a)ic.gc.ca wrote:
basically, i am getting MySQL errors when trying to
access serweb.
--
Warning: Access denied for user: 'ser@Lima' (Using password: YES) in
/var/www/html/phplib/db_mysql.inc on line 73
Database error: pconnect(Lima, ser, $Password) failed.
MySQL Error: ()
Session halted.
--
the ser db is created, along with a 'ser' user and the default heslo passwd.
i used phpMyAdmin to grant ser full permissions over the ser db. i suspected
the problem is the appending of @Lima to the user name was problematic, so i
created a 'ser@Lima' user and gave it permissions for the ser db as well.
still no luck.
The mysql user access rights are obviously wrong. Did you:
grant ALL on ser.* to 'ser'@'lima' identified by 'password';?
If the database and webinterface are on the same host try:
grant ALL on ser.* to 'ser'@'localhost' identified by 'password';
and change
$this->db_host="Lima";
//database host
to
$this->db_host="localhost"; //database host
regards,
Arnd