Access denied for user 'freescout'@'localhost'

[C0rn3j]

The install guide - https://github.com/freescout-helpdesk/freescout/wiki/Installation-Guide

has a step for creating the freescout mysql user.

GRANT ALL ON `freescout`.* TO `freescout`@`127.0.0.1` IDENTIFIED BY "XXX";

This gives access to freescout on 127.0.0.1 and NOT localhost at least on Ubuntu 18.04.

Issue can be verified by doing:

mysql -u freescout -p -h 127.0.0.1 # works
mysql -u freescout -p -h localhost # doesn't work

This is a problem for the php artisan migrate part.

root@freescout:/var/www/html# php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes


In Connection.php line 664:
                                                                                                                                                                                                         
  SQLSTATE[HY000] [1045] Access denied for user 'freescout'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = freescout and table_name = migrations)  
                                                                                                                                                                                                         

In Connector.php line 67:
                                                                                               
  SQLSTATE[HY000] [1045] Access denied for user 'freescout'@'localhost' (using password: YES)  
                                                                                               

[freescout-helpdesk]

Thanks for pointing this out. Try:

GRANT ALL PRIVILEGES ON `freescout`.* TO `freescout`@`localhost` IDENTIFIED BY "XXX";

[C0rn3j]

@freescout-helpdesk Yeah that works just fine, I guess I should have added that to the issue.