PhpMyAdmin - Revision history

Dpasquazzo: /* Install */

2006-12-08T12:40:16Z

Install

← Older revision		Revision as of 12:40, 8 December 2006
Line 14:		Line 14:
	GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)		GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
	ON mysql.tables_priv TO 'pma'@'<pmahost>';		ON mysql.tables_priv TO 'pma'@'<pmahost>';
	/etc/phpmyadmin/config~~.php~~.inc		/etc/phpmyadmin/config.inc.php
	$cfg['Servers'][$i]['host'] = '<sql_host>'; // MySQL hostname or IP address06 WINDO		$cfg['Servers'][$i]['host'] = '<sql_host>'; // MySQL hostname or IP address06 WINDO
	Add root user connection from <pmahost>		Add root user connection from <pmahost>
	GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';		GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';

	==Troubleshooting==		==Troubleshooting==
	After an update, I could not get the home page anymore, it gave an obscure internal error.		After an update, I could not get the home page anymore, it gave an obscure internal error.

PhilippeTeuwen: /* Install */

2006-12-05T22:19:09Z

Install

← Older revision		Revision as of 22:19, 5 December 2006
Line 18:		Line 18:
	Add root user connection from <pmahost>		Add root user connection from <pmahost>
	GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';		GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';
			==Troubleshooting==
			After an update, I could not get the home page anymore, it gave an obscure internal error.
			<br>Apache2 log said:
			/var/www/phpmyadmin/.htaccess: Option Indexes not allowed here
			This htaccess file is in fact, via symlinks, /etc/phpmyadmin/htaccess
			<br>Commenting out the following line solved the problem.
			Options +FollowSymLinks -Indexes

PhilippeTeuwen at 17:26, 17 November 2006

2006-11-17T17:26:27Z

New page

==Install==
apt-get install phpmyadmin
cf http://www.phpmyadmin.net/documentation/
GRANT USAGE ON mysql.* TO 'pma'@'<pmahost>' IDENTIFIED BY '<pmapass>';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'<pmahost>';
GRANT SELECT ON mysql.db TO 'pma'@'<pmahost>';
GRANT SELECT ON mysql.host TO 'pma'@'<pmahost>';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'<pmahost>';
/etc/phpmyadmin/config.php.inc
$cfg['Servers'][$i]['host'] = '<sql_host>'; // MySQL hostname or IP address06 WINDO
Add root user connection from <pmahost>
GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';