Hey All,
I've just spent the last few hours beating my head against a wall trying to get the ISP-style Central Copy feature working in phpMyAdmin. And here is the few things they forgot to mention in Documentation->FAQ (<!-- m --><a class="postlink" href="http://phpwizard.net/projects/phpMyAdmin/documentation.html">http://phpwizard.net/projects/phpMyAdmi ... ation.html</a><!-- m -->)...
Firstly... it seems to relay on you configuring your webserver to prompt the user for a username/password. That username/password combo has to match the entry for the user in your MySQL æˆysql.user?and æˆysql.db?tables. For testing, this functionality can be circumvented by adding the following lines just above "if($cfgServer['adv_auth'])"
(which is on approx. line 132 in ver 2.1.0) in "lib.inc.php":
$PHP_AUTH_USER = "username";
$PHP_AUTH_PW = "password";
...of course you should replace "username" and "password" with the information for your user (duh). Also remember to either comment out these lines or remove them before you put the site into use (as every user will be logged in as the username and password you specify).
Secondly... changes you make to the æˆysql.users?and æˆysql.db?tables are not put into effect until you either restart your MySQL Server or you run the "FLUSH PRIVILEGES" statement in one of the SQL textareas. This alone pissed me off to no end, this is really a feature that should be added to phpMyAdmin when a record is added any record added to the æˆysql?system database!!!
Anyway?if you use these two additional notes in conjunction to the information provided at the bottom of the FAQ at <!-- m --><a class="postlink" href="http://phpwizard.net/projects/phpMyAdmin/documentation.html">http://phpwizard.net/projects/phpMyAdmi ... ation.html</a><!-- m -->, you should be able to get it working! If not, feel free to e-mail me and I抣l try to help you thru it (as I too may have forgotten a little detail or two =).
I've just spent the last few hours beating my head against a wall trying to get the ISP-style Central Copy feature working in phpMyAdmin. And here is the few things they forgot to mention in Documentation->FAQ (<!-- m --><a class="postlink" href="http://phpwizard.net/projects/phpMyAdmin/documentation.html">http://phpwizard.net/projects/phpMyAdmi ... ation.html</a><!-- m -->)...
Firstly... it seems to relay on you configuring your webserver to prompt the user for a username/password. That username/password combo has to match the entry for the user in your MySQL æˆysql.user?and æˆysql.db?tables. For testing, this functionality can be circumvented by adding the following lines just above "if($cfgServer['adv_auth'])"
(which is on approx. line 132 in ver 2.1.0) in "lib.inc.php":
$PHP_AUTH_USER = "username";
$PHP_AUTH_PW = "password";
...of course you should replace "username" and "password" with the information for your user (duh). Also remember to either comment out these lines or remove them before you put the site into use (as every user will be logged in as the username and password you specify).
Secondly... changes you make to the æˆysql.users?and æˆysql.db?tables are not put into effect until you either restart your MySQL Server or you run the "FLUSH PRIVILEGES" statement in one of the SQL textareas. This alone pissed me off to no end, this is really a feature that should be added to phpMyAdmin when a record is added any record added to the æˆysql?system database!!!
Anyway?if you use these two additional notes in conjunction to the information provided at the bottom of the FAQ at <!-- m --><a class="postlink" href="http://phpwizard.net/projects/phpMyAdmin/documentation.html">http://phpwizard.net/projects/phpMyAdmi ... ation.html</a><!-- m -->, you should be able to get it working! If not, feel free to e-mail me and I抣l try to help you thru it (as I too may have forgotten a little detail or two =).