DomiNET.net
11-06-2001, 11:09 PM
how to configure phpMyAdmin on a cobalt 4i to make it availabe to all websites hosted on it?
![]() | View Full Version : phpMyAdmin DomiNET.net 11-06-2001, 11:09 PM how to configure phpMyAdmin on a cobalt 4i to make it availabe to all websites hosted on it? smartbackups 11-07-2001, 12:16 AM Basically go to phpwizard.net read the advanced authentication documentation and you will be good to go. There is also a very good tutorial on devshed.com here is an excerpt: Using Advanced Authentication: phpMyAdmin needs a stduser that has only the SELECT privilege on the mysql.user (all columns except "Password"), mysql.db (all columns) & mysql.tables_priv (all columns except "Grantor" & "Timestamp") tables. You must specify the details for the stduser in the config.inc.php3 file under the $cfgServers[n]['stduser'] & $cfgServers[n]['stdpass'] settings. To create the control account (<stduser> and <stdpass> have to be replaced by your own values, of course): GRANT USAGE ON mysql.* TO '<stduser>'@'localhost' IDENTIFIED BY '<stdpass>'; 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 '<stduser>'@'localhost'; GRANT SELECT ON mysql.db TO '<stduser>'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO '<stduser>'@'localhost'; ... and if you want to use the bookmark feature: GRANT SELECT, INSERT, DELETE ON <bookmark_db>.<bookmark_table> TO '<stduser>'@'localhost'; Then each of the true users should be granted of a set of privileges on a set of perticular 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'; What the user may now do is controlled entirely by the MySQL user management system. |