Ubuntu 18.04 phpMyAdmin - Revision history

WikiAdmin: /* LAMP Stack */

2018-07-29T20:41:43Z

LAMP Stack

@@ Line 17: / Line 17: @@
 # Navigate down to 'LAMP server' and press '''<Enter>''';
 # The 'Installing packages' process will download and install the packages for you;
-# Once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;
 ## Answer "'''Y'''";
 ## Select "'''1'''" for Medium or "2" for Strong as suits your security needs;
@@ Line 26: / Line 37: @@
 ## Select whether you want to remove the 'test' database or not;
 ## Answer "'''Y'''" to reload the privileges;
 == phpMyAdmin ==

WikiAdmin: /* LAMP Stack */

2018-07-29T20:38:02Z

LAMP Stack

← Older revision		Revision as of 20:38, 29 July 2018
Line 26:		Line 26:
	## Select whether you want to remove the 'test' database or not;		## Select whether you want to remove the 'test' database or not;
	## Answer "'''Y'''" to reload the privileges;		## Answer "'''Y'''" to reload the privileges;

			With Ubuntu 18.04 MySQL now needs additional tweaking to make it accessible:

			# In a terminal type ''''sudo mysql -u root -p'''' and press ''''<Enter>'''' then input your selected MySQL password from before and press ''''<Enter>'''';
			# Type ''''use mysql''' and press ''''<Enter>'''';
			# Type ''''update user set Plugin='mysql_native_password' where User='root' and Host='localhost';'''' and press ''''<Enter>'''';
			# Type ''''flush privileges;'''' and press ''''<Enter>'''';
			# Type ''''exit'''' and press ''''<Enter>''''.

	== phpMyAdmin ==		== phpMyAdmin ==

WikiAdmin: /* MyPHPAdmin */

2018-07-29T20:29:51Z

MyPHPAdmin

← Older revision		Revision as of 20:29, 29 July 2018
Line 27:		Line 27:
	## Answer "'''Y'''" to reload the privileges;		## Answer "'''Y'''" to reload the privileges;

	== ~~MyPHPAdmin~~ ==		== phpMyAdmin ==

	Visit the [https://www.phpmyadmin.net/downloads/ phpMyAdmin Downloads] page and right-click on the latest version you need in the '.tar.gz' format and select 'Copy Link Location' (or similar). For example, "phpMyAdmin-4.8.2-english.tar.gz" at time of writing, or other language choice to suit your needs. Substitute the name throughout the following as necessary.		Visit the [https://www.phpmyadmin.net/downloads/ phpMyAdmin Downloads] page and right-click on the latest version you need in the '.tar.gz' format and select 'Copy Link Location' (or similar). For example, "phpMyAdmin-4.8.2-english.tar.gz" at time of writing, or other language choice to suit your needs. Substitute the name throughout the following as necessary.

	# Open a new terminal and type ''''mkdir ~~myphpadmin~~'''' and press '''<Enter>''';		# Open a new terminal and type ''''mkdir phpmyadmin'''' and press '''<Enter>''';
	# Type ''''cd ~~myphpadmin~~'''' and press '''<Enter>''';		# Type ''''cd phpmyadmin'''' and press '''<Enter>''';
	# Type ''''wget '''' and right-click and select 'Paste' (therefore, ''''wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-english.tar.gz'''', as per your chosen download) and press '''<Enter>''';		# Type ''''wget '''' and right-click and select 'Paste' (therefore, ''''wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-english.tar.gz'''', as per your chosen download) and press '''<Enter>''';
	# Once downloaded, type ''''tar zxvf phpMyAdmin-4.8.2-english.tar.gz'''' and press '''<Enter>''';		# Once downloaded, type ''''tar zxvf phpMyAdmin-4.8.2-english.tar.gz'''' and press '''<Enter>''';

WikiAdmin: /* LAMP Stack */

2018-07-29T18:08:33Z

LAMP Stack

← Older revision		Revision as of 18:08, 29 July 2018
Line 14:		Line 14:
	The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.		The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.

	# In a terminal type 'sudo tasksel' and press <Enter>;		# In a terminal type 'sudo tasksel' and press '''<Enter>''';
	# Navigate down to 'LAMP server' and press <Enter>;		# Navigate down to 'LAMP server' and press '''<Enter>''';
	# The 'Installing packages' process will download and install the packages for you;		# The 'Installing packages' process will download and install the packages for you;
	# Once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;		# Once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;

WikiAdmin: /* MyPHPAdmin */

2018-07-29T18:08:04Z

MyPHPAdmin

← Older revision		Revision as of 18:08, 29 July 2018
Line 36:		Line 36:
	# Once downloaded, type ''''tar zxvf phpMyAdmin-4.8.2-english.tar.gz'''' and press '''<Enter>''';		# Once downloaded, type ''''tar zxvf phpMyAdmin-4.8.2-english.tar.gz'''' and press '''<Enter>''';
	# Once extracted, type ''''sudo mv phpMyAdmin-4.8.2-english /var/www/html/'''' and press '''<Enter>''';		# Once extracted, type ''''sudo mv phpMyAdmin-4.8.2-english /var/www/html/'''' and press '''<Enter>''';
	~~# Very carefully execute the following command ''''sudo chown -R www-data:www-data /var/www/'''' and press '''<Enter>''';~~
	# Type ''''cd /var/www/html/'''' and press '''<Enter>''';		# Type ''''cd /var/www/html/'''' and press '''<Enter>''';
	# Type ''''sudo mv phpMyAdmin-4.8.2-english phpMyAdmin'''' and press '''<Enter>''' (or other name of your choosing, to be less obvious on a public website);		# Type ''''sudo mv phpMyAdmin-4.8.2-english phpMyAdmin'''' and press '''<Enter>''' (or other name of your choosing, to be less obvious on a public website);
			# Very carefully execute the following command ''''sudo chown -R www-data:www-data /var/www/'''' and press '''<Enter>''';
	# Open a browser and navigate to your server's IP or DNS name, for example ''''http://192.168.0.10/phpMyAdmin/''''.		# Open a browser and navigate to your server's IP or DNS name, for example ''''http://192.168.0.10/phpMyAdmin/''''.

WikiAdmin at 18:06, 29 July 2018

2018-07-29T18:06:58Z

← Older revision		Revision as of 18:06, 29 July 2018
Line 1:		Line 1:

			The open source phpMyAdmin administration tool provides access to maintenance and management of MySQL or MariaDB databases via the convenience of a web-based interface. As such, it can be installed on a new or existing web server and is more-or-less accessible from anywhere, on any browser or mobile device.

	= Installation Process=		= Installation Process=

			The following covers installation of the latest '''phpMyAdmin''' from the main project website, rather than the often outdated Ubuntu repository or Snap packages.

	== LAMP Stack ==		== LAMP Stack ==

	The '''Linux Apache MySQL and PHP''' ~~Stack~~, better known as LAMP, provides all the services for hosting a website using the programming language PHP. Depending on the system, MariaDB might substitute MySQL.		The '''Linux Apache MySQL and PHP''' stack, better known by the acronym ''''LAMP'''', provides all the services for hosting a website using the programming language PHP. Depending on the system, MariaDB might substitute MySQL.

			If you have not yet installed the 'LAMP' stack, do the following:

	The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.		The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.

	# In a terminal type 'sudo tasksel' and press <Enter>;		# In a terminal type 'sudo tasksel' and press <Enter>;
	# Navigate down to 'LAMP server' and press <Enter>;		# Navigate down to 'LAMP server' and press <Enter>;
	# The 'Installing packages' process will download and install the packages for you;		# The 'Installing packages' process will download and install the packages for you;
	#~~# On Ubuntu 16.04 you will get prompted for a MySQL 'root' user password;~~		# Once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;
	~~## On Ubuntu 18.04, once~~ installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;		## Answer "'''Y'''";
	### Answer "Y";		## Select "'''1'''" for Medium or "2" for Strong as suits your security needs;
	### Select "1" for Medium or "2" for Strong as suits your security needs;		## Enter your chosen password and then re-enter to confirm;
	### Enter password and then re-enter to confirm;		## Answer "'''Y'''" to password strength (or otherwise specify a new password that matches the security requirements selected before);
	### Answer "Y" to password strength (or otherwise specify a new password that matches the security requirements selected);		## Answer "'''Y'''" to remove anonymous user accounts;
	### Answer "Y" to ~~remote~~ anonymous user accounts;		## Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not (usually not);
	### Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not;		## Select whether you want to remove the 'test' database or not;
	### Select whether you want to remove the 'test' database or not;		## Answer "'''Y'''" to reload the privileges;
	### Answer "Y" to reload the privileges;

	== MyPHPAdmin ==		== MyPHPAdmin ==

	Visit [https://www.phpmyadmin.net/downloads/] and right-click the latest version in '.tar.gz' format and select 'Copy Link Location' (or similar). For example, "phpMyAdmin-4.8.2-english.tar.gz" or other language choice to suit your needs.		Visit the [https://www.phpmyadmin.net/downloads/ phpMyAdmin Downloads] page and right-click on the latest version you need in the '.tar.gz' format and select 'Copy Link Location' (or similar). For example, "phpMyAdmin-4.8.2-english.tar.gz" at time of writing, or other language choice to suit your needs. Substitute the name throughout the following as necessary.

	# Open a new terminal and type 'mkdir myphpadmin';		# Open a new terminal and type ''''mkdir myphpadmin'''' and press '''<Enter>''';
	# Type 'cd myphpadmin';		# Type ''''cd myphpadmin'''' and press '''<Enter>''';
	# Type 'wget ' and right-click and select 'Paste' (so, "wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-english.tar.gz", as per your chosen download) and press <Enter>;		# Type ''''wget '''' and right-click and select 'Paste' (therefore, ''''wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-english.tar.gz'''', as per your chosen download) and press '''<Enter>''';
	# Once downloaded, type 'tar zxvf phpMyAdmin-4.8.2-english.tar.gz'		# Once downloaded, type ''''tar zxvf phpMyAdmin-4.8.2-english.tar.gz'''' and press '''<Enter>''';
	# Once extracted, type 'sudo mv phpMyAdmin-4.8.2-english /var/www/html/'		# Once extracted, type ''''sudo mv phpMyAdmin-4.8.2-english /var/www/html/'''' and press '''<Enter>''';
	# Very carefully execute the following command 'sudo chown -R www-data:www-data /var/www/';		# Very carefully execute the following command ''''sudo chown -R www-data:www-data /var/www/'''' and press '''<Enter>''';
	# Type 'cd /var/www/html/';		# Type ''''cd /var/www/html/'''' and press '''<Enter>''';
	# Type 'sudo mv phpMyAdmin-4.8.2-english phpMyAdmin' (or other name of your choosing, to be less obvious on a public website);		# Type ''''sudo mv phpMyAdmin-4.8.2-english phpMyAdmin'''' and press '''<Enter>''' (or other name of your choosing, to be less obvious on a public website);
	# Open a browser and navigate to your server's IP or DNS name: http://192.168.0.10/phpMyAdmin/		# Open a browser and navigate to your server's IP or DNS name, for example ''''http://192.168.0.10/phpMyAdmin/''''.

WikiAdmin: WikiAdmin moved page Ubuntu 18.04 PHPMyAdmin to Ubuntu 18.04 phpMyAdmin without leaving a redirect: Stylised as 'phpMyAdmin'

2018-07-29T17:51:28Z

WikiAdmin moved page Ubuntu 18.04 PHPMyAdmin to Ubuntu 18.04 phpMyAdmin without leaving a redirect: Stylised as 'phpMyAdmin'

← Older revision	Revision as of 17:51, 29 July 2018
(No difference)

WikiAdmin at 17:19, 29 July 2018

2018-07-29T17:19:54Z

← Older revision		Revision as of 17:19, 29 July 2018
Line 20:		Line 20:
	### Select whether you want to remove the 'test' database or not;		### Select whether you want to remove the 'test' database or not;
	### Answer "Y" to reload the privileges;		### Answer "Y" to reload the privileges;

			== MyPHPAdmin ==

			Visit [https://www.phpmyadmin.net/downloads/] and right-click the latest version in '.tar.gz' format and select 'Copy Link Location' (or similar). For example, "phpMyAdmin-4.8.2-english.tar.gz" or other language choice to suit your needs.

			# Open a new terminal and type 'mkdir myphpadmin';
			# Type 'cd myphpadmin';
			# Type 'wget ' and right-click and select 'Paste' (so, "wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-english.tar.gz", as per your chosen download) and press <Enter>;
			# Once downloaded, type 'tar zxvf phpMyAdmin-4.8.2-english.tar.gz'
			# Once extracted, type 'sudo mv phpMyAdmin-4.8.2-english /var/www/html/'
			# Very carefully execute the following command 'sudo chown -R www-data:www-data /var/www/';
			# Type 'cd /var/www/html/';
			# Type 'sudo mv phpMyAdmin-4.8.2-english phpMyAdmin' (or other name of your choosing, to be less obvious on a public website);
			# Open a browser and navigate to your server's IP or DNS name: http://192.168.0.10/phpMyAdmin/

WikiAdmin at 16:51, 29 July 2018

2018-07-29T16:51:03Z

WikiAdmin: Initial creation

2018-07-29T16:50:50Z

Initial creation

Páàjì titun

= Installation Process=

== LAMP Stack ==

The '''Linux Apache MySQL and PHP''' Stack, better known as LAMP, provides all the services for hosting a website using the programming language PHP. Depending on the system, MariaDB might substitute MySQL.

The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.

# In a terminal type 'sudo tasksel' and press <Enter>;
# Navigate down to 'LAMP server' and press <Enter>;
# The 'Installing packages' process will download and install the packages for you;
## On Ubuntu 16.04 you will get prompted for a MySQL 'root' user password;
## On Ubuntu 18.04, once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;
### Answer "Y";
### Select "1" for Medium or "2" for Strong as suits your security needs;
### Enter password and then re-enter to confirm;
### Answer "Y" to password strength (or otherwise specify a new password that matches the security requirements selected);
### Answer "Y" to remote anonymous user accounts;
### Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not;
### Select whether you want to remove the 'test' database or not;
### Answer "Y" to reload the privileges;

[[Category:Ubuntu 18.04 LTS]]

← Older revision		Revision as of 16:51, 29 July 2018
Line 7:		Line 7:
	The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.		The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.

	# In a terminal type 'sudo tasksel' and press <Enter>;		# In a terminal type 'sudo tasksel' and press <Enter>;
	# Navigate down to 'LAMP server' and press <Enter>;		# Navigate down to 'LAMP server' and press <Enter>;
	# The 'Installing packages' process will download and install the packages for you;		# The 'Installing packages' process will download and install the packages for you;
	## On Ubuntu 16.04 you will get prompted for a MySQL 'root' user password;		## On Ubuntu 16.04 you will get prompted for a MySQL 'root' user password;
	## On Ubuntu 18.04, once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;		## On Ubuntu 18.04, once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;
	### Answer "Y";		### Answer "Y";
	### Select "1" for Medium or "2" for Strong as suits your security needs;		### Select "1" for Medium or "2" for Strong as suits your security needs;
	### Enter password and then re-enter to confirm;		### Enter password and then re-enter to confirm;
	### Answer "Y" to password strength (or otherwise specify a new password that matches the security requirements selected);		### Answer "Y" to password strength (or otherwise specify a new password that matches the security requirements selected);
	### Answer "Y" to remote anonymous user accounts;		### Answer "Y" to remote anonymous user accounts;
	### Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not;		### Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not;
	### Select whether you want to remove the 'test' database or not;		### Select whether you want to remove the 'test' database or not;
	### Answer "Y" to reload the privileges;		### Answer "Y" to reload the privileges;