<div dir="ltr">On Tue, Aug 5, 2008 at 5:44 AM, David A. Bandel <span dir="ltr"><<a href="mailto:david.bandel@gmail.com">david.bandel@gmail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Mon, Aug 4, 2008 at 12:56 PM, Andrew Gould <<a href="mailto:andrewlylegould@gmail.com">andrewlylegould@gmail.com</a>> wrote:<br>
> On Mon, Aug 4, 2008 at 11:42 AM, David A. Bandel <<a href="mailto:david.bandel@gmail.com">david.bandel@gmail.com</a>><br>
> wrote:<br>
>><br>
>> Folks,<br>
>><br>
>> Hope someone here knows the POS mysql well enough to help.<br>
>><br>
>> A client has some databases. These can be accessed from the command<br>
>> line. But connecting w/ phpmyadmin shows only a couple of the<br>
>> databases. This must be a privileges problem, but I don't know enough<br>
>> about mysql to solve it.<br>
>><br>
>> Any suggestions welcome (short of dumping all the databases and<br>
>> importing them to postgresql -- that's my next step).<br>
>><br>
>> TIA,<br>
>><br>
>> David A. Bandel<br>
><br>
> You're "next step" doesn't sound so bad to me. ;-)<br>
><br>
> As for MySQL, it's been awhile, but.....<br>
><br>
> Can you determine the username used by phpmysqladmin? The username used to<br>
> be stored as plain text in one of the phpmysqladmin configuration files.<br>
> Once you have the name, you can adjust it's access rights.<br>
<br>
</div>www-data@localhost<br>
<br>
granted permissions on one database via:<br>
grant all on dbname.* to 'www-data'@'localhost';<br>
<br>
query OK, no rows affected. However, still don't see that database.<br>
<br>
I just can't seem to wrap my head around how php and phpmyadmin decide<br>
which databases will show up in the list of databases. I still only<br>
see 2 of 68.<br>
<div class="Ih2E3d"><br>
><br>
> As I recall, you can adjust access rights using the GRANT SQL statement or<br>
> by updating the administrative tables in the database named mysql. If you<br>
> connect to the mysql database, a "show tables" command at the interactive<br>
> prompt should be helpful in finding the correct administrative table.<br>
><br>
> There is also a "show databases" command; but I assume you already know the<br>
> name of the database since you can see it from the command line.<br>
><br>
> The MySQL version of GRANT allows for the use of wildcards. You can find<br>
> examples here:<br>
> <a href="http://dev.mysql.com/doc/refman/6.0/en/grant.html" target="_blank">http://dev.mysql.com/doc/refman/6.0/en/grant.html</a><br>
><br>
> Note that for database and table names, you can use the wildcard "*"; but to<br>
> grant access to a user from any host, the "%" is used. For example, to let<br>
> 'somebody' do anything/everything to any database/table from anywhere, the<br>
> root database user could execute:<br>
><br>
> grant all on *.* to 'somebody'@'%';<br>
><br>
> (NOT that I'm advocating such a policy!)<br>
<br>
</div>why not? these idiots still have root w/ no password as the administrator.<br>
<br>
That's when all this fun started. I found them being used as a<br>
phishing site (thanx to PHP and their configuration w/ safe_mode =<br>
off).<br>
<br>
<br>
Ciao,<br>
<div><div></div><div class="Wj3C7c"><br>
David A. Bandel<br>
</div></div></blockquote><div><br><br>I wonder if there's a configuration option to identify viewable databases, aside from permissions.<br></div></div><br>Andrew<br></div>