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
Last revisionBoth sides next revision
linux:general:mysql [2019/06/06 14:19] – lunetikklinux:general:mysql [2020/01/13 22:30] – 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 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.txt · Last modified: 2020/01/13 22:31 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