- Change/Recover the MySQL admin password
- How To Set, Change, and Retrieve Your MySQL Root Password - Ever forgotten or just wanted to change your MySQL password? You’ve come to the right place – in this guide, we’ll walk you through how to set, change and recover your MySQL root password as well as other useful MySQL commands.
- MySQL: Setting, changing and recovering your root password - This article shows you how to set, change and recover secure passwords for your MySQL root account, so you'll never be at a loss.
- How to change forgotten Admin password - General Discussion - Froxlor Forum - How to change the password over the CLI/SSH.
- Useful tricks
- How to Show List of All Databases in MySQL [Explained] - Check our tutorial about how to show list of all databases in MySQL --> Different methods using Shell, Command line and GUI.
SHOW DATABASES
- How to Show List of All Databases in MySQL [Explained] - Check our tutorial about how to show list of all databases in MySQL --> Different methods using Shell, Command line and GUI.
- Errors
- How to fix no database selected MySQL error | sebhastian - Learn how to resolve no database selected MySQL error.
- Misc
- GitHub - ag-sanjjeev/mysql-notes - The basic and essential documentation notes collection to learn and practice MySQL database.
- The command line
- Multi-line
- When you enter on the command line, you can enter a single line and press enter, it will not be executed.
- You are then allowed you to enter another line for the statement.
- To execute it add `;` on the end and then press enter.
- Mastering MariaDB - the command-line client Chapter | <Packet>
- The code and output examples in this book use the mysql command-line client. Knowing some client commands can greatly increase productivity when this tool is used.
- The mysql command-line client knows that a SQL statement is terminated when it finds a semicolon (;), a \g, or a \G terminator.
- Multi-line