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
Last revisionBoth sides next revision
linux:general:mysql [2020/01/13 22:28] lunetikklinux:general:mysql [2020/01/13 22:30] 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.txt · Last modified: 2020/01/13 22:31 by lunetikk