Extract all rows - access denied

Problem

A MySQL error occurs when the function "Extract all rows" is used.

Solution

Allow the MySQL user "xcall" to export data into a file in your mysql instance.

Open the SSH console to xCally server and connect to mysql console:

mysql -u root -p(root password)
GRANT FILE ON *.* TO 'xcall'@'localhost' identified by 'xcall1234';
GRANT FILE ON *.* TO 'xcall'@'%' identified by 'xcall1234';
FLUSH PRIVILEGES;

end restart the httpd service

service httpd restart