mysql: passwordless local user

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::