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 [2019/06/06 14:19] – lunetikklinux:general:mysql [2020/01/13 22:31] (current) – lunetikk
Line 1: Line 1:
-FIXME 
- 
 ===== MySQL ===== ===== MySQL =====
  
 ==== Install ==== ==== Install ====
 +
 +<code>
 +apt-get install mysql-server
 +</code>
  
 ==== Configure ==== ==== Configure ====
 +
 +Execute the following after the installation
 +<code>mysql_secure_installation</code>
 +
 +You can find the config in
 +<code>
 +/etc/mysql/mysql.conf.d/mysqld.cnf
 +</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 ====
Line 11: Line 43:
 === Backup === === Backup ===
  
-Backup a single Table in a database+Backup a single table in a database
 <code> <code>
 mysqldump <db> <table> > dump.sql mysqldump <db> <table> > dump.sql
Line 25: Line 57:
 mysqldump --all-databases > dump.sql mysqldump --all-databases > dump.sql
 </code> </code>
 +
 +Also check out a script to backup all databases from my collegue Tom [[https://tmade.de/wiki/doku.php?id=database:mysql#backup|wiki.tmade.de - Backup MySQL]]
  
 === Restore === === Restore ===
Line 30: Line 64:
 mysql < dump.sql mysql < dump.sql
 </code> </code>
 +
 +Also check out a script to restore databases from my collegue Tom [[https://tmade.de/wiki/doku.php?id=database:mysql#restore|wiki.tmade.de - Restore MySQL]]
  
 ==== Commands ==== ==== Commands ====
Line 37: Line 73:
 |  %%mysqlcheck --repair --databases <db>%%  |  Repair data types and character sets of a single db changed by updates  | |  %%mysqlcheck --repair --databases <db>%%  |  Repair data types and character sets of a single db changed by updates  |
 |  %%mysqlcheck --repair --all-databases%%  |  Repair data types and character sets of all dbs changed by updates  | |  %%mysqlcheck --repair --all-databases%%  |  Repair data types and character sets of all dbs changed by updates  |
 +|  %%mysql -uroot -p -h 127.0.0.1 -P 3306%%  |  Connect to mysql, enter password after execution  |
  
 ==== Troubleshooting ==== ==== Troubleshooting ====
linux/general/mysql.1559823586.txt.gz · Last modified: 2019/06/06 14:19 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