Learn – MySQL Account UnlockUnlock is a mechanism that allows the user to release all locks or any specific lock associated with the account. In this article, we will learn how to unlock the user accounts in the MySQL server.When the CREATE USER… UNLOCK statement creates a n
Learn – MySQL Show UsersSometimes you want to manage a database in MySQL. In that case, we need to see the list of all user’s accounts in a database. Most times, we assume that there is a SHOW USERS command similar to SHOW DATABASES, SHOW TABLES, etc. for displaying the list of all users available in the database server. Unfortunately, MySQL database does not have a SHOW USERS command to display the list of all users in the MySQL server. We can use the following query to see the list of all user in the database server:mysql> Select user from mysql.user;
Learn – Change User PasswordMySQL user is a record that contains the login information, account privileges, and the host information for MySQL account to access and manage the database. The login information includes the user name and password. In some cases, there is a need to change the user password in the MySQL database.To change the password of any user account, you mu
Learn – MySQL Account LockA lock is a mechanism used to prevent unauthorized modifications into our database. It is essential to the security of our database. In this article, we are going to learn how to use the CREATE USER… ACCOUNT LOCK and ALTER TABLE… ACCOUNT LOCK statements for locking the user accounts in the MySQL server.We can lock the user accounts by using the CREATE
Learn – Install MySQLMySQL is one of the most popular relational database management software that is widely used in today’s industry. It provides multi-user access support with various storage engines. It is backed by Oracle Company. In this section, we are going to learn how we can download and install MySQL for beginners.Prerequisites