Labels

Android (1) Apache (1) bash (2) boost (2) C (37) C++ (5) cheatsheet (2) CLion (6) css (3) Debian (34) DL (17) dns (1) Docker (3) Dreamweaver (2) Eclipse (3) fail2ban (5) git (6) GitHub (5) Hacking (4) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (33) javascript (3) Linux (182) Mac (21) Machine Learning (1) mySQL (53) Netbeans (6) Networking (1) Nexus (1) OpenVMS (6) Oracle (4) Pandas (3) php (17) Postgresql (8) Python (9) raid (1) RedHat (15) Samba (2) Slackware (52) SQL (14) ssh (1) svn (1) tar (1) ThinkPad (1) Virtualbox (4) Visual Basic (2) Visual Studio (1) Windows (7) wire (1)

Saturday, 24 October 2020

Setup VPN in Debian

In this case, using xfce and assuming Network manager is installed and configured, you need to then install the following;

sudo apt-get install network-manager-openconnect

You may need to install additional network-manager plug-ins and you can search those by;

sudo apt search 'network-manager-*'

then installing as;

sudo apt-get install network-manager-plugin-name

Monday, 19 October 2020

Saturday, 17 October 2020

Connect to remote mySQL server from the command line.

mysql -u username -h xxx.xxx.xxx.xxx -p

where username is the username of the remote mySQL server.

The following can also be used to test connection;

nc -z -w1 xxx.xxx.xxx.xxx 3306

MySQL Master Slave replication setup

MySQL replication setup

mySQL info

A quick way to get some mysql information is to run

mysql --help --verbose

How to setup a ramdisk in Linux

How to setup a ramdisk in Linux

Friday, 16 October 2020

Change temporary tables in mySQL to memory

To change the location of temporary tables in mySQL, we need to edit the tmpdir variable in my.cnf or which ever file contains the [mysqld] section.

Thursday, 15 October 2020