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 »
If 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
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 »
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 »
Frequently I am asked by clients for details on how to manage a lampp server. While I do not recommend that clients who are not familiar with systems mess with the core system there are a few simple tasks that anyone can do to back or restart basic systems. Let’s get started. First you need
Basic Linux Commands For Managing A LAMPP Server Read More »
