Mysql Command Line Client: Difference between revisions
Jump to navigation
Jump to search
| Line 26: | Line 26: | ||
<syntaxhighlight lang='bash'> | <syntaxhighlight lang='bash'> | ||
mysql -u root -p<password> < statements.sql | mysql -u root -p<password> < statements.sql | ||
</syntaxhighlight> | |||
where statements.sql should contain SQL: | |||
<syntaxhighlight lang='sql'> | |||
SELECT VERSION(); | |||
... | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 02:34, 30 March 2021
Internal
Connect
mysql -u root -p
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();
...