MySQL Backup: Backing Up Using mysqldump Tool Summary: in this tutorial, you will learn how to use the mysqldump tool to make a backup one or more databases in a MySQL Server. Introduction to mysqldump tool The mysqldump tool allows you to make a backup of one or more databases by generating a text file…
Read more
MySQL SHOW PROCESSLIST Summary: in this tutorial, you will learn how to use the SHOW PROCESSLIST command to find the currently running threads. Sometimes, you may get the “too many connections” error returned by the MySQL Server. To find out the reasons, you can use the SHOW PROCESSLIST command. The SHOW PROCESSLIST command returns all…
Read more
MySQL SHOW COLUMNS and DESCRIBE: List All Columns in a Table Summary: in this tutorial, you will learn how to show columns of a table by using the DESCRIBE statement and MySQL SHOW COLUMNS command. Using DESCRIBE statement To show all columns of a table, you use the following steps: Login to the MySQL database…
Read more
MySQL SHOW TABLES: List Tables In a MySQL Database Summary: in this tutorial, you will learn how to use the MySQL SHOW TABLES command to query tables in a particular database. To list tables in a MySQL database, you follow these steps: Login to the MySQL database server using a MySQL client such as mysql…
Read more
MySQL SHOW DATABASES: List All Databases in MySQL Summary: in this tutorial, you will learn how to use the MySQL SHOW DATABASES command to list all databases in a MySQL database server. Using the MySQL SHOW DATABASES To list all databases on a MySQL server host, you use the SHOW DATABASES command as follows: SHOW…
Read more
How To Unlock User Accounts in MySQL Server Summary: in this tutorial, you will learn how to use the ALTER TABLE UNLOCK ACCOUNT to unlock user accounts in MySQL server. When you create a new user using the CREATE USER statement with the ACCOUNT LOCK clause, the new user has a locked state. Similarly, if…
Read more
How To Lock User Accounts in MySQL Summary: in this tutorial, you will learn how to use the CREATE USER .. ACCOUNT LOCK and ALTER TABLE .. ACCOUNT LOCK statements to lock user accounts in MySQL server. To lock a user account, you can use the CREATE USER .. ACCOUNT LOCK statement: CREATE USER account_name…
Read more
MySQL RENAME USER Summary: in this tutorial, you will learn how to use the MySQL RENAME USER statement to rename existing user accounts. Introduction to MySQL RENAME USER statement The RENAME USER statement renames one or more existing accounts. Here is the basic syntax of the RENAME USER statement: RENAME USER old_user1 TO new_user; Code…
Read more
MySQL SHOW USERS: List All Users in a MySQL Database Server Summary: this tutorial shows you how to list users in a MySQL database. MySQL show users: list all users Are you looking for the MySQL SHOW USERS command? Unfortunately, MySQL does not have the SHOW USERS command like SHOW DATABASES, SHOW TABLES, etc., therefore to…
Read more
3 Best Ways to Change MySQL User Password By Examples Summary: in this tutorial, you will learn how to change MySQL user password using various statements such as UPDATE, SET PASSWORD,and ALTER USER statements. Before changing the password of a MySQL user account, you should consider the following important questions: Which user account do you want to change the…
Read more