Creating a user in MariaDB: Difference between revisions

From Leechfinger
Jump to navigationJump to search
VisualWikitext
Created page with " Category:MariaDB"
 
Qais (talk | contribs)
615 edits
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;
Retrieved from "https://leechfinger.com/index.php?title=Creating_a_user_in_MariaDB&oldid=259"