This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Bitnami applications installed in a prefix URL | |
Include "C:/Workspace/Bitnami/apps/phpmyadmin/conf/httpd-prefix.conf" | |
Include "C:/Workspace/Bitnami/apps/wordpress/conf/httpd-prefix.conf" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://github.com/DigitalOcean-User-Projects/Articles-and-Tutorials/blob/master/set_hostname_fqdn_on_ubuntu_centos.md | |
https://www.digitalocean.com/community/articles/how-to-set-up-a-host-name-with-digitalocean | |
https://www.digitalocean.com/community/tutorials/how-to-use-an-spf-record-to-prevent-spoofing-improve-e-mail-reliability | |
https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-dkim-with-postfix-on-debian-wheezy |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// mysql version | |
apt-cache policy mysql-server | |
// mysql reconfig | |
sudo dpkg-reconfigure mysql-server-*.* | |
// phpmyadmin reconfig | |
sudo dpkg-reconfigure phpmyadmin |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Count nubmer of files in folder | |
find FOLDER_NAME -type f | wc -l |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE table_name | |
SET column_name = REPLACE(column_name, 'old_string_part', 'new_string_part'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// http://stackoverflow.com/questions/9479117/vagrant-virtualbox-apache2-strange-cache-behaviour | |
// Apache | |
EnableSendfile off | |
// nging | |
sendfile off |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// connect to database | |
mysql -u root | |
// create new database for wp | |
CREATE DATABASE wordpress; | |
// check database user in vesta cp | |
// grant database user all privileges for wp database, admin_default is database user by default | |
GRANT ALL PRIVILEGES ON wordpress.* TO admin_default@localhost; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// display size of the folder | |
du -hs /path/to/directory |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// optime jpegs in folder | |
jpegoptim *.jpg —strip-all | |
// optimize jpegs recursivelly | |
find -type f -name "*.jpg" -exec jpegoptim --strip-all {} \; |