Note: When configuring the passive port range, a selected port range must be in the non-privileged range (e.g., greater than or equal to 1024). It is strongly recommended that the chosen range should be large enough to handle many simultaneous passive connections. The default passive port range is 49152-65535 (the IANA registered ephemeral port range).
Connect to a server via SSH.
Run the command below...
Thứ Ba, 29 tháng 10, 2019
Thứ Ba, 22 tháng 10, 2019
Watch mysql processlist in (almost) real time
watch -n 1 “mysql -h 10.0.0.1 -u username -pPASSWORD -e ‘SHOW PROCESSLIST;...
Thứ Hai, 21 tháng 10, 2019
.my.cnf – mysql user & password
.my.cnf – mysql user & password
This one is for lazy ones! If you are paranoid about security, do not use this.
Create file ~/.my.cnf and add following lines in it and replace mysqluser & mysqlpass values.
[client]
user=mysqluser
password=mysqlpass
For safety, make this file readable to you only by running chmod 0600 ~/.my.cnf ...
Đăng ký:
Bài đăng (Atom)