What's new

Tutorial How to install Mariadb in Ubuntu 20.0x

raevillena

Honorary Poster
Joined
May 28, 2013
Posts
279
Reaction
480
Points
180
Age
28
1646266562743.png
1646266598734.png


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
Code:
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
Code:
mysql -u root -p
then key in the password
5) Once inside, Create a non root user for your apps
Code:
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.
Code:
mysql -u test -p
USE testdb;
7) Once testdb is in use. you are set. Done
 

Attachments

Back
Top