How to hide webserver information on Ubuntu Server
ServerTokens Prod
ServerSignature Off
Restart Apache
/etc/init.d/apache2 restasrt
Catatan-catatan kecil untuk mengingat selalu akan ilmu-ilmu yang harus diamalkan.
Cara mengatasi error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
2. Buat folder mysqld/ di direktori /var/run/ :
sudo mkdir -p /var/run/mysqld/
3. Then create a mysqld.pid file with touch:
sudo touch /var/run/mysqld/mysqld.pid
4. Next create a mysqld.sock file with touch:
sudo touch /var/run/mysqld/mysqld.sock
5. Now change the ownerships of the directory and files to mysql:mysql like this:
sudo chown mysql:mysql -R /var/run/mysqld
6. And restart MySQL like this to get those files set and created:
sudo service mysql restart
#!/bin/bash # Run as root set -e apt-get update apt-get install -y build-essential apt-get install -y libncurses5-dev useradd mysql cd wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.73.tar.gz tar xzvf mysql-5.1.73.tar.gz cd mysql-5.1.73 ./configure \ '--prefix=/usr' \ '--exec-prefix=/usr' \ '--libexecdir=/usr/sbin' \ '--datadir=/usr/share' \ '--localstatedir=/var/lib/mysql' \ '--includedir=/usr/include' \ '--infodir=/usr/share/info' \ '--mandir=/usr/share/man' \ '--with-system-type=debian-linux-gnu' \ '--enable-shared' \ '--enable-static' \ '--enable-thread-safe-client' \ '--enable-assembler' \ '--enable-local-infile' \ '--with-fast-mutexes' \ '--with-big-tables' \ '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' \ '--with-mysqld-user=mysql' \ '--with-libwrap' \ '--with-readline' \ '--with-ssl' \ '--without-docs' \ '--with-extra-charsets=all' \ '--with-plugins=max' \ '--with-embedded-server' \ '--with-embedded-privilege-control' \ CXXFLAGS="-Wno-narrowing -fpermissive" make make install mkdir -p /etc/mysql mkdir -p /var/lib/mysql mkdir -p /etc/mysql/conf.d echo -e '[mysqld_safe]\nsyslog' > /etc/mysql/conf.d/mysqld_safe_syslog.cnf cp /usr/share/mysql/my-medium.cnf /etc/mysql/my.cnf sed -i 's#.*datadir.*#datadir = /var/lib/mysql#g' /etc/mysql/my.cnf chown mysql:mysql -R /var/lib/mysql mysql_install_db --user=mysql mysqld_safe -user=mysql & /usr/bin/mysql_secure_installation cp /usr/share/mysql/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql update-rc.d mysql defaults
Reff: https://gist.github.com/huangqiheng/7fbfcd7f4f97255447713ec6e9e85257
jika hasil restore dari mysql 5.5 ke mysql 5.1 gagal, tambahkan script ini di my.cnf
log_bin_trust_function_creators = 1
restart mysql => sudo /etc/init.d/mysql restart
sudo apt install mysql-server