Read more

How to add a user with all privileges to MariaDB

Emanuel
May 07, 2018Software engineer at makandra GmbH

Replace newuser with your desired username:

mysql -uroot -p
CREATE USER 'newuser'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
exit;

Remove password from an existing user

Illustration web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
Read more Show archive.org snapshot

If you already have a user with sufficient privileges but protected by a password, you can remove the password.
Replace existinguser with your desired username:

mysql -uroot -p
SET PASSWORD FOR existinguser@localhost='';
FLUSH PRIVILEGES;
exit;

Add a user with unix socket authentication

The mysql client will use the underlying operating system credentials of your user account. You don't have to enter a password.

Replace newuser with the username of your account:

whoami
newuser

mysql -uroot -p
DROP USER IF EXISTS 'newuser'@'localhost';
CREATE USER 'newuser'@'localhost' IDENTIFIED VIA unix_socket;
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
exit;

Add a user with password

Replace newuser with your desired username:

mysql -uroot -p
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'changeme';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
exit;

If you don't have a user with the sufficient access rights, follow these steps to reset the password.

Posted by Emanuel to makandra dev (2018-05-07 12:12)