diff options
author | bnewbold <bnewbold@robocracy.org> | 2017-06-13 11:57:50 -0700 |
---|---|---|
committer | bnewbold <bnewbold@robocracy.org> | 2017-06-13 11:57:50 -0700 |
commit | e6af2e5439693cd1acd7d4bfe6d80c1ed8cdd0b6 (patch) | |
tree | a2c09f5cb1509aa8cf16ae3b4f16d11db3d7e9c8 /software/sql.page | |
parent | db8c2e8217fc67a1a506ae334ac40df54b52c739 (diff) | |
download | knowledge-e6af2e5439693cd1acd7d4bfe6d80c1ed8cdd0b6.tar.gz knowledge-e6af2e5439693cd1acd7d4bfe6d80c1ed8cdd0b6.zip |
mysql/sql updates
Diffstat (limited to 'software/sql.page')
-rw-r--r-- | software/sql.page | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/software/sql.page b/software/sql.page index 881a040..2d2a307 100644 --- a/software/sql.page +++ b/software/sql.page @@ -5,25 +5,6 @@ toc: no # SQL -### MySQL-specific Tricks - -To output in tab-delimited format, do something like: - - mysql -u root -p -B < some_command.sql > output.tab - -### Setup User Permissions - -On contemporary Debian, to login as root do: - - sudo mysql -u root - -Then create a new password-less local-only user: - - CREATE USER 'bnewbold'@'localhost' IDENTIFIED BY ''; - UPDATE mysql.user SET plugin='unix_socket' WHERE user='bnewbold'; - GRANT ALL PRIVILEGES ON * . * TO 'bnewbold'@'localhost'; - FLUSH PRIVILEGES; - ### UPDATE with JOIN To do an update based on a join:: |