MySQL / MariaDB - Create Database User with Password
This code snippet shows you how to create a database user with password in MySQL or MariaDB.
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;
The following SQL statement grants all permission to user 'hive':
GRANT ALL ON *.* TO 'hive'@'localhost';