ubuntu_notes
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
ubuntu_notes [2019/01/26 11:59] – juckins | ubuntu_notes [2019/01/27 10:56] – juckins | ||
---|---|---|---|
Line 49: | Line 49: | ||
</ | </ | ||
- | Then login with this: | + | Then login like this: |
sudo mysql -u root -p | sudo mysql -u root -p | ||
+ | | ||
+ | Login with a non-root user like this: | ||
+ | mysql -u username -p | ||
| | ||
See notes at [[https:// | See notes at [[https:// | ||
+ | |||
+ | Other SQL commands/ | ||
+ | |||
+ | |||
+ | CREATE USER ' | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | CREATE DATABASE dbname; | ||
+ | SET PASSWORD FOR ' | ||
+ | | ||
+ | | ||
+ | To fix this locale error upon login: | ||
+ | -bash: warning: setlocale: LC_ALL: cannot change locale (en_US) | ||
+ | |||
+ | |||
---- | ---- |
ubuntu_notes.txt · Last modified: 2021/02/21 11:09 by juckins