This is an old revision of the document!
apt-get install mysql-server
Execute the following after the installation
mysql_secure_installation
You can find the config in
/etc/mysql/mysql.conf.d/mysqld.cnf
If you want to automate things you might want to login without a plaintext password.
Add a profile to your MySQL config
mysql_config_editor set --login-path=<YOURPROFILENAME> --host=<YOURHOSTIP> --user=<YOURUSERNAME> --password
You can now login via
mysql --login-path=<YOURPROFILENAME>
All profiles can be listed via
mysql_config_editor print --all
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
my_print_defaults -s <YOURPROFILENAME>
Backup a single table in a database
mysqldump <db> <table> > dump.sql
Backup all tables in a single database
mysqldump <db> > dump.sql
Backup all tables in all databases
mysqldump --all-databases > dump.sql
Also check out a script to backup all databases from my collegue Tom wiki.tmade.de - Backup MySQL
mysql < dump.sql
Also check out a script to restore databases from my collegue Tom wiki.tmade.de - Restore MySQL
Command | Function |
---|---|
mysqldump | - |
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 |
mysql -uroot -p -h 127.0.0.1 -P 3306 | Connect to mysql, enter password after execution |