How it is better to organize DB?

Question

linux

In general, the question is that I switched to Linux (Ubuntu)
On Windows, when working with the database, I used openserverom, I would like specific advice on how to organize on linux (preferably mysql)

Answer 1

sudo apt install mysql-server
or
sudo apt install mariadb-server
choose
after installing one thing
sudo mysql_secure_installation
there will be a dialog, a la setting a password for the root user of the database, deleting a test user, etc.

Answer 2

Better put Maria. On Linux it is very convenient to work in phpmyadmin. But you have to set it up manually.

Answer 3

Installing LAMP with Maria, with basic, basic settings, with one command in the Terminal in Ubuntu 20.04 from of rep:

LAMP

cd /etc/apt/sources.list.d; echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu $(lsb_release -cs) main" | sudo tee php.list > /dev/null; sudo apt-key adv --recv-keys --keyserver hkps://keyserver.ubuntu.com:443 4F4EA0AAE5267A6C; cd; sleep 10; sudo apt update; sudo apt full-upgrade; sudo apt install apache2 mariadb-server-10.3 php libapache2-mod-php php-mysql php-cgi php-gd php-zip php-xml php-xmlrpc php php-curl php-json php-mbstring php-cli; sudo ufw allow in 80/tcp; sudo a2enmod rewrite; sudo sed -i "s/AllowOverride None/AllowOverride All/" /etc/apache2/apache2.conf; sudo systemctl restart apache2