Site Tools


linux:general:mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
linux:general:mysql [2020/01/13 22:20] lunetikklinux:general:mysql [2020/01/13 22:31] (current) lunetikk
Line 20: Line 20:
  
 If you want to automate things you might want to login without a plaintext password. 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 Add a profile to your MySQL config
Line 26: Line 30:
 You can now login via You can now login via
 <code>mysql --login-path=<YOURPROFILENAME></code> <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 ==== ==== Backup and Restore ====
linux/general/mysql.1578950457.txt.gz · Last modified: 2020/01/13 22:20 by lunetikk