Phpmyadmin - Revision history

Langstonius: /* Using phpMyAdmin */

2011-06-05T16:26:51Z

Using phpMyAdmin

←Older revision		Revision as of 16:26, 5 June 2011
Line 29:		Line 29:

	If your core is accessible to the world:		If your core is accessible to the world:
	*Set a password for the root user - This is not ~~an option~~. ~~Do it, do~~ it ~~now~~.		Im not sure what to do. i tried setting a pass and it borked my system.

Langstonius: /* Using phpMyAdmin */

2011-03-24T20:06:12Z

Using phpMyAdmin

←Older revision		Revision as of 20:06, 24 March 2011
Line 29:		Line 29:

	If your core is accessible to the world:		If your core is accessible to the world:
	*Set a password for the root user OR		*Set a password for the root user - This is not an option. Do it, do it now.
	*Create a new user and set a password

	If your core is not publicly accessible:		If your core is not publicly accessible:

Langstonius: /* Installing and 0810 System */

2011-03-24T20:05:06Z

Installing and 0810 System

←Older revision		Revision as of 20:05, 24 March 2011
Line 4:		Line 4:
	phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.		phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

	==Installing ~~and~~ 0810 System==		==Installing on an 0810 System==
	*Open a shell on the core.		*Open a shell on the core.
	*You will need to run as root to do this, so type:		*You will need to run as root to do this, so type:

Langstonius: /* Using phpMyAdmin */

2011-03-24T20:04:52Z

Using phpMyAdmin

←Older revision		Revision as of 20:04, 24 March 2011
Line 26:		Line 26:

	===Using phpMyAdmin===		===Using phpMyAdmin===
	To use the software, you will need to do one of two things. If your core is accessible to the world~~, then you will need to create~~ a new user and password. ~~This way~~, ~~you do not interfere with~~ the ~~root users privileges and you provide security~~		To use the software, you will need to do one of two things.

			If your core is accessible to the world:
			*Set a password for the root user OR
			*Create a new user and set a password

			If your core is not publicly accessible:
			*You will need to edit /etc/phpmyadmin/config.inc.php
			*Edit the file /etc/phpmyadmin/config.inc.php, search and uncomment (remove the '//' before it) this line:
			// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

			You can now access phpmyadmin.

Langstonius at 20:01, 24 March 2011

2011-03-24T20:01:16Z

←Older revision		Revision as of 20:01, 24 March 2011
Line 1:		Line 1:
	[[Category: Tutorials]]		[[Category: Tutorials]]

			=Overview=
	phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.		phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

	==Installing ~~on your LinuxMCE system~~==		==Installing and 0810 System==
	*Open a shell on the core.		*Open a shell on the core.
	*You will need to run as root to do this, so type:		*You will need to run as root to do this, so type:
Line 10:		Line 11:
	sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin		sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

	==Using phpMyAdmin==		===Using phpMyAdmin===
	After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to:		After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to:
	http://dcerouter/phpmyadmin/		http://dcerouter/phpmyadmin/
	If the name dcerouter is unknown, try replacing it with your core's IP address (usually 192.168.80.1 if you're on the internal network).		If the name dcerouter is unknown, try replacing it with your core's IP address (usually 192.168.80.1 if you're on the internal network).

			==Installing on 10.04==
			The installation process on 10.04 is essentially the same with some minor configuration changes to allow it to run. Please pay attention to your options here.

			*Open a shell on the core.
			*You will need to run as root to do this, so type:
			sudo apt-get install phpmyadmin
			*Once it is completed installing, you will need to create a symlink to access it. Do this by typing:
			sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

			===Using phpMyAdmin===
			To use the software, you will need to do one of two things. If your core is accessible to the world, then you will need to create a new user and password. This way, you do not interfere with the root users privileges and you provide security

Zaerc: added hint on usage + a little cleanup

2008-09-09T15:14:51Z

added hint on usage + a little cleanup

←Older revision		Revision as of 15:14, 9 September 2008
Line 1:		Line 1:
	~~=Installing phpMyAdmin on your LinuxMCE Core=~~		[[Category: Tutorials]]

	~~===~~phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.~~===~~		phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

	=Installing on your LinuxMCE system=		==Installing on your LinuxMCE system==
	*Open a shell on the core.		*Open a shell on the core.
	*You will need to run as root to do this, so type		*You will need to run as root to do this, so type:
	sudo apt-get install phpmyadmin		sudo apt-get install phpmyadmin
	*Once it is completed installing, you will need to create a symlink to access it.		*Once it is completed installing, you will need to create a symlink to access it. Do this by typing:
	*Do this by typing
	sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin		sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

	~~'''This creates~~ your ~~simlink and your on~~ your ~~way!~~'''		==Using phpMyAdmin==
	~~[[Category: Tutorials]]~~		After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to:
			http://dcerouter/phpmyadmin/
			If the name dcerouter is unknown, try replacing it with your core's IP address (usually 192.168.80.1 if you're on the internal network).

Langstonius at 16:11, 21 June 2008

2008-06-21T16:11:27Z

←Older revision		Revision as of 16:11, 21 June 2008
Line 12:		Line 12:

	'''This creates your simlink and your on your way!'''		'''This creates your simlink and your on your way!'''
			[[Category: Tutorials]]

Langstonius: /* phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execut

2008-06-20T04:40:12Z

/* phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execut

←Older revision		Revision as of 04:40, 20 June 2008
Line 1:		Line 1:
	=Installing phpMyAdmin on your LinuxMCE Core=		=Installing phpMyAdmin on your LinuxMCE Core=

	==phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.==		===phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.===


	=Installing on your LinuxMCE system=		=Installing on your LinuxMCE system=

Langstonius at 04:39, 20 June 2008

2008-06-20T04:39:55Z

←Older revision		Revision as of 04:39, 20 June 2008
Line 1:		Line 1:
	=Installing phpMyAdmin on your LinuxMCE Core=		=Installing phpMyAdmin on your LinuxMCE Core=

	===phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.===		==phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.==


	===Installing on your LinuxMCE system===		=Installing on your LinuxMCE system=
	*Open a shell on the core.		*Open a shell on the core.
	*You will need to run as root to do this, so type		*You will need to run as root to do this, so type
Line 12:		Line 12:
	sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin		sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

	~~====~~This creates your simlink and your on your way!~~====~~		'''This creates your simlink and your on your way!'''

Langstonius at 07:47, 22 May 2008

2008-05-22T07:47:42Z

@@ Line 1: / Line 1: @@
-=phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
+=Installing phpMyAdmin on your LinuxMCE Core=
-==
+===phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.===
 This creates your simlink and your on your way!