Differences

This shows you the differences between two versions of the page.

--- linux:general:mysql [2020/01/13 22:14] – lunetikk
+++ linux:general:mysql [2020/01/13 22:30] – lunetikk
@@ Line 16: / Line 16: @@
 /etc/mysql/mysql.conf.d/mysqld.cnf
 </code>
+==== Passwordless login ====
+If you want to automate things you might want to login without a plaintext password.
+=== Add profile ===
+:!: WARNING: YOU SHOULD NOT ADD ROOT AS A PROFILE, THE PASSWORD STORE IS NOT SECURE :!:
+Add a profile to your MySQL config
+<code>mysql_config_editor set --login-path=<YOURPROFILENAME> --host=<YOURHOSTIP> --user=<YOURUSERNAME> --password</code>
+You can now login via
+<code>mysql --login-path=<YOURPROFILENAME></code>
+=== Show profiles ===
+All profiles can be listed via
+<code>mysql_config_editor print --all</code>
+You cant edit the file ".mylogin.cnf" in your home and the command above also hides the password, but the following command will show your password and is standard mysql-server tool
+<code>my_print_defaults -s <YOURPROFILENAME></code>
 ==== Backup and Restore ====

Lunetikk's IT Wiki