Vicidial access denied for user custom

Estimated read time: 1 min

Topic : access denied for user 'custom'@'localhost' (using password: yes)

Issue Overview:

In vicidial while creating custom fields , you may get the error "access denied for user 'custom'@'localhost' (using password: yes)"

Reason:

1.you might followed the scratch install, were the mysql custom user creation steps or missed out.

2. mysql user "custom" might deleted or password have been chaned.

Solution:

run the below command to create user custom with password custom1234 and necessary permissions.

CREATE USER 'custom'@'localhost' IDENTIFIED BY 'custom1234';

GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO custom@'%' IDENTIFIED BY 'custom1234';

GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO custom@localhost IDENTIFIED BY 'custom1234';

GRANT RELOAD ON *.* TO custom@'%';

GRANT RELOAD ON *.* TO custom@localhost;

flush privileges;