🔒 Closed How to install Mariadb in Ubuntu 20.0x

[raevillena]

I sharing some snippets how to install MariaDB 10.5 in ubuntu 20.0x

1) open up a terminal inside ubuntu. or if you are in CLI already skip this step.
2) paste the code snippet below to install the Database engine.

You do not have permission to view the full content of this post. Log in or register now.

3) Setup the root user using

mysql_secure_installation

in the terminal. this is also the same code you can use whenever you forget the root password.
4) Login to engine using root user

mysql -u root -p

then key in the password
5) Once inside, Create a non root user for your apps

CREATE DATABASE testdb;
CREATE USER 'test'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON testdb.* TO test@localhost;
FLUSH PRIVILEGES;
quit

6) Login and use the database create to test the database engine.

mysql -u test -p
USE testdb;

7) Once testdb is in use. you are set. Done

 

[PHC- Princeyeki]

thanks for sharing

 

[raevillena]

you're welcome!