Difficulty: 2/10CREATE DATABASE, SHOW DATABASES, MySQL permissionsThe CREATE DATABASE statement is a DDL (Data Definition Language) statement used to create a new database in MySQL RDBMS.Statement to create database:CopyStatement to list databases:CopyScenario Questions0-2 years experience1We need a fresh database for a prototype service. Walk me through the exact MySQL commands you’d run to create it and then verify it exists.2If you try to create a database that already exists, what does MySQL return and how would you handle that in a script?2-5 years experience1You’re writing a deployment script that creates a new schema for each microservice. How would you structure the script to create the database, handle possible permission errors, and list all databases to confirm the new one appears?Follow-up QuestionsWhat would you see if you ran SHOW DATABASES without any privileges?How do you verify that a newly created database uses the expected character set?Can you explain how MySQL stores the list of databases internally?Suggest Improvement
