Issue Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)

[Alan_SP]

Server operating system version

CentOS7

Plesk version and microupdate number

Obsidian 18.0.45

I'm trying to migrate my websites and I have run in problem with migrating tool from plesk. Databases doesn't get created, so I tried to do manual mysqldump od databases and I see similar error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
mysqldump: Got error: 1016: Can't open file: './xxxxx/cms_nodecategory.frm' (errno: 24 - Too many open files) when using LOCK TABLES

When I looked at it, it seems related with this update: How to fix the mysqldump process privilege error - Another Cup of Coffee

So, it does affect both migration tool and my manual process of trying to get this work.

Can anyone help me how can I give root user access to mysqldump command with full set of priviliges? I am rookie, so your help would be very much appreciated.

 

[Alan_SP]

Just to add more this actually affects migration, as mentioned, as migrating tool is logged as root, and thus migration can't pickup content of databases, so migration fails.

Source machine is Ubuntu 16.04.7 LTS, with Obisidian 18.0.34

How to get all priviliges to root user is key question, so migration tool can pack databases and transfer them to new system.

 

[Maarten.]

What version of MySQL or MariaDB are you using?

 

[Alan_SP]

When I tried to do manual mysqldump, adding --lock-tables=false, I received this message:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

 

[Alan_SP]

What version of MySQL or MariaDB are you using?

On old server from which I try to get database, it's mysql 5.7.33 (problem started with version 5.7)

Now, on new server I have MariaDB 5.5.68

It looks like I can't do it even with --lock-tables=false option in my mysqldump command.

 

[Maarten.]

Can you perform a dump when you add "--no-tablespaces"?

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

I am trying to backup mysql using the command mysqldump -u root -p database_name > backup.sql , but it is throwing an error: 'Access denied; you need (at least one of) the PROCESS privilege(s...

dba.stackexchange.com

 

[Alan_SP]

From what I see, not even manual backup and transfer won't work. I just need some way

Can you perform a dump when you add "--no-tablespaces"?

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

I am trying to backup mysql using the command mysqldump -u root -p database_name > backup.sql , but it is throwing an error: 'Access denied; you need (at least one of) the PROCESS privilege(s...

dba.stackexchange.com

I'm testing, looks like I have to add both these two:

--no-tablespaces --lock-tables=false

Is there any way to give root user full set of priviliges so I can use migration tool?

 

[Maarten.]

Could you check the privileges of the admin user in the database?

- Tools & Settings -> Database Servers
- Open PHPMyAdmin (icon on the right side)
- Click on "User accounts" and choose "admin"

What are the privileges of this user? Does it have PROCESS rights?

 

[Alan_SP]

Does it have PROCESS rights?

It has all privileges and I checked for Process specifically and it has it.

So, admin user can do everything, but root user, I'm using to log in to server via SSH, and which is used by Migration, it just fails to do mysqldump. So, how can I give privileges to root user, when I'm using SSH?

I guess that there must be more people with similar problem?

 

[Maarten.]

It looks like a bug. Can you please report this?

Reports

Please, click Post New Thread button and fill the form if you really believe you discovered a new bug and need to report it to the Plesk developers. It does allow us to handle and resolve your requests much more efficiently. Please be careful and do not submit any found problem with this...

talk.plesk.com

 

[Alan_SP]

OK, I reported it.