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
Смотрите видео How to Install MariaDB and phpMyadmin on Ubuntu 20.04 Server онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MD TECH Tutorials 16 Август 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,028 раз и оно понравилось 62 людям.