Posts

Table of Contents: Installing MySQL Configuring MySQL Creating Users and Granting Permissions Creating Databases Managing User Privileges Conclusion Section 1: Installing MySQL To install MySQL on a Linux distribution, you can use the package manager specific to your distribution. Here are the commands for popular Linux distributions: Ubuntu and Debian: CentOS and Fedora: Arch Linux: Section 2: Configuring MySQL Once MySQL is installed, you need to configure it. The configuration file may vary depending on the distribution. Here are the commonly used commands to modify the MySQL configuration file: ...

PostgreSQL: The World’s Most Advanced Open Source Relational Database PostgreSQL is arguably the most advance and powerful opensource enterprise class relational database system. It is the object relational database system and provides the most standard compliant system for the Database designers. It provides the complete support for reliable transactions that is (ACID complaint) where ACID stands for Atomicity, Consistency, Isolation and Durability. Its advance underlying technology makes it extremely powerful and programmable. Support for concurrency is one of its key feature. It is one of the most important technology you will learn and will greatly affect the way you work with Databases. It is the ultimate RDBM system which will allow you to create complex web apps which works flawlessly even for very large number of users. ...

Grub 2 typically gets overridden when you install Windows or another Operating System. To make Linux control the boot process, you need Reinstall (Repair/Restore) Grub using a Linux Live CD. ROOT_DISK='/dev/sda2' BOOT_DISK='/dev/sda1' # optional, only for EFI DISK='/dev/sda' mount $ROOT_DISK /mnt mount $BOOT_DISK /mnt/boot/efi # optional for i in /dev /dev/pts /proc /sys /sys/firmware/efi/efivars /run; do sudo mount -B $i /mnt$i; done chroot /mnt grub-install $DISK update-grub``` note: don't forget to update UUID in /mnt/etc/fstab using blkid

You can restrict access to your website or some parts of it by implementing a username/password authentication. Usernames and passwords are taken from a file created and populated by a password file creation tool, for example, apache2-utils. Creating a Password File Create additional user-password pairs. Omit the -c flag because the file already exists Nginx configuration location /public/ { auth_basic off; } } ...

You can restrict access to certain parts of your website using Nginx’s inbuilt authentication and authorization mechanism based either on your client’s I.P, by prompting for a login prompt or both. A sample I.P. based authorization configuration would be like: