Hi,
Ticknor.Scott@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