Examveda

Which privileges are required on the source server to use mysqldbcopy?

A. CREATE

B. INSERT

C. UPDATE

D. SELECT

Answer: Option D

Solution (By Examveda Team)

This question is about mysqldbcopy, a tool in MySQL used to copy data between servers.
To use mysqldbcopy, you need the right permissions on the source server (where the data comes from).
Think of it like taking a photo of something. You need permission to look at the thing (the data) you want to copy.
So, the answer is Option D: SELECT.
The SELECT privilege allows you to read the data from the source server.
The other options (CREATE, INSERT, UPDATE) are about modifying data, which isn't needed for copying.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous