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:29] lunetikklinux:general:mysql [2020/01/13 22:31] (current) lunetikk
Line 22: Line 22:
  
 === Add profile === === 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 34: Line 36:
 <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.1578950950.txt.gz · Last modified: 2020/01/13 22:29 by lunetikk