Mariadb is very similar to mysql, its uses the same syntax and commands. The main difference between them both is when it comes to database replication, this is something that wont be covered on here for a while. Quick Links: Adding the Mariadb Repository Installing Mariadb Installing Mariadb PHP plugin Mysql was previously fully […]
htaccess
Quick Links: .htaccess for apache mod_rewrite for .htaccess apache .htpassword file nginx http auth (.htaccess equivalent) mod_rewrite for nginx Securing phpmyadmin centos htaccess for apache .htaccess to can be used to specify protecting of a location or protect wp-admin login for wordpress. To use the .htaccess file you will need to allow the file […]
mysql / Mariadb commands
This guide will go through some mysql commands, these will also be relevant to Mariadb Quick Links: Deleting a user Changing the host of a user Changing a users password Granting user privileges mysql dump mysql secure copy (scp) Securing mysql Remotely accessing your db Finding out the size of a db or table […]
Firewall / IPtables / UFW
IP tables and ufw can be used to allow access to your servers ports. If you have a webserver running then you will need to allow port 80 (standard http port) to enable people access to your website. Please note, these are standard ports and can vary. CentOS – iptables iptables -L will list […]
phpmyadmin
Quick Links: Installing phpMyAdmin in ubuntu (apache) Installing phpMyAdmin in Centos (apache) Installing phpmyadmin with apache: Ubuntu: apt-get install -y phpmyadmin && echo Include /etc/phpmyadmin/apache.conf >> /etc/apache2/apache2.conf && service apache2 restart CentOS: yum install phpmyadmin Then edit: /etc/httpd/conf/httpd.conf Example: vim /etc/httpd/conf/httpd.conf Add the following to the bottom of the file: <Directory “/usr/share/phpMyAdmin”> […]