summaryrefslogtreecommitdiffstats
path: root/software
diff options
context:
space:
mode:
Diffstat (limited to 'software')
-rw-r--r--software/sql.page13
1 files changed, 13 insertions, 0 deletions
diff --git a/software/sql.page b/software/sql.page
index c485133..881a040 100644
--- a/software/sql.page
+++ b/software/sql.page
@@ -11,6 +11,19 @@ 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::