Mysql Command Line Client

From NovaOrdis Knowledge Base
Revision as of 03:55, 30 March 2021 by Ovidiu (talk | contribs) (→‎Connect)
Jump to navigation Jump to search

Internal

Connect

mysql -u root -p

Will challenge for password.

mysql -u root -p<password>

No space after -p.

The username and password can also be stored in ~/.my.cnf:

[client]
user = root
password = XXXXXXXX

Scripting Database Interaction

mysql -u root -p<password> < statements.sql

where statements.sql should contain SQL:

SELECT VERSION();
...