<div dir="ltr">On Mon, Aug 4, 2008 at 11:42 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;">
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>
</blockquote></div><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 be stored as plain text in one of the phpmysqladmin configuration files. Once you have the name, you can adjust it's access rights.<br>
<br>As I recall, you can adjust access rights using the GRANT SQL statement or by updating the administrative tables in the database named mysql. If you connect to the mysql database, a "show tables" command at the interactive 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 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 examples here:<br>
<a href="http://dev.mysql.com/doc/refman/6.0/en/grant.html">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 grant access to a user from any host, the "%" is used. For example, to let 'somebody' do anything/everything to any database/table from anywhere, the root database user could execute:<br>
<br>grant all on *.* to 'somebody'@'%';<br><br>(NOT that I'm advocating such a policy!)<br><br>Good luck and have fun!<br><br>Andrew Gould<br><br></div>