Search Results

Create file ~/.my.cnf and add the following lines, replace mysqluser and mysqlpass values with the correct ones [client] user=mysqluser password="mysqlpass" For safety, make this file readable to you only by running chmod 0600 ~/.my.cnf  Next time you run mysq...

Changing database encoding and collation ALTER DATABASE `sua_base` CHARSET = Latin1 COLLATE = latin1_swedish_ci; https://pt.stackoverflow.com/questions/72139/qual-codificação-de-caracteres-collation-devo-usar-em-mysql

To export structure only, use this option on mysqldump: mysqldump [...] --no-data To export command result to csv file format: SELECT order_id,product_name,qty FROM orders WHERE foo = 'bar' INTO OUTFILE '/var/lib/mysql-files/orders.csv' FIELDS TERMINATED BY ',...

Show status  show table status; Purging MySQL Binlog files   To show binary logs mysql> SHOW BINARY LOGS; To Purge binary logs manually until some point mysql> PURGE BINARY LOGS TO 'binlog.000776'; To show binary logs mysql> SET GLOBAL binlog_expire_logs_secon...

Iptables configuration to allow specific host connection to mysql: iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -s IP.ADD.RE.SS -j ACCEPT

http://www.mustbegeek.com/create-copy-of-existing-virtual-machine-in-esxi-server/

VDI /VHD Conversion With virtualbox https://www.sysprobs.com/vdi-vhd-convert-virtualbox-virtual-machines-virtual-pc  

      https://jcutrer.com/howto/networking/mikrotik/perfectrestore-script    

In this tutorial we will setup a VPN (Virtual Private Network). There are multiple types of VPN, in this tutorial we will focus on "remote access VPN" type. We will configure server and client and test the connection. WireGuard uses ChaCha20 Encryption Algorit...

3Com Choosing which firmware to boot verifying current versions: > show version setting next-active to the backup (before update) one: > boot system backup setting next-active to the active (most recent) one: > boot system active Reset to defaults: https://www...

Cisco configuration interface GigabitEthernet0/11 switchport trunk allowed vlan 200,231 switchport mode trunk switchport voice vlan 280 spanning-tree portfast end   Kali Linux configuration /etc/networking/interfaces interface GigabitEthernet0/11 switchport tr...

Off by one error (OBOE) https://en.wikipedia.org/wiki/Off-by-one_error  Layer 8 Issues https://en.wikipedia.org/wiki/Layer_8  

Download entire site with wget and authentication   $ wget --user=THE_USERNAME --password=THE_PASSWORD --recursive --no-parent https://SITE_URL/