Posts

Digital Marketing

how to install mycli on Amazon Linux 2023

sudo dnf install pip sudo pip install mycli

Install MySQL on Amazon Linux 2023

Update the packages of your Amazon Linux 2023 by running the following command in your terminal: $ sudo dnf update. Download the MySQL Yum repository from the Oracle website using the following command: $ sudo wget https://dev.mysql.com/get/mysql80-community-release-el9-5.noarch.rpm. Install the MySQL community server and client on your system by running the following command: $ sudo dnf install mysql-community-server. Start the MySQL service and enable it to activate automatically with the system boot or crash by running the following command: $ sudo systemctl start mysqld and $ sudo systemctl enable mysqld. Secure your MySQL installation by setting a root password, removing anonymous users, disabling remote root login, and more. You can find the default password set by MySQL for the root user by running the following command: $ sudo grep 'temporary password' /var/log/mysqld.log. After that, run the following command and follow the prompts: $ sudo mysql_secure_installation. ...

Monotonic timers relative to different starting points

Settings and their starting points Setting Meaning OnActiveSec= Defines a timer relative to the moment the timer unit itself is activated. OnBootSec= Defines a timer relative to when the machine was booted up. In containers, for the system manager instance, this is mapped to  OnStartupSec= , making both equivalent. OnStartupSec= Defines a timer relative to when the service manager was first started. For system timer units this is very similar to  OnBootSec=  as the system service manager is generally started very early at boot. It's primarily useful when configured in units running in the per-user service manager, as the user service manager is generally started on first login only, not already during boot. OnUnitActiveSec= Defines a timer relative to when the unit the timer unit is activating was last activated. OnUnitInactiveSec= Defines a timer relative to when the unit the timer unit is activating was last deactivated.

Let ssh client to always add the key to a running ssh-agent

Add the following configuration setting to your local ssh config file ~/.ssh/config (this works since SSH 7.2): AddKeysToAgent  yes There's no need to ssh-add it beforehand.

UDP and TCP syslog reception provided by rsyslog

Inside /etc/rsyslog.conf # Provides UDP syslog reception #$ModLoad imudp #$UDPServerRun 514 # Provides TCP syslog reception $ModLoad imtcp $InputTCPServerRun 514

Common pattern to visually hide text for only screen readers to read

<script src="https://gist.github.com/goyuninfo/a3a4e912765d1b6afffd7ceba972d693.js"></script>

Use a
element to mark up a photo in a document, and a
element to define a caption for the photo