Hi, one of my severs (in a multiserver setup ) is getting this error once the cron runs; PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'ispcsrv195'@'XX.XX.XX.XX' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62 DB::__construct Access denied for user 'ispcsrv195'@'XX.XX.XX.XX' (using password: YES) I will give the permission in the master database , but I wouldnt like to do a GRANT ALL statement , which permission should i gave it to the user to have a normal operation ?? Hope be clear! Thanks!
There is no need to change any permissions of the user. The eror meas that either IP or hostname of the user ispcsrv195 is wrong in the master database or that the password is wrong.
Thanks Till, and which statement should I use to change the user password and allow the user to connect the db properly ?
