sudo apt-get install mysql-server
apt-get install mysql-server-core-5.5
how to install mysql-server & phpmyadmin
Reply
Category Archives: Linux
Install Apache Solr
http://geroldm.com/2012/08/drupal-and-apachesolrtomcat-multi-core-setup-in-debianubuntu/
Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’)
1. generate mysql5 hash value of mysql password
2. execute SET PASSWORD FOR ‘username’ = ‘*aa1420f182e88b9e5f874f6fbe7459291e8f4601’ in phpmyadmin
References
1. http://www.insidepro.com/hashes.php
2. http://stackoverflow.com/questions/4807072/windows-7-php-mysql-connection-issues
Enable rewrite module for making .htaccess to work
a2enmod rewrite
Warning: SuexecUserGroup directive requires SUEXEC wrapper
apt-get install apache2-suexec-custom
Block All Incoming Traffic But Allow SSH
/sbin/iptables -A INPUT -p tcp --dport 22 -j ACCEPT /sbin/iptables -A OUTPUT -p tcp --sport 22 -j ACCEPT
Make a SWAP
1. fallocate -l 512M /swapfile
2. chmod 600 /swapfile
3. mkswap /swapfile
4. swapon /swapfile
5. Edit fstab file
/swapfile none swap defaults 0 0
Set timezone in Ubuntu
1. dpkg-reconfigure tzdata
2. sudo apt-get install ntp
Enable PPTP penetration ability in Router
Add “ip_nat_pptp” into /etc/modules
PPTP client behind NAT
1. modprobe ip_nat_pptp
2. iptables -t nat -I PREROUTING -p gre -d natserveripaddress -j DNAT –to pptp-client-ip-address
Reference: http://bbs.chinaunix.net/thread-2194117-1-1.html