access_time 4 months ago languageEnglish
more_vert

MySQL - Create Database User with Password

visibility 32 comment 0

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';
copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 35
thumb_up 0
access_time 4 months ago
visibility 133
thumb_up 0
access_time 3 months ago