WebServer - Basic LAMP Stack Install - Revision history

Tinker: /* Configure MySQL (MariaDB) */

2025-09-12T18:18:20Z

Configure MySQL (MariaDB)

← Older revision		Revision as of 14:18, 12 September 2025
Line 67:		Line 67:
	==== Configure MySQL (MariaDB) ====		==== Configure MySQL (MariaDB) ====

	*<code>sudo mysql_secure_installation</code>		*<span style="text-decoration: line-through;"><code>sudo mysql_secure_installation</code></span>
			*<code>sudo mariadb-secure-installation</code> # The sequence following is changed somewhat... (WIP)
	**<u>Would you like to setup VALIDATE PASSWORD component?</u>		**<u>Would you like to setup VALIDATE PASSWORD component?</u>
	***I select <span style="color: rgb(22, 145, 121);">No</span> (because I'd rather manage my own password policies, thanks...)		***I select <span style="color: rgb(22, 145, 121);">No</span> (because I'd rather manage my own password policies, thanks...)

Tinker: /* Configure MySQL */

2025-07-23T17:02:57Z

Configure MySQL

← Older revision		Revision as of 13:02, 23 July 2025
Line 65:		Line 65:
	<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

	==== Configure MySQL ====		==== Configure MySQL (MariaDB) ====

	*<code>sudo mysql_secure_installation</code>		*<code>sudo mysql_secure_installation</code>

Tinker: /* Install the packages */

2025-07-18T18:20:24Z

Install the packages

← Older revision		Revision as of 14:20, 18 July 2025
Line 52:		Line 52:

	*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>		*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>
			OR:
			*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mariadb-server mariadb-client php-mysql</code>

	* <span style="color: rgb(22, 145, 121);">If you are using a separate database server:</span>		* <span style="color: rgb(22, 145, 121);">If you are using a separate database server:</span>
	**<code><span style="color: rgb(22, 145, 121);">sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-client php-mysql</span></code>		**<code><span style="color: rgb(22, 145, 121);">sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-client php-mysql</span></code>

Tinker: /* & Test it */

2023-11-11T04:56:49Z

& Test it

← Older revision		Revision as of 00:56, 11 November 2023
Line 87:		Line 87:
	*<code>sudo vi /var/www/html/info.php</code>		*<code>sudo vi /var/www/html/info.php</code>
	<pre><nowiki>		<pre><nowiki>
	<?php		<?php
	phpinfo();		phpinfo();
	?>		?>
	</nowiki></pre>		</nowiki></pre>

Tinker: /* & Test it */

2023-11-11T04:55:38Z

& Test it

← Older revision		Revision as of 00:55, 11 November 2023
Line 87:		Line 87:
	*<code>sudo vi /var/www/html/info.php</code>		*<code>sudo vi /var/www/html/info.php</code>
	<pre><nowiki>		<pre><nowiki>
	<?		<?php
	~~php~~ phpinfo();		phpinfo();
	?>		?>
	</nowiki></pre>		</nowiki></pre>

Tinker: /* & Test it */

2023-11-11T02:48:23Z

& Test it

← Older revision		Revision as of 22:48, 10 November 2023
Line 86:		Line 86:

	*<code>sudo vi /var/www/html/info.php</code>		*<code>sudo vi /var/www/html/info.php</code>
	<~~!--~~?php phpinfo();		<pre><nowiki>
	?-->		<?
			php phpinfo();
			?>
			</nowiki></pre>

	Browse to http://ServerAddress/ & you should see the default page.		Browse to http://ServerAddress/ & you should see the default page.

Tinker: /* Install the packages */

2023-04-09T19:08:46Z

Install the packages

← Older revision		Revision as of 15:08, 9 April 2023
Line 54:		Line 54:
	* <span style="color: rgb(22, 145, 121);">If you are using a separate database server:</span>		* <span style="color: rgb(22, 145, 121);">If you are using a separate database server:</span>
	**<code><span style="color: rgb(22, 145, 121);">sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-client php-mysql</span></code>		**<code><span style="color: rgb(22, 145, 121);">sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-client php-mysql</span></code>
	** <span style="color: rgb(22, 145, 121);" >& skip any reference to configuring mysql</span>		** <span style="color: rgb(22, 145, 121);" >& skip any reference to configuring mysql server</span>
	*Say Yes to Continue		*Say Yes to Continue
	**<u>Configuring mysql-community-server</u> (Doesn't happen on Mint but DOES happen on LMDE)		**<u>Configuring mysql-community-server</u> (Doesn't happen on Mint but DOES happen on LMDE)

Tinker: /* Install the packages */

2023-04-09T19:06:28Z

Install the packages

← Older revision		Revision as of 15:06, 9 April 2023
Line 45:		Line 45:

	==== Install the packages ====		==== Install the packages ====
	'''<span style="color: rgb(186, 55, 42);" >Big change(s) incomming...</span>'''		'''<span style="color: rgb(186, 55, 42);">Big change(s) incomming...</span>'''

	'''<span style="color: rgb(186, 55, 42);" >Likely fully replacing MySQL with MariaDB.</span>'''		'''<span style="color: rgb(186, 55, 42);">Likely fully replacing MySQL with MariaDB.</span>'''

	<span style="color: rgb(186, 55, 42);" >(Really, boils down to replacing '''mysql-server''' & '''mysql-client''' with '''mariadb-server''' & '''mariadb-client''' in the next command...)</span>		<span style="color: rgb(186, 55, 42);">(Really, boils down to replacing '''mysql-server''' & '''mysql-client''' with '''mariadb-server''' & '''mariadb-client''' in the next command...)</span>

	*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>		*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>
	**Say Yes to Continue		* <span style="color: rgb(22, 145, 121);">If you are using a separate database server:</span>
			**<code><span style="color: rgb(22, 145, 121);">sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-client php-mysql</span></code>
			** <span style="color: rgb(22, 145, 121);" >& skip any reference to configuring mysql</span>
			*Say Yes to Continue
	**<u>Configuring mysql-community-server</u> (Doesn't happen on Mint but DOES happen on LMDE)		**<u>Configuring mysql-community-server</u> (Doesn't happen on Mint but DOES happen on LMDE)
	***Pick a good '''root''' password...		***Pick a good '''root''' password...

Tinker: /* Install the LAMP Stack */

2023-01-26T21:32:18Z

Install the LAMP Stack

← Older revision		Revision as of 17:32, 26 January 2023
Line 36:		Line 36:

	=== Install the LAMP Stack ===		=== Install the LAMP Stack ===
	~~'''<span style="color: rgb(186, 55, 42);" >Big change(s) incomming...</span>'''~~

	~~'''<span style="color: rgb(186, 55, 42);" >Likely fully replacing MySQL with MariaDB.</span>'''~~
	* [[WebServer - Mint 19.3{{!}}If you are running Mint 19.3]]		* [[WebServer - Mint 19.3{{!}}If you are running Mint 19.3]]
	* If you are running a Debian based Linux		* If you are running a Debian based Linux
Line 47:		Line 45:

	==== Install the packages ====		==== Install the packages ====
			'''<span style="color: rgb(186, 55, 42);" >Big change(s) incomming...</span>'''

			'''<span style="color: rgb(186, 55, 42);" >Likely fully replacing MySQL with MariaDB.</span>'''

			<span style="color: rgb(186, 55, 42);" >(Really, boils down to replacing '''mysql-server''' & '''mysql-client''' with '''mariadb-server''' & '''mariadb-client''' in the next command...)</span>

	*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>		*<code>sudo apt install apache2 libapache2-mod-php php-xml php-mbstring php-apcu php-intl imagemagick inkscape php-gd php-cli php-cgi php mysql-server mysql-client php-mysql</code>

Tinker: /* Install the LAMP Stack */

2023-01-26T20:19:26Z

Install the LAMP Stack

← Older revision		Revision as of 16:19, 26 January 2023
Line 36:		Line 36:

	=== Install the LAMP Stack ===		=== Install the LAMP Stack ===
			'''<span style="color: rgb(186, 55, 42);" >Big change(s) incomming...</span>'''

			'''<span style="color: rgb(186, 55, 42);" >Likely fully replacing MySQL with MariaDB.</span>'''
	* [[WebServer - Mint 19.3{{!}}If you are running Mint 19.3]]		* [[WebServer - Mint 19.3{{!}}If you are running Mint 19.3]]
	* If you are running a Debian based Linux		* If you are running a Debian based Linux
Line 50:		Line 53:
	***Pick a good '''root''' password...		***Pick a good '''root''' password...
	***I tend to select '''Use Legacy Authentication Method''' because '''Use Strong Password Encryption''' is annoying as hell. (Your choice here...)		***I tend to select '''Use Legacy Authentication Method''' because '''Use Strong Password Encryption''' is annoying as hell. (Your choice here...)

	<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

Line 56:		Line 60:
	*<code>sudo mysql_secure_installation</code>		*<code>sudo mysql_secure_installation</code>
	**<u>Would you like to setup VALIDATE PASSWORD component?</u>		**<u>Would you like to setup VALIDATE PASSWORD component?</u>
	***I select <span style="color: rgb(22, 145, 121);" >No</span> (because I'd rather manage my own password policies, thanks...)		***I select <span style="color: rgb(22, 145, 121);">No</span> (because I'd rather manage my own password policies, thanks...)
	**'''''root password'''''		**'''''root password'''''
	***<u>Please set the password for root here.</u>		***<u>Please set the password for root here.</u>
	****<span style="color: rgb(22, 145, 121);" >Pick a good '''root''' password...</span>		****<span style="color: rgb(22, 145, 121);">Pick a good '''root''' password...</span>
	**or... (depends on install...)		**or... (depends on install...)
	***<u>Using existing password for root.</u>		***<u>Using existing password for root.</u>
	****Say <span style="color: rgb(22, 145, 121);" >No</span> (Which actually means yes... The question being asked is "Change the password for root?")		****Say <span style="color: rgb(22, 145, 121);">No</span> (Which actually means yes... The question being asked is "Change the password for root?")
	**<u>Remove anonymous users?</u>		**<u>Remove anonymous users?</u>
	***Duh... <span style="color: rgb(22, 145, 121);" >Yes</span>		***Duh... <span style="color: rgb(22, 145, 121);">Yes</span>
	**<u>Disallow root login remotely?</u>		**<u>Disallow root login remotely?</u>
	***Your choice, but I tend to say <span style="color: rgb(22, 145, 121);" >No</span>.		***Your choice, but I tend to say <span style="color: rgb(22, 145, 121);">No</span>.
	**<u>Remove test database and access to it?</u>		**<u>Remove test database and access to it?</u>
	***Duh... <span style="color: rgb(22, 145, 121);" >Yes</span> again.		***Duh... <span style="color: rgb(22, 145, 121);">Yes</span> again.
	**<u>Reload privilege tables now?</u>		**<u>Reload privilege tables now?</u>
	***<span style="color: rgb(22, 145, 121);" >Yes</span>		***<span style="color: rgb(22, 145, 121);">Yes</span>
	*([[MySQL - Initial Configuration{{!}}Extra Instructions if you've never configured MySQL before]])		*([[MySQL - Initial Configuration{{!}}Extra Instructions if you've never configured MySQL before]])

Line 76:		Line 80:

	*<code>sudo vi /var/www/html/info.php</code>		*<code>sudo vi /var/www/html/info.php</code>
			<!--?php phpinfo();
	<?php		?-->
	phpinfo();
	?>

	Browse to http://ServerAddress/ & you should see the default page.		Browse to http://ServerAddress/ & you should see the default page.