thesuhu

#!/bin/sh

IP=$(echo $1 | egrep -o "^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$")

if [ ! $IP ]
then
    echo "Usage: generate-ip-cert.sh 127.0.0.1"
    exit 1
fi

thesuhu

How to Install MySQL on Ubuntu

This tutorial has been tested on Ubuntu 20.04 LTS.

Install latest version

Before install, don't forget to update package index in your server.

sudo apt update

thesuhu

# Make sure MySQL is not running
sudo systemctl stop mysql

# Then purge all of the MySQL packages
sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*

# Then delete all of the MySQL files 
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql

# Finally clean all packages that are not needed:

thesuhu

// You can simply use response.data.pipe and fs.createWriteStream to pipe response to file
const axios = require('axios')

// Example 1:
axios({
    method: "get",
    url: "https://xxx/my.pdf",
    responseType: "stream"
}).then(function (response) {
    response.data.pipe(fs.createWriteStream("/temp/my.pdf"))

thesuhu

How to Solve "ng build" Error TS7015: Element implicitly has an ‘any’ type because index expression is not of type 'number'

Today I got error message when running "ng build" on my project using Angular version 12.0.1. The error message is Error TS7015: Element implicitly has an ‘any’ type because index expression is not of type ‘number’.

To solve this problem, edit the file tsconfig.json (TypeScript compiler configuration) and add the following configuration to the compilerOptions key:

"compilerOptions": {

 "suppressImplicitAnyIndexErrors": true,

thesuhu

#! /bin/bash

# Tested on CentOS 7 and CentOS 8
# Check the latest version at https://curl.se/download/
VERSION=7.80.0

cd ~
sudo yum update -y
sudo yum install wget gcc openssl-devel make -y
wget https://curl.haxx.se/download/curl-${VERSION}.tar.gz

thesuhu

How to Build and Install Latest cURL Version on CentOS

# Written by The Suhu (2021).

# Tested on CentOS 7 and CentOS 8

Previously I've written about How to Build and Install Latest cURL Version on Ubuntu. In this article in this article explain how to build and install latest cURL version on CentOS.

thesuhu

#! /bin/bash

# Already tested on Ubuntu 20.04
# Check the latest version at https://curl.se/download/
VERSION=7.80.0

cd ~
sudo apt-get update -y
sudo apt-get install -y nghttp2 libnghttp2-dev libssl-dev build-essential wget
wget https://curl.haxx.se/download/curl-${VERSION}.tar.gz

thesuhu

How to Build and Install Latest cURL Version on Ubuntu

# Written by The Suhu (2021).

# Tested on Ubuntu 20.04 LTS

The default cURL installed on the operating system may not be the latest version. if you want the latest version, then you need to build from the source. Let's check the cURL version installed with the following command.

thesuhu

DELIMITER $$

CREATE FUNCTION extract_digits (string_mixed VARCHAR(100)) RETURNS VARCHAR(100) NO SQL
BEGIN
    DECLARE find_digit_position VARCHAR(100);
    DECLARE string_digits VARCHAR(100) DEFAULT '';
    DECLARE search_char VARCHAR(1);
    DECLARE i INTEGER DEFAULT 1;

    IF LENGTH(string_mixed) > 0 THEN