MySQL / MariaDB - Create Database User with Password
insights Stats
warning Please login first to view stats information.
articleArticles 578
imageDiagrams 58
commentComments 303
loyaltyKontext Points 6373
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
This code snippet shows you how to create a database user with password in MySQL or MariaDB.
Code snippet
The following code snippet creates a user named 'hive' with password ('hive') that never expires.
CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive' password expire never;
Grant permissions
The following SQL statement grants all permission to user 'hive':
GRANT ALL ON *.* TO 'hive'@'localhost';
info Last modified by Raymond 3 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.