Configure Webmin to Allow Connecting to MySQL Remotely

You’ll need to forward port 3306 from your router to your Virtualmin server Go into Webmin -> Servers -> MySQL Database Server -> MySQL Server Configuration, and set “MySQL server listening address” to “0.0.0.0”  to get it listening on all interfaces. (by default 127.0.0.1) For any Virtual Server that should have remotely accessible databases, go […]

PhpMyAdmin User/Password

The user/password can be found in the config.inc.php file in phpmyadmin folder. This user wil have all authorizations for databases. $cfg[‘Servers’][$i][‘user’] = ‘root’; /** * MySQL password (only needed with ‘config’ auth_type) * * @global string $cfg[‘Servers’][$i][‘password’] */ $cfg[‘Servers’][$i][‘password’] = ”;

Enable Cache Control for WordPress

Ensure that Apache Mod Headers is enabled Virtualmin Tab > Services > Configure Website > Global Configuration tab > Configure Apache Module Icon > “headers” Checkbox > checked Edit .htaccess file Include the following in the .htaccess file # BEGIN WordPress RewriteEngine On RewriteBase / RewriteRule ^index.php$ – [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d […]

Execute Long Running Script using SSH and TMUX

A) CREATE SESSION SSH to your server Run TMUX tmux new -s <session name> Run your script (e.g. python myscript.py) Detach TMUX session by pressing CTRL+B followed by D Execute from SSH B) MONITOR SESSION SSH to your server at a later time List all the sessions running in TMUX # tmux ls Attach to […]