Differences

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

--- linux:general:mysql [2019/06/17 12:50] – lunetikk
+++ linux:general:mysql [2020/01/13 22:31] (current) – lunetikk
@@ Line 1: / Line 1: @@
-FIXME
 ===== MySQL =====
 ==== Install ====
+<code>
+apt-get install mysql-server
+</code>
 ==== Configure ====
+Execute the following after the installation
+<code>mysql_secure_installation</code>
+You can find the config in
+<code>
+/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 a standard mysql-server tool
+<code>my_print_defaults -s <YOURPROFILENAME></code>
 ==== Backup and Restore ====

Lunetikk's IT Wiki