Mysql GRANT question

Discussion in 'General' started by gral, Sep 2, 2014.

  1. gral

    gral Member

    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/ 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!

    Last edited: Sep 2, 2014
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  3. gral

    gral Member

    Thanks Till, and which statement should I use to change the user password and allow the user to connect the db properly ?

Share This Page