mysql login code example

Example 1: mysql remote connection command line

mysql --host=localhost --user=myname --password mydb

Example 2: login mysql

mysql -u root -p

Example 3: mysql login console

mysql -u USERNAME -p

Example 4: mysql cli connect with password

mysql --user=root --password=mypass

Example 5: login to mysql database

mysql -u root -p databasename

Example 6: login to database mysql terminal

use DBNAME;