MySQL DDL Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 26: Line 26:
==Delete User==
==Delete User==
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
DROP USER 'someuser'@'localhost';
</syntaxhighlight>
</syntaxhighlight>
=Database=
=Database=
==Display Databases==
==Display Databases==

Revision as of 03:58, 30 March 2021

Internal

Server Version

SELECT VERSION();

Users

Display Users

SELECT USER FROM mysql.user;

Create User

CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword';

Grant to User All Privileges on a Database

GRANT ALL PRIVILEGES ON some_database.* TO 'someuser'@'localhost';
FLUSH PRIVILEGES;

Show Privileges

SHOW GRANTS FOR 'someuser'@'localhost';

Delete User

DROP USER 'someuser'@'localhost';

Database

Display Databases

SHOW DATABASES;

Create Database

CREATE DATABASE some_database;

Delete Database

DROP DATABASE some_database;