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
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:striker24x7
access denied for user 'custom'@'localhost' (using password: yes)
vicidial while creating custom fields.