Q174
Which privileges are required on the source server to use mysqldbcopy?
A.
CREATE
B.
INSERT
C.
UPDATE
D.
SELECT
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
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.