Lunetikk's IT Wiki

User Tools

Site Tools

You are here: start » linux » general » mysql
Trace:
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:14] – lunetikklinux:general:mysql [2020/01/13 22:31] (current) – lunetikk
Line 16: Line 16:
 /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf
 </code> </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 ==== ==== Backup and Restore ====
linux/general/mysql.1578950071.txt.gz · Last modified: 2020/01/13 22:14 by lunetikk

Page Tools

Impressum Datenschutz
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki