<\/div>\n
Step 2: Install MySQL<\/h2>\n
MySQL is a powerful database management system used for organizing and retrieving data<\/p>\n
To install MySQL, open terminal and type in these commands:<\/p>\n
sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql<\/pre>\nDuring the installation, MySQL will ask you to set a root password. If you miss the chance to set the password while the program is installing, it is very easy to set the password later from within the MySQL shell.<\/p>\n
Once you have installed MySQL, we should activate it with this command:<\/p>\n
sudo mysql_install_db<\/pre>\nFinish up by running the MySQL set up script:<\/p>\n
sudo \/usr\/bin\/mysql_secure_installation<\/pre>\nThe prompt will ask you for your current root password.<\/p>\n
Type it in.<\/p>\n
Enter current password for root (enter for none): \r\n\r\nOK, successfully used password, moving on...<\/pre>\nThen the prompt will ask you if you want to change the root password. Go ahead and choose N and move on to the next steps.<\/p>\n
It\u2019s easiest just to say Yes to all the options. At the end, MySQL will reload and implement the new changes.<\/p>\n
By default, a MySQL installation has an anonymous user, allowing anyone\r\nto log into MySQL without having to have a user account created for\r\nthem. This is intended only for testing, and to make the installation\r\ngo a bit smoother. You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] y \r\n ... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'. This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] y\r\n... Success!\r\n\r\nBy default, MySQL comes with a database named 'test' that anyone can\r\naccess. This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] y\r\n - Dropping test database...\r\n ... Success!\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] y\r\n ... Success!\r\n\r\nCleaning up...<\/pre>\nOnce you’re done with that you can finish up by installing PHP.<\/p>\n
<\/div>\n
Step 3: Install PHP<\/h2>\n
PHP is an open source web scripting language that is widely use to build dynamic webpages.<\/p>\n
To install PHP, open terminal and type in this command.<\/p>\n
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt<\/pre>\nAfter you answer yes to the prompt twice, PHP will install itself.<\/p>\n
It may also be useful to add php to the directory index, to serve the relevant php index files:<\/p>\n
sudo nano \/etc\/apache2\/mods-enabled\/dir.conf<\/pre>\nAdd index.php to the beginning of index files. The page should now look like this:<\/p>\n
<IfModule mod_dir.c>\r\n\r\n DirectoryIndex index.php index.html index.cgi index.pl index.php index.xhtml index.htm\r\n\r\n<\/IfModule><\/pre>\n<\/div>\n
PHP Modules<\/h2>\n
PHP also has a variety of useful libraries and modules that you can add onto your virtual server. You can see the libraries that are available.<\/p>\n
apt-cache search php5-<\/pre>\nTerminal will then display the list of possible modules. The beginning looks like this:<\/p>\n
php5-cgi - server-side, HTML-embedded scripting language (CGI binary)\r\nphp5-cli - command-line interpreter for the php5 scripting language\r\nphp5-common - Common files for packages built from the php5 source\r\nphp5-curl - CURL module for php5\r\nphp5-dbg - Debug symbols for PHP5\r\nphp5-dev - Files for PHP5 module development\r\nphp5-gd - GD module for php5\r\nphp5-gmp - GMP module for php5\r\nphp5-ldap - LDAP module for php5\r\nphp5-mysql - MySQL module for php5\r\nphp5-odbc - ODBC module for php5\r\nphp5-pgsql - PostgreSQL module for php5\r\nphp5-pspell - pspell module for php5\r\nphp5-recode - recode module for php5\r\nphp5-snmp - SNMP module for php5\r\nphp5-sqlite - SQLite module for php5\r\nphp5-tidy - tidy module for php5\r\nphp5-xmlrpc - XML-RPC module for php5\r\nphp5-xsl - XSL module for php5\r\nphp5-adodb - Extension optimising the ADOdb database abstraction library\r\nphp5-auth-pam - A PHP5 extension for PAM authentication\r\n[...]<\/pre>\nOnce you decide to install the module, type:<\/p>\n
sudo apt-get install name of the module<\/i><\/pre>\nYou can install multiple libraries at once by separating the name of each module with a space.<\/p>\n
Congratulations! You now have LAMP stack on your droplet!<\/p>\n
<\/div>\n
Step 4: RESULTS \u2014 See PHP on your Server<\/h2>\n
Although LAMP is installed, we can still take a look and see the components online by creating a quick php info page<\/p>\n
To set this up, first create a new file:<\/p>\n
sudo nano \/var\/www\/info.php<\/pre>\nAdd in the following line:<\/p>\n
<?php\r\nphpinfo();\r\n?><\/pre>\nThen Save and Exit.<\/p>\n
Restart apache so that all of the changes take effect:<\/p>\n
sudo service apache2 restart<\/pre>\nFinish up by visiting your php info page (make sure you replace the example ip address with your correct one): http:\/\/12.34.56.789\/info.php<\/p>\n","protected":false},"excerpt":{"rendered":"
About LAMP LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Since the virtual private server is already running Ubuntu, the linux part is taken care of. Here is how to install the rest. Set Up The steps ..<\/p>\n
<\/div>\n
Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,6],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54\/revisions\/55"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![this<\/a>.<\/p>\nHow to Find your Server\u2019s IP address<\/h3>\nYou can run the following command to reveal your server\u2019s IP address.<\/p>\nifconfig eth0 | grep inet | awk '{ print $2 }'<\/pre>\n<\/div>\nStep 2: Install MySQL<\/h2>\nMySQL is a powerful database management system used for organizing and retrieving data<\/p>\nTo install MySQL, open terminal and type in these commands:<\/p>\nsudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql<\/pre>\nDuring the installation, MySQL will ask you to set a root password. If you miss the chance to set the password while the program is installing, it is very easy to set the password later from within the MySQL shell.<\/p>\nOnce you have installed MySQL, we should activate it with this command:<\/p>\nsudo mysql_install_db<\/pre>\nFinish up by running the MySQL set up script:<\/p>\nsudo \/usr\/bin\/mysql_secure_installation<\/pre>\nThe prompt will ask you for your current root password.<\/p>\nType it in.<\/p>\nEnter current password for root (enter for none): \r\n\r\nOK, successfully used password, moving on...<\/pre>\nThen the prompt will ask you if you want to change the root password. Go ahead and choose N and move on to the next steps.<\/p>\nIt\u2019s easiest just to say Yes to all the options. At the end, MySQL will reload and implement the new changes.<\/p>\nBy default, a MySQL installation has an anonymous user, allowing anyone\r\nto log into MySQL without having to have a user account created for\r\nthem. This is intended only for testing, and to make the installation\r\ngo a bit smoother. You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] y \r\n ... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'. This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] y\r\n... Success!\r\n\r\nBy default, MySQL comes with a database named 'test' that anyone can\r\naccess. This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] y\r\n - Dropping test database...\r\n ... Success!\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] y\r\n ... Success!\r\n\r\nCleaning up...<\/pre>\nOnce you’re done with that you can finish up by installing PHP.<\/p>\n<\/div>\nStep 3: Install PHP<\/h2>\nPHP is an open source web scripting language that is widely use to build dynamic webpages.<\/p>\nTo install PHP, open terminal and type in this command.<\/p>\nsudo apt-get install php5 libapache2-mod-php5 php5-mcrypt<\/pre>\nAfter you answer yes to the prompt twice, PHP will install itself.<\/p>\nIt may also be useful to add php to the directory index, to serve the relevant php index files:<\/p>\nsudo nano \/etc\/apache2\/mods-enabled\/dir.conf<\/pre>\nAdd index.php to the beginning of index files. The page should now look like this:<\/p>\n<IfModule mod_dir.c>\r\n\r\n DirectoryIndex index.php index.html index.cgi index.pl index.php index.xhtml index.htm\r\n\r\n<\/IfModule><\/pre>\n<\/div>\nPHP Modules<\/h2>\nPHP also has a variety of useful libraries and modules that you can add onto your virtual server. You can see the libraries that are available.<\/p>\napt-cache search php5-<\/pre>\nTerminal will then display the list of possible modules. The beginning looks like this:<\/p>\nphp5-cgi - server-side, HTML-embedded scripting language (CGI binary)\r\nphp5-cli - command-line interpreter for the php5 scripting language\r\nphp5-common - Common files for packages built from the php5 source\r\nphp5-curl - CURL module for php5\r\nphp5-dbg - Debug symbols for PHP5\r\nphp5-dev - Files for PHP5 module development\r\nphp5-gd - GD module for php5\r\nphp5-gmp - GMP module for php5\r\nphp5-ldap - LDAP module for php5\r\nphp5-mysql - MySQL module for php5\r\nphp5-odbc - ODBC module for php5\r\nphp5-pgsql - PostgreSQL module for php5\r\nphp5-pspell - pspell module for php5\r\nphp5-recode - recode module for php5\r\nphp5-snmp - SNMP module for php5\r\nphp5-sqlite - SQLite module for php5\r\nphp5-tidy - tidy module for php5\r\nphp5-xmlrpc - XML-RPC module for php5\r\nphp5-xsl - XSL module for php5\r\nphp5-adodb - Extension optimising the ADOdb database abstraction library\r\nphp5-auth-pam - A PHP5 extension for PAM authentication\r\n[...]<\/pre>\nOnce you decide to install the module, type:<\/p>\nsudo apt-get install name of the module<\/i><\/pre>\nYou can install multiple libraries at once by separating the name of each module with a space.<\/p>\nCongratulations! You now have LAMP stack on your droplet!<\/p>\n<\/div>\nStep 4: RESULTS \u2014 See PHP on your Server<\/h2>\nAlthough LAMP is installed, we can still take a look and see the components online by creating a quick php info page<\/p>\nTo set this up, first create a new file:<\/p>\nsudo nano \/var\/www\/info.php<\/pre>\nAdd in the following line:<\/p>\n<?php\r\nphpinfo();\r\n?><\/pre>\nThen Save and Exit.<\/p>\nRestart apache so that all of the changes take effect:<\/p>\nsudo service apache2 restart<\/pre>\nFinish up by visiting your php info page (make sure you replace the example ip address with your correct one): http:\/\/12.34.56.789\/info.php<\/p>\n","protected":false},"excerpt":{"rendered":"About LAMP LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Since the virtual private server is already running Ubuntu, the linux part is taken care of. Here is how to install the rest. Set Up The steps ..<\/p>\n<\/div>\nRead more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,6],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/54\/revisions\/55"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/assets.digitalocean.com\/tutorial_images\/333VJ.png\"){kind=link}