Tag

passwordless

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 8, 2019 · Databases

Using MySQL auth_socket Plugin for Password‑less Authentication

This article explains how the auth_socket (MySQL) and unix_socket (MariaDB) plugins enable password‑less login by mapping operating‑system users to MySQL accounts, walks through installing and enabling the plugins on Debian, Ubuntu, MariaDB, and Percona Server, and demonstrates creating and using socket‑authenticated users.

MySQLPerconaUnix socket authentication
0 likes · 8 min read
Using MySQL auth_socket Plugin for Password‑less Authentication
Hujiang Technology
Hujiang Technology
Aug 30, 2017 · Information Security

Design Principles and Security Considerations for User Account Systems

This article shares practical insights on building robust user account systems, covering the shift from usernames to phone numbers as unique identifiers, the drawbacks of passwords, the limited value of periodic password changes, the pitfalls of security questions, and best practices for token management, SMS/voice verification, captcha usage, and multi‑layered future security strategies.

AuthenticationSMS verificationToken Management
0 likes · 14 min read
Design Principles and Security Considerations for User Account Systems