MySQL DDL Operations: Difference between revisions
Jump to navigation
Jump to search
(→Users) |
|||
| Line 20: | Line 20: | ||
==Display Databases== | ==Display Databases== | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
SHOW DATABASES; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
==Create Database== | ==Create Database== | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
Revision as of 03:55, 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';
Delete User
Database
Display Databases
SHOW DATABASES;