MySQL
Linux auto-login on MySQL
Create file ~/.my.cnf and add the following lines, replace mysqluser and mysqlpass values with th...
Encoding and collation
Changing database encoding and collation ALTER DATABASE `sua_base` CHARSET = Latin1 COLLATE = lat...
Exporting data
To export structure only, use this option on mysqldump: mysqldump [...] --no-data To export comma...
Useful commands
Show status show table status; Purging MySQL Binlog files To show binary logs mysql> SHOW BINA...
Security
Iptables configuration to allow specific host connection to mysql: iptables -A INPUT -i eth0 -p t...