MySQL – Lock User Account Table of content Account Locking in MySQL is introduced to increase security of the database by preventing unauthorized transactions or suspicious activities. In many cases, the MySQL user accounts require to be locked for various reasons. For instance, to wait while completing the authorization of an account, or if the […]

MySQL – Change Password Table of content MySQL provides an account to each user which is authenticated with a username and a password. The default account in MySQL is a root with no password (One can however set a password to the root using a statement). Similarly, other user-defined accounts can have passwords set explicitly […]

MySQL – Show Users Table of content As you might have already known, MySQL is a multi-user database that allows multiple users to work on it simultaneously. But have you ever wondered who these users might be? MySQL provides an account to each user that is authenticated with a username and a password. And details […]