==================================================================
Please DO NOT REPLY to this mail or send email to the developers
about this bug. Please follow-up to Bugzilla using this link:
http://bugs.contribs.org/show_bug.cgi?id=7153
Have you checked the Frequently Asked Questions (FAQ)?
http://wiki.contribs.org/SME_Server:Documentation:FAQ
Please also take the time to read the following useful guide:
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
==================================================================
Priority: P3
Bug ID: 7153
Assignee: [email protected]
Summary: phpMyAdmin Advanced configuration notes
QA Contact: [email protected]
Severity: normal
Classification: Contribs
OS: ---
Reporter: [email protected]
Hardware: ---
Status: UNCONFIRMED
Version: 8.0
Component: smeserver-phpmyadmin
Product: SME Contribs
Just updated to the SME8 version of phpMyAdmin
I noticed that the advanced configuration needed sorting and decided to try and
fix it.
This took a bit of doing, and could do with a modified template system to allow
for it.
Anyway, my notes
Once installed get a copy of :
/usr/share/phpMyAdmin/examples/create_tables.sql
(The database name will be phpmyadmin so change it if need be)
Import this with phpMyAdmin
Next run the following SQL statements :
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'your_password';
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'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';
In phpMyAdmin I then changed the password for the pma user to something more
robust.
I next had to find a way to add the advanced config to the config.inc.php file
I copied the 10config file to :
/etc/e-smith/templates-custom/etc/phpMyAdmin/config.inc.php
I removed the ?> from the end of the file and added it to template-end
I then created 20extra with the following entries :
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'my_new_password';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] ='pma_table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
A post-upgrade, reboot and all was well.
Hope that makes sense - please ask if I can help.
I am happy to add this to the wiki if required though I am sure that there are
some things I have done here that could be done better.
B. Rgds
John
PS - should the bugzilla component description be changed ???
--
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at http://lists.contribs.org/mailman/public/contribteam/
