Forwarded to devs Migration fails, because root user doesn't have enough privileges on host server, due to new version.

[Alan_SP]

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

 

[IgorG]

Thank you for the report.
Developers can't reproduce the issue when performing a migration from:

Product version: Plesk Obsidian 18.0.37.2
OS version: Debian 10.12 x86_64
Build date: 2021/08/09 18:00
Revision: 1dff6684b76d24eb5432e13e6870e5795482e0a1
a10-52-58-107:~# mysql -V
mysql Ver 14.14 Distrib 5.7.38, for Linux (x86_64) using EditLine wrapper

to

Product version: Plesk Obsidian 18.0.45.0
OS version: AlmaLinux 8.6 x86_64
Build date: 2022/07/01 06:00
Revision: 6c6d4dba4acba278e1a7338e636fdfe720e05094
[root@a10-52-56-53 ~]# mysql -V
mysql Ver 15.1 Distrib 10.3.32-MariaDB, for Linux (x86_64) using readline 5.1

There are no issues/warnings/errors related to the database.
So, we need more details for reproducing.