试题详情

MySQL is installed on a Linux server and has this configuration: [mysqld] user=mysql datadir=/data/mysql/ As the ‘root’ user, you change the datadir location by executing: shell> cp –R /var/lib/mysql /data/mysql/ shell> chown –R mysql /data/mysql What is the purpose of changing ownership of datadir to the ‘mysql’ user?

A MySQL needs to be run as the root user, but files cannot be owned by it.

B The mysqld process requires all permissions within datadir to be the same.

C MySQL cannot be run as the root user.

D MySQL requires correct file ownership while remaining secure. 31 / 118