MySQL – Show Privileges Table of content The users in MySQL must have enough privileges to interact with the server. This is possible by assigning authentication details, like passwords to the users. In addition to this, operational or administrative privileges are granted separately if a user wants to interact with and operate on the data. […]
Author Archives: user
MySQL – Grant Privileges Table of content As we learnt earlier, a root user is connected to the server (using a password) immediately after installing MySQL. The privileges available to this user are default. The user accessing MySQL using root account has enough privileges to perform basic operations on the data. However, in exceptional cases, […]
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 […]