Mysql Command Line Client: Difference between revisions
Jump to navigation
Jump to search
| Line 44: | Line 44: | ||
<syntaxhighlight lang='bash'> | <syntaxhighlight lang='bash'> | ||
mysql -u root -p<password> -e "SELECT VERSION()" | mysql -u root -p<password> -e "SELECT VERSION()" | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 06:03, 30 March 2021
Internal
Options
-e, --execute=name
Execute command and quit.
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();
...
Alternatively:
mysql -u root -p<password> -e "SELECT VERSION()"