MySQL DDL Operations: Difference between revisions
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
GRANT ALL PRIVILEGES ON some_database.* TO 'someuser'@'localhost'; | GRANT ALL PRIVILEGES ON some_database.* TO 'someuser'@'localhost'; | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
</syntaxhighlight> | |||
==Show Privileges== | |||
<syntaxhighlight lang='sql'> | |||
SHOW GRANTS FOR 'someuser'@'localhost'; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 03:57, 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
Database
Display Databases
SHOW DATABASES;
Create Database
CREATE DATABASE some_database;