Mysql migration 5.7 to 8.0

Infrastructure
, ,
1

Hello Team. After migration from 5.7 to 8.0 I cant see health status
1

In database i had 2 users morpheus
| user | host |
±---------------------------±----------+
| morpheus | $% |
| morpheus | %

User morpheus $% was removed and on another user morpheus was provided grand privileges:
GRANT ALL PRIVILEGES ON morpheus.* TO ‘morpheus’@‘%’ WITH GRANT OPTION;
flush privileges;

also tried to use next command to repair DB

mysqlcheck --check-upgrade --all-databases --auto-repair -u user -p

but still have issue.

How to fix it?

2

You will need to add a grant similar to this to provide access to the stats.

GRANT SELECT, PROCESS, SHOW DATABASES, RELOAD ON *.* TO 'morpheus'@'%';
1 Like
3

If you are still having issues afterwards, I would recommend opening a support ticket at https://support.morpheusdata.com to further assist.

4

It works thanks.

1 Like