Posted 2 months ago. Visible to the public.

How to add a user with all privileges to MariaDB

Add a user with password

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

Add a user without password

Copy
mysql -uroot -p CREATE USER 'newuser'@'localhost' IDENTIFIED BY ''; 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.

makandra has been working exclusively with Ruby on Rails since 2007. Our laser focus on a single technology has made us a leader in this space.

Owner of this card:

Avatar
Emanuel De
Last edit:
2 months ago
by Arne Hartherz
About this deck:
We are makandra and do test-driven, agile Ruby on Rails software development.
License for source code
Posted by Emanuel De to makandra dev
This website uses cookies to improve usability and analyze traffic.
Accept or learn more