Reading Time: 7 minutesThis 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.
Reading Time: < 1 minuteBelow 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 »
Reading Time: < 1 minuteIf you are using SSH, you’ll want to run down this checklist of to make that ssh server a bit more secure. If any of these settings is absent from the configuration file, you should add them. For Ubuntu this is in the file /etc/ssh/sshd_config Change Port This is more of a security through obscurity
Reading Time: 2 minutesI 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 »
Reading Time: 2 minutesBelow 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 »
