If you’ve seen errors such as either of these: SQLSTATE[HY000]: General error:1205: Lock wait timeout exceeded; try restarting transaction Or [ERROR] /usr/sbin/mysqld: Can't open file: './database/table.frm' (errno: 24) Error 24 basically means there are too many files

Creating a user login is something very commonly however all to often done poorly and not very securely. In this guide we’ll walk though some key points with example code explaining the reasoning on why each part