Book Navigation
- IT
-
Apache
3 Pages
- Git
-
Linux Administration
12 Pages
-
MacOS
3 Pages
-
MySQL
5 Pages
-
Virtualization
2 Pages
-
Mikrotik
2 Pages
-
Networking Administration
2 Pages
-
Curiosities
1 Page
-
Tools
1 Page
-
Servers
1 Page
-
Web development
2 Pages
-
Windows Server
1 Page
MySQL
Linux auto-login on MySQL
Create file ~/.my.cnf and add the following lines, replace mysqluser and mysqlpass values with ...
Encoding and collation
Changing database encoding and collation ALTER DATABASE `sua_base` CHARSET = Latin1 COLLATE = la...
Exporting data
To export structure only, use this option on mysqldump: mysqldump [...] --no-data To export com...
Useful commands
Show status show table status; Purging MySQL Binlog files To show binary logs mysql>...
Security
Iptables configuration to allow specific host connection to mysql: iptables -A INPUT -i eth0 -p ...