Exam 11: Learn how to create a database in MySQL 5.7 Community Server Edition

An important reason for using MySQL Community Server 5.7 is that it has full SQL capabilities.

Describe how to create a new database in MySQL 5.7 Community Server Edition.

A new MySQL Server database is known as a new ________.

Describe how to create and run an SQL query in MySQL 5.7 Community Server Edition.

MySQL Community Server 5.7 uses a user account called root for the name of the default MYSQL administrator account.

An important reason for using MySQL 5.7 Community Server Edition is that it ________.

SQL query results are displayed in a tabbed results window.

Describe how to create and run an SQL script in MySQL 5.7 Community Server Edition.

In order to use MySQL Workbench to create database designs,you must log into MySQL using ________.

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

MySQL 5.7 Server Community Edition uses ________ authentication.

Users log into MySQL Workbench using the Connect to MySQL Server dialog box.