Re: Multi-User phpMyAdmin

on 2/7/03 3:35 PM, Stephen at webmaster@melchior.us wrote: > Can anyone tell me a tutorial on how to setup a multi-user phpmyadmin > installation? I would like to just have one central copy, then have other > users able to access their corresponding database in phpMyAdmin. How can I > do this? It is on the phpmyadmin documentation page and it looks something like this... --snip-- This example assumes you want to use pma as the controluser and pmapass as the controlpass, but this is only an example: use something else in your file:     GRANT USAGE ON mysql.* TO 'pma'@'localhost' 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) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost'; ... and if you want to use the many new relation and bookmark features:     GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db> TO 'pma'@'localhost'; (this of course requires you to have a special DB for phpMyAdmin, the contents will be explained later) * Then each of the true users should be granted of a set of privileges on a set of particular databases but shouldn't have any global privileges. For example, to grant the user real_user with all privileges on the database user_base:    GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password'; --snip-- -- Mike Yrabedra President 323 Enterprises Home of The MacDock and The MacSurfshop [http://macdock.com] : [http://macsurfshop.com] VOICE: 770.382.1195 iChat/AIM: ichatmacdock _______________________________________________________________________ "in all your ways acknowledge Him and He will direct your paths." Proverbs 3:6 NIV <{{{>< --