MySQL - Create Database User with Password

visibility 118 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 0.23

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
EntityFramework Core - Connect to MySQL
visibility 134
thumb_up 0
access_time 2 years ago
Python: Load Data from MySQL
visibility 360
thumb_up 0
access_time 2 years ago
How to Start or Stop MySQL Service
visibility 151
thumb_up 0
access_time 2 years ago