Operating system: Ubuntu
*OS version: 20.04.2 LTS
I’m trying to migrate VM from server running with Ubuntu 16.04.7 LTS (MySQL ver: 5.7.33-0ubuntu0.16.04.1) to new server (Ubuntu 20.04.2 LTS - MySQL ver: 8.0.25-0ubuntu0.20.04.1) but got an error:
Error: SQL grant all on `wp\_olddb`.* to 'newdb'@'localhost' with grant option failed : You are not allowed to create a user with GRANT
I searched for many topics but cannot find the right solutions. Please help me!