MySQL – Create, Delete Database and Show Grants (Create Database, Drop Database, Show Grants)

Creating and Deleting databases on a MySQL server is very easy. Sometimes it can be too easy.

  • show databases; – Shows databases
  • create database databasename; – Creates a database
  • drop database databsename; – Deletes a database
  • show grants; – Shows Privileges of current users
  • show grants for username; Shows Privileges of named user

Be the first to comment

Leave a Reply