Grant MySQL Access to a Specific IP

April 19, 2024

Tools

# Check
SELECT host, user FROM mysql.user WHERE host = '192.168.1.5';

# Grant login
CREATE USER 'username'@'192.168.1.5' IDENTIFIED BY 'password';

# Grant database privileges
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'192.168.1.5';

# Flush
FLUSH PRIVILEGES;

Running Multiple WeChat Clients on Mac

Preface: Many people have multiple WeChat accounts. On mobile, you can use two phones or Android multi-app features. This article explains how to run multiple WeChat clients on Mac by creating aliases to the WeChat executable inside the app bundle.

Installing MySQL on Mac

Introduction: This article covers how to install MySQL on Mac. Steps include downloading the DMG installer from the official website, installing it, and configuring the environment variables.

AWS - Image Conversion with Lambda@Edge and CloudFront

Chinese cloud providers offer convenient image format and size conversion via URL parameters for their OSS/COS storage. AWS does not provide this out of the box — you need to write Lambda@Edge functions yourself. This article provides a complete guide on implementing image conversion with Lambda@Edge.

AWS-CodeArtifact

AWS CodeArtifact is a managed artifact repository that can host npm, Maven, and other packages.

AWS-CertificateManager

AWS Certificate Manager is the certificate management system provided by AWS. When used together with an AWS Load Balancer, you can request wildcard certificates for free.

Related Articles