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:57] – juckins | ubuntu_notes [2019/01/26 12:15] – 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:// | ||
+ | Other SQL commands/ | ||
+ | |||
+ | |||
+ | CREATE USER ' | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | CREATE DATABASE dbname; | ||
+ | SET PASSWORD FOR ' | ||
---- | ---- | ||
ubuntu_notes.txt · Last modified: 2021/02/21 11:09 by juckins