Thanks @Paul_Frydlewicz for your suggestion.
But it doesn’t really relevant to my problem because both my servers are in operation. I just want to move sites from one operational server to another operational server.
So the mariadb is working well on both servers. And both have sites in operation.
My guess is in the bench reading the sql file. But what is exactly and where to look into.
Also wondering is how the first site can be restored, while the second site can’t.
Clearly is a MySQL problem.
If your ip addresses for current and previous deployment are different… Have you whitelisted/ ip addresses for the mysql user account.
Try running simple MySQL query with the same user to diagnose.
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.
Database not installed, this can due to lack of permission, or that the database name exists.
Check your mysql root password, or use --force to reinstall