How to Install MariaDB and phpMyadmin on Ubuntu 20.04 Server
In this video, I will going to show you how to install MariaDB and phpMyadmin in ubunto 20.04
----- Contents of this video --------------------------------
00:10 - Connecting to Ubunto server using putty.
00:33 - Install the MariaDB server.
02:28 - Create database.
04:06 - Install phpmyadmin.
06:27 - Outro.
----- Commands to install MariaDB and phpMyadmin in Ubunto 20.04 Server -----
Step 1: Install the MariaDB server (v10.3) from the Ubuntu repository.
sudo apt update
sudo apt install -y mariadb-server mariadb-client
- Securing mariaDB with mysql_secure_installation command
systemctl start mariadb
mysql_secure_installation
Step 2: Create Database
- Log in to the MariaDB server using the root user to create a database.
sudo mysql -u root -p
- Create a database called test_db.
create database test_db;
- Create a database user test_user and password test_password.
create user test_user@localhost identified by 'test_pass';
- Grant this user all privileges on the nextcloud database.
grant all privileges on test_db.* to test_user@localhost identified by 'test_pass';
- Flush privileges and exit.
flush privileges;
exit;
Step 3: Install phpMyAdmin.
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
- Enable the mbstring PHP extension.
sudo phpenmod mbstring
- Restart Apache for your changes to be recognized.
sudo systemctl restart apache2
- End -
Please watch our more upcoming videos and don't forget to LIKE, COMMENT, AND SUBSCRIBE.
Thank you all.💕
MD
System Administrator
Watch video How to Install MariaDB and phpMyadmin on Ubuntu 20.04 Server online without registration, duration hours minute second in high quality. This video was added by user MD TECH Tutorials 16 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,02 once and liked it 6 people.