Arch Linux Pacman Essentials, Commands and Strategies for Power Users

Update Package Database: To update the package database to get the latest package information from the Arch Linux repositories, use the following command: sudo pacman -Sy Search for Packages: You can search for packages using pacman -Ss. For example, to search for the package name “example,” use: pacman -Ss example Install a Package: To install a package, use the -S flag followed by the package name. For example, to install the “example” package, use: sudo pacman -S example...

October 22, 2023 · 4 min · 699 words · Saman Wijesinghe

Easy MySQL Database Administration, Creating Users and Assigning Privileges

Connect to MySQL: You can connect to your MySQL server using the MySQL command-line tool or a database management tool like phpMyAdmin. To use the command-line tool, open your terminal and run: mysql -u root -p You’ll be prompted to enter the root user’s password. Create a MySQL Database: To create a new database, use the CREATE DATABASE statement. Replace <database_name> with the desired name of your database: CREATE DATABASE <database_name>;...

October 20, 2023 · 2 min · 301 words · Saman Wijesinghe

Arch Linux Wi-Fi Configuration Made Easy with iwctl

To connect to Wi-Fi from the Arch Linux ISO using iwctl, you can follow these step-by-step instructions: Boot into the Arch Linux ISO: Insert the Arch Linux ISO into a bootable USB drive or CD and boot your computer from it. You may need to change your boot order in the BIOS/UEFI settings to boot from the USB drive or CD. Initialize the Network Connection: Once you’ve booted into the Arch Linux ISO, wait for the system to load....

October 18, 2023 · 2 min · 344 words · Saman Wijesinghe

Managing Packages Like a Pro: APT Commands You Need

Update Package Lists To update the local package database with the latest available packages from the repositories, use the following command: sudo apt update Upgrade Installed Packages: To upgrade all installed packages to their latest versions, use the following command: sudo apt upgrade Install a Package: To install a package, use the apt install command followed by the package name: sudo apt install package-name Remove a Package: To uninstall a package while keeping its configuration files, use the apt remove command:...

October 17, 2023 · 3 min · 488 words · Saman Wijesinghe

MySQL command for import an SQL file into a MySQL database

Open a terminal window on your Linux system. Log in to MySQL using the following command. You will need to provide the MySQL root or a user with appropriate permissions and the password when prompted. mysql -u your_username -p Replace your_username with your MySQL username. Once you’re logged in, you can select the database where you want to import the SQL file. For example: USE your_database; Replace your_database with the name of the database you want to use....

October 15, 2023 · 1 min · 153 words · Saman Wijesinghe