Linux

Setting Up a High-Performance Laravel Hosting Environment on Ubuntu with Nginx, PHP 8.4, Node.js, and SSL

This is a comprehensive guide to setting up a high-performance hosting environment for Laravel applications on Ubuntu. The guide covers the installation of required software, including Nginx, PHP 8.4, Node.js, and Certbot for SSL, as well as the configuration of the server for optimal performance.

Setting Up a High-Performance Laravel Hosting Environment on Ubuntu with Nginx, PHP 8.4, Node.js, and SSL Read More »

Useful MySQL Commands

Below is a list of very common MySQL/MariaDB commands that any developer should know by heart. Export MySQL Database mysqldump -u username -p database_name > dump.sql Import MySQL Database mysql -u username -p -h servername database-name < data.sql Login MySQL Database mysql -uusername -p Create MySQL Users CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON database . tablename

Useful MySQL Commands Read More »

Connecting to Ubuntu Servers With RSA Keys

I manage a bunch of internal servers and for those that aren’t part of the wider web I like to use key pairs to speed up my sign ins and maintenance. Key-Based SSH Logins Key-based authentication is the most secure mode of authentication usable with OpenSSH. Key-based authentication has several advantages over password authentication, for example

Connecting to Ubuntu Servers With RSA Keys Read More »

Useful Command Line Scripts

Below is a list of very common linux commands that any linux person should know by heart. From gzipping files, to running backups this is my personal cheat sheet Compressing Files and Folders Unzip 7z Archive 7za x myfiles.7z gzip File gzip -9 file gzip Folder tar -zcvf archive-name.tar.gz directory-name Uncompress Gzip File gzip -d

Useful Command Line Scripts Read More »