What is the method for logging in to MySQL via the command line?
The method for logging in using the mysql command line is as follows:
- Open the terminal or command prompt window.
- Enter the following command:
mysql -u username -p
Among them, username is your MySQL username.
- After pressing the Enter key, the system will prompt you to enter a password. Enter the password and press Enter again.
- If the username and password are correct, you will successfully log in to the MySQL command-line interface, where you can execute various MySQL commands as needed.
Note: In the above command, the -u option is used to specify the username, while the -p option is used to prompt for a password. Make sure there are no spaces between -u and -p. If the -p option is omitted, it means no password login is required.