🔒 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.

#install mariadb 10.5 on ubuntu 20.0x

sudo apt -y install software-properties-common dirmngr
sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
sudo add-apt-repository 'deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.5/ubuntu focal main'
sudo apt update
sudo apt -y install mariadb-server mariadb-client

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!