https://www.webmaster-forums.net/crss/node/1018911 en https://www.webmaster-forums.net/server-side-scripting/can-only-create-one-database-phpmyadmin#comment-1111836 <p>My install, with root mySQL priveleges (root is prefered)<br /> <div class="codeblock"><code>// stduser is a mysql user with SELECT access to only<br />// the `user` and `db` tables in the `mysql` database<br />$cfgServers[1][&#039;controluser&#039;]&nbsp;&nbsp; = &#039;stduser&#039;;<br />$cfgServers[1][&#039;controlpass&#039;]&nbsp;&nbsp; = &#039;shhh&#039;;<br /><br />$cfgServers[1][&#039;auth_type&#039;]&nbsp;&nbsp;&nbsp;&nbsp; = &#039;http&#039;;<br /><br />// leave this empty!<br />$cfgServers[1][&#039;only_db&#039;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &#039;&#039;;</code></div>'<br /> Another install, without root...<br /> <div class="codeblock"><code>$cfgServers[1][&#039;auth_type&#039;]&nbsp;&nbsp;&nbsp;&nbsp; = &#039;config&#039;;<br /><br />$cfgServers[1][&#039;user&#039;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &#039;my_user&#039;;<br />$cfgServers[1][&#039;password&#039;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &#039;my_pass&#039;;<br /><br />$cfgServers[1][&#039;only_db&#039;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &#039;&#039;;</code></div>'With the second setup, you need to protect the directory with .htaccess.</p> Thu, 25 Jul 2002 06:09:02 +0000 Mark Hensler comment 1111836 at https://www.webmaster-forums.net