MySQL DDL Operations: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 7: | Line 7: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==Create User== | ==Create User== | ||
<syntaxhighlight lang='sql'> | |||
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword'; | |||
</syntaxhighlight> | |||
Revision as of 05:19, 7 December 2020
Internal
Users
Display Users
SELECT USER FROM mysql.user;
Create User
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword';