Creating a new user in MariaDB

Posted on | In
In this post we will learn how to create a new user in MariaDB

Hi there.

This week I got a problem with MariaDB.
I don’t know the reason, but, MariaDB’s default credentials stopped work.
After some tests, I only fix that creating a new user in MariaDB.

The process is a piece of cake, look at below:

After log in in MariaDB with root:

1
CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'newUserPassword';

1
GRANT ALL PRIVILEGES ON *.* TO 'newUser'@'localhost' WITH GRANT OPTION;

eof.