A.Use PURGE BINARY LOGS to <binlog_name>.

B.Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.

C.Use SET PERSIST binlog_expire_logs_seconds=<value>.

D.Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.

E.Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.

F.Set binlog_expire_logs_seconds in my.cnf.

A.named pipes

B.SOCKET

C.shared memory

D.TCP/IP

E.UDP

F.X Protocol

A.mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql

B.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

C.mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql

D.mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql

A.You can find the root password in the error log after the first start.

B.You must manually initialize the data directory.

C.You can provide the root password interactively.

D.The functionality is split among several RPM package files.

E.The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

F.MySQL uses the RPM relocatable installation target feature.

A.installing and configuring the Connection Control plugin

B.avoiding concatenation of SQL statements and user-supplied values in an application

C.using stored procedures for any database access

D.using PREPARED STATEMENTS