# Installing INSIGHTS: Database Migrate Error

**URL:** https://discuss.openedx.org/t/installing-insights-database-migrate-error/2499
**Category:** Site Operations Help
**Created:** [June 20, 2020, 4:05am UTC](https://discuss.openedx.org/t/installing-insights-database-migrate-error/2499 "2020-06-20T04:05:00Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![jill](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/jill/32/3188_2.png) [@jill](https://discuss.openedx.org/u/jill)
#### Post date: [June 22, 2020, 12:36pm UTC](https://discuss.openedx.org/t/installing-insights-database-migrate-error/2499/2 "2020-06-22T12:36:35Z")

</div>

> [@Xperez](#):
>
> I´m getting this error while following the official guide for the [OpenEdx Insights Installation](https://openedx.atlassian.net/wiki/spaces/OpenOPS/pages/43385371/edX+Analytics+Installation)

That’s a pretty old guide, and doesn’t use python3, so you might run into many issues there. I don’t know if there’s an updated guide for production deployments, but you can get some clues from the analytics devstack: [Getting Started on Analytics](https://github.com/edx/devstack#getting-started-on-analytics)

Alternatively, you can consult [OpenCraft’s AWS analytics deployments](https://openedx-deployment.doc.opencraft.com/en/latest/analytics/AWS_setup/) doc, but we haven’t updated it for Juniper/python3 yet either.

> [@Xperez](#):
>
> The key seems to be in the sentence: “ **Access denied for user ‘migrate’@‘localhost’ (using password: YES)** ” I already created a new user **migrate** in my insights machine and checked if a user **migrate** exists in my Open Edx installation machine.

You’re correct, that’s the error that’s blocking that step.

So you’ve created the `migrate` user on your database… have you granted it permissions?

```auto
GRANT ALL PRIVILEGES ON `reports`.* TO 'migrate'@'%';
GRANT ALL PRIVILEGES ON `dashboard`.* TO 'migrate'@'%';
GRANT ALL PRIVILEGES ON `analytics-api`.* TO 'migrate'@'%';
FLUSH PRIVILEGES;

```

---

_[View the full topic](https://discuss.openedx.org/t/installing-insights-database-migrate-error/2499)._