MySQL DDL Operations
Jump to navigation
Jump to search
Internal
Server Version
SELECT VERSION();
Users
Display Users
SELECT USER FROM mysql.user;
Create User
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword';
Delete User
Database
Display Databases
SHOW DATABASES;