mysql Command Reference - MySQL

Syntax

mysql [options] [database]

Parameters	Description	Examples	Level
`-u` `--user`		`mysql -u root`	Common
`-p` `--password`	()	`mysql -u root -p`	Common
`-h` `--host`		`mysql -h 192.168.1.100 -u root -p`	Common
`-P` `--port`	( 3306)	`mysql -h 127.0.0.1 -P 3307 -u root -p`	Common
`-S` `--socket`	socket	`mysql -S /tmp/mysql.sock -u root -p`	Advanced
`-e` `--execute`	SQL	`mysql -u root -p -e "SHOW DATABASES;"`	Common

mysql -u root -p

,

mysql -h 192.168.1.100 -P 3306 -u app_user -p ecommerce_db

ecommerce_db

mysql -u root -p -e "SELECT COUNT(*) FROM users;" ecommerce_db

mysql -S /var/run/mysqld/mysqld.sock -u root -p

TCP socket

ERROR 1045 (28000): Access denied for user 'root'@'localhost'., sudo mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socketMySQL. systemctl start mysql service mysql start