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:28] 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 All profiles can be listed via
 <code>mysql_config_editor print --all</code> <code>mysql_config_editor print --all</code>
  
-:!: YOU SHOULD NOT ALLOW ADD ROOT AS A PROFILE, THE PASSWORD STORE IS NOT SECURE :!: +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
- +
-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> <code>my_print_defaults -s <YOURPROFILENAME></code>
 +
 ==== Backup and Restore ==== ==== Backup and Restore ====
  
linux/general/mysql.1578950889.txt.gz · Last modified: 2020/01/13 22:28 by lunetikk