Mysql woes

[Andrew Gould]

On Mon, Aug 4, 2008 at 11:42 AM, David A. Bandel <david.bandel at gmail.com>wrote:

> Folks,
>
> Hope someone here knows the POS mysql well enough to help.
>
> A client has some databases.  These can be accessed from the command
> line.  But connecting w/ phpmyadmin shows only a couple of the
> databases.  This must be a privileges problem, but I don't know enough
> about mysql to solve it.
>
> Any suggestions welcome (short of dumping all the databases and
> importing them to postgresql -- that's my next step).
>
> TIA,
>
> David A. Bandel
>

You're "next step" doesn't sound so bad to me.   ;-)

As for MySQL, it's been awhile, but.....

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.

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.

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.

The MySQL version of GRANT allows for the use of wildcards.  You can find
examples here:
http://dev.mysql.com/doc/refman/6.0/en/grant.html

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:

grant all on *.* to 'somebody'@'%';

(NOT that I'm advocating such a policy!)

Good luck and have fun!

Andrew Gould
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/linux-users/attachments/20080804/25759001/attachment-0002.html