Username:
TITLE
Migration fails, because root user doesn't have enough privileges on host server, due to new version.
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
Obisidian 18.0.34, Ubuntu 16.04.07LTS, mysql 5.7.33
PROBLEM DESCRIPTION
When I tried migration, it fails, and the reason is new update on mysql, that asks for full privileges even for a root user.
More info is in thread here, so not to repeat everything and that you have more info: Issue - Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)
I am able to do mysqldump manually, but I have to add these in command: --no-tablespaces --lock-tables=false
They changed something with privileges for mysql since v5.7, and it messes with root user rights to do mysqldump, which in turn prevents migration tool to do database migration.
STEPS TO REPRODUCE
Try to do migration from server that has mysql v5.7+
ACTUAL RESULT
Migration fails
EXPECTED RESULT
Migration is successful.
ANY ADDITIONAL INFORMATION
(DID NOT ANSWER QUESTION)
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM
Confirm bug
TITLE
Migration fails, because root user doesn't have enough privileges on host server, due to new version.
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
Obisidian 18.0.34, Ubuntu 16.04.07LTS, mysql 5.7.33
PROBLEM DESCRIPTION
When I tried migration, it fails, and the reason is new update on mysql, that asks for full privileges even for a root user.
More info is in thread here, so not to repeat everything and that you have more info: Issue - Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)
I am able to do mysqldump manually, but I have to add these in command: --no-tablespaces --lock-tables=false
They changed something with privileges for mysql since v5.7, and it messes with root user rights to do mysqldump, which in turn prevents migration tool to do database migration.
STEPS TO REPRODUCE
Try to do migration from server that has mysql v5.7+
ACTUAL RESULT
Migration fails
EXPECTED RESULT
Migration is successful.
ANY ADDITIONAL INFORMATION
(DID NOT ANSWER QUESTION)
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM
Confirm bug