Mysql Command Line Client: Difference between revisions
Jump to navigation
Jump to search
| Line 38: | Line 38: | ||
<syntaxhighlight lang='bash'> | <syntaxhighlight lang='bash'> | ||
mysql -u root -p<password> "SELECT VERSION()" 2>&1 | mysql -u root -p<password> -e "SELECT VERSION()" 2>&1 | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 06:01, 30 March 2021
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();
...
Alternatively:
mysql -u root -p<password> -e "SELECT VERSION()" 2>&1