Mail Server on Ubuntu with Postfix Dovecot MariaDB – Part 2 – Create Database for Mail Server

Mail Server on Ubuntu with Postfix Dovecot MariaDB – Part 2 – Create Database for Mail Server

📌 Try Vultr, Get $100 Credit free : https://www.vultr.com/?ref=8372740-6G

📌 Other tutorials :

👉 How to Install and Configure LAMP ( Apache MySQL/MariaDB PHP ) on Ubuntu : https://youtu.be/i8ZRdxUrRT0

👉 How to Install and Configure phpMyAdmin on Ubuntu : https://youtu.be/x-o2IsTenOE

👉 How to Change Hostname and FQDN on Ubuntu : https://youtu.be/7OGTAKqaB_s

📌 Code in this video : https://drive.google.com/file/d/1a0pLGZhLyV4fC4Ihb6sBQkd9pvEzdT1U/view?usp=sharing

📌 In this series : Mail Server on Ubuntu with Postfix Dovecot MariaDB/MySQL

👉 Part 1 : Create Essential Records for Mail Server : https://youtu.be/7HJVPDz9MSk

👉 Part 2 : Create Database for Mail Server : https://youtu.be/she_y5YPVss

👉 Part 3 : Install and Configure Postfix : updating

👉 Part 4 : Install and Configre Dovecot : updating

👉 Part 5 : Install and Configure SSL/TLS secure for Mail Server : updating

👉 Part 6 : Install and Configure RoundCube WebMail : updating

👉 Part 7 : Install and Configure OpenDKIM for Mail Server : updating

👉 Part 8 : Install and Integrate SpamAssassin in Postfix : updating

👉 Part 9 : Install and Integrate Amavisd in Postfix : updating

👉 Part 10 : Monitoring Mail Server with MailGraph : updating

👉 Part 11 : How to Block Attach File in Postfix : updating

📌Database in this series :

✅ In the table virtual_Status :
✔ status_ID = 0 : Disable
✔ status_ID = 1 : Enable
✔ status_ID = 2 : Others

✅ In the table virtual_Domain, insert 1 domain : hvthang.xyz ( Replace = Your-Domain )

✅ In the table virtual_Users, insert 2 Email : test1@hvthang.xyz with password is “test1” and test2@hvthang.xyz with password is “test2”.
✅ In the table virtual_Aliases, insert 1 aliases (group) group-test@hvthang.xyz include 2 email test1 and test2.

source

ubuntu