Please, I have been facing this error for the past 6 weeks, I would be grateful if I can get help here. I have searched and searched but couldn't find a solution. I am migrating from Magento 1.9.1.0 to Magento 2.3.1 and I keep getting this errors below. Thank you
[2019-06-15 16:03:37][ERROR]: Document sales_flat_order_grid can not be copied directly because of error: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'magento'@'localhost' for table 'sales_flat_order_grid', query was: INSERT INTO `sales_order_grid` SELECT sales_order.entity_id AS `entity_id`, sales_order.status AS `status`, sales_order.store_id AS `store_id`, sales_order.store_name AS `store_name`, sales_order.customer_id AS `customer_id`, sales_order.base_grand_total AS `base_grand_total`, sales_order.base_total_paid AS `base_total_paid`, sales_order.grand_total AS `grand_total`, sales_order.total_paid AS `total_paid`, sales_order.increment_id AS `increment_id`, sales_order.base_currency_code AS `base_currency_code`, sales_order.order_currency_code AS `order_currency_code`, trim(concat(ifnull(sales_shipping_address.firstname, ''), ' ' ,ifnull(sales_shipping_address.lastname, ''))) AS `**bleep**, ''))) AS `shipping_address`, sales_order.shipping_description AS `shipping_information`, sales_order.customer_email AS `customer_email`, sales_order.customer_group_id AS `customer_group`, sales_order.base_subtotal AS `subtotal`, sales_order.base_shipping_amount AS `shipping_and_handling`, trim(concat(ifnull(sales_order.customer_firstname, ''), ' ' ,ifnull(sales_order.customer_lastname, ''))) AS `customer_name`, (SELECT `sales_order_payment`.`method` FROM `sales_order_payment` as sales_order_payment WHERE (`parent_id` = sales_order.entity_id) LIMIT 1) AS `payment_method`, sales_order.total_refunded AS `total_refunded`, null AS `signifyd_guarantee_status` FROM `sales_order` LEFT JOIN `sales_order_address` AS `sales_shipping_address` ON sales_order.shipping_address_id = sales_shipping_address.entity_id LEFT JOIN `sales_order_address` AS `sales_billing_address` ON sales_order.billing_address_id = sales_billing_address.entity_id WHERE (sales_order.entity_id in (SELECT `sales_flat_order_grid`.`entity_id` FROM `karacomn_mage`.`sales_flat_order_grid`)) ON DUPLICATE KEY UPDATE `status` = VALUES(`status`), `store_id` = VALUES(`store_id`), `store_name` = VALUES(`store_name`), `customer_id` = VALUES(`customer_id`), `base_grand_total` = VALUES(`base_grand_total`), `base_total_paid` = VALUES(`base_total_paid`), `grand_total` = VALUES(`grand_total`), `total_paid` = VALUES(`total_paid`), `increment_id` = VALUES(`increment_id`), `base_currency_code` = VALUES(`base_currency_code`), `order_currency_code` = VALUES(`order_currency_code`), `shipping_name` = VALUES(`shipping_name`), `billing_name` = VALUES(`billing_name`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`), `billing_address` = VALUES(`billing_address`), `shipping_address` = VALUES(`shipping_address`), `shipping_information` = VALUES(`shipping_information`), `customer_email` = VALUES(`customer_email`), `customer_group` = VALUES(`customer_group`), `subtotal` = VALUES(`subtotal`), `shipping_and_handling` = VALUES(`shipping_and_handling`), `customer_name` = VALUES(`customer_name`), `payment_method` = VALUES(`payment_method`), `total_refunded` =100% [============================] Remaining Time: < 1 sec
