Creating a user in MariaDB: Difference between revisions
From Leechfinger
Jump to navigationJump to search
Leechfinger (talk | contribs) Created page with " Category:MariaDB" |
No edit summary |
||
| Line 1: | Line 1: | ||
== Create new super user with all rights == | |||
<syntaxhighlight lang="bash" line> | |||
CREATE USER 'user1'@localhost IDENTIFIED BY 'password1'; | |||
GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1'; | |||
FLUSH PRIVILEGES; | |||
SHOW GRANTS FOR 'user1'@localhost; | |||
</syntaxhighlight> | |||
== Drop the user == | |||
<syntaxhighlight lang="bash" line> | |||
DROP USER 'user1'@localhost; | |||
</syntaxhighlight> | |||
[[Category:MariaDB]] | [[Category:MariaDB]] | ||
Latest revision as of 18:25, 24 May 2024
Create new super user with all rights
CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'user1'@localhost;
Drop the user
DROP USER 'user1'@localhost;
