You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: \> mysqld install Mysql56 defaults file = C : \my opts.cnfWhat is the expected outcome?
Consider the events_% tables in performance Schema.Which two methods will clear or reset the collected events in the tables?
What are four capabilities of the mysql client program?
Assume that you want to know which Mysql Server options were set to custom values.Which two methods would you use to find out?
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:$ pidof mysqld3132$tail - n2 /var/lib.mysql/hostname.err2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.Version: 5.6.13-enterprise-commercial-advaced socket: /tmp/mysql.sock port;3306 Mysql Enterprise Server Advanced Edition (Commercial)You attempt to log in as the root user with the following command:$mysql u rootERROR 1045 (28000): Access denied for user root@localhost (using password: NO)Which statement is true about this scenario?
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') 'Skip_Counter: 0 -Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8Auto _Position: 1 -You execute a "SHOW CREATE TABLE mytable" on the slave:CREATE TABLE mytable (ID int(11) NOT NULL DEFAULT 0,name char(10) DEFAULT NULL,PRIMARY KEY (ID))The table mytable on the slave contains the following:You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.Which statement should be used?
