Vicidial error access denied for user custom@localhost

 

Vicidial access denied for user custom - Custom Fields

Topic : Vicidial error access denied for user custom@localhost

  Issue Overview:

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

  Root Cause:

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:

login to your mysql by typing mysql -p

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;

  Conclusion:

    hope this article is helpful, for professional support reach me at skype:manish.kadiya