Enable SSH Root Login
- Edit file /etc/ssh/sshd_config
edit line "PermitRootLogin without-password" to "PermitRootLogin yes"
===================================================================================
==========
Install Apache2
#apt-get install apache2
Enable mod_rewrite
#a2enmod rewrite
Install PHP5
#apt-get install php5 libapache2-mod-php5
Install MySQL 5.6
#wget http://dev.mysql.com/get/mysql-apt-config_0.3.5-1debian8_all.deb
or
#wget https://repo.mysql.com//mysql-apt-config_0.8.9-1_all.deb
#dpkg -i mysql-apt-config_0.3.5-1debian8_all.deb
Note : You will be asked to select product and version that you want to install. In
the first step, select Server and next select mysql-5.6. Then click Apply.
#apt-get update
#apt-get install mysql-community-server
Show Php5 Module
#apt-cache search php5
Install PHP5 Module
#apt-get install php5-mysql php5-curl php-pear php5-gd php5-mcrypt php5-sqlite
php5-xmlrpc php5-xsl php-gettext php-tcpdf
PHP5-MySQL (Native Driver)
#apt-get install php5-mysqlnd
Speed UP PHP
#apt-get install php5-apcu
Install Curl
#apt-get install curl
Install Imagemagick
#apt-get install imagemagick
Install PhpMyAdmin
#apt-get install phpmyadmin
=====================================================================
Change PhpMyAdmin Port
#service apache2 stop
#rm /etc/apache2/conf-enabled/phpmyadmin.conf
#rm /etc/apache2/conf-available/phpmyadmin.conf
- Add Listen 2082 to /etc/apache2/ports.conf
- Copy file vhost-2082.conf to /etc/apache2/site-available
#a2ensite vhost-2082
#cd /var/www/2082/
#ln -s /usr/share/phpmyadmin/
#service apache2 start
======================================================================
Restore database from SQL Dump
#mysql -u root -p [database-name] < [sql_dump_filename]
======================================================================
Allow Root Remote Access MySQL
CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'root'@'%';
======================================================================
Create User Remote access MySQL
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
THEN
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';
======================================================================
Install MySQL Python
#apt-get install python-mysqldb
