phpMyAdmin problem - no Edit/Delete on Browse

[Matthew Seaman]

Ian Smith wrote:
> (originally posted to -database some days ago .. no nibbles)
> 
> running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r
> (after finding installing from ports wanted to also fetch php4 sources
> and heaps of other stuff I already had installed from packages on the
> 2-CD set).  I'd managed to find and install 5.4-R mysql packages also:
> 
>  smithi on paqi% pkg_info | grep -i "php\|mysql"
>  libmcrypt-2.5.7_1   Multi-cipher cryptographic library (used in PHP)
>  mysql-client-4.1.10a Multithreaded SQL database (client)
>  mysql-server-4.1.10a Multithreaded SQL database (server)
>  php4-4.3.10_2       PHP Scripting Language (Apache Module and CLI)
>  php4-bz2-4.3.10_2   The bz2 shared extension for php
>  php4-gd-4.3.10_2    The gd shared extension for php
>  php4-mbstring-4.3.10_2 The mbstring shared extension for php
>  php4-mcrypt-4.3.10_2 The mcrypt shared extension for php
>  php4-mysql-4.3.10_2 The mysql shared extension for php
>  php4-openssl-4.3.10_2 The openssl shared extension for php
>  php4-pcre-4.3.10_2  The pcre shared extension for php
>  php4-zlib-4.3.10_2  The zlib shared extension for php
>  phpMyAdmin-2.6.1.3  A set of PHP-scripts to manage MySQL over the web
> 
> phpmyadmin basically works fine.  I'd imported my databases from dumps,
> and all looked good after a bit of configuration.  However when starting
> to do some real work on a couple of databases, I noticed that while
> browsing any database, the Edit and Delete options do not appear with
> each row, ie I can not update existing records (even as -u root)
> 
> I'd suspected permissions, but I can insert new records, add/drop/empty
> tables and databases, bookmark queries and all.  The permissions and
> ownership of and in /var/db/mysql are the same as my old 4.5-R system.
> 
> $cfg['ModifyDeleteAtLeft'] = TRUE; I've also tried adding ...AtRight as
> well, but neither show up.  If relevant, I'm using apache-1.3.33_1 and 
> mozilla-1.7.7,2 .. all of this is just running on the local machine, so
> I'm not at the moment concerned with just security-issue updates.
> 
> I haven't been able to find anything in later version change notes or
> PRs indicating anything like this problem, and updating to the current
> port would require updating php, mysql, expat and even xorg versions,
> which is just not doable over a 28.8k modem connection I'm afraid, so
> the 'usual' answer of cvsuping and updating everything is not helpful;
> in any case I suspect this is more likely a maybe subtle config issue?

What is the UID *within* MySQL you are using to connect with?  Does
running:

    SHOW GRANTS FOR `user`@`hostname` ;

make things any clearer?

phpMyAdmin is clever enough to modify its user interface according to what
the user has permission to do to the database.  The user name use within the
database depends on how you've configured phpMyAdmin -- I generally like to
use 'cookie' mode authentication where the username and password are passed
straight through to MySQL from the login dialog, but the 'config' mode given
in the example config files requires you to put the username and password
directly in the phpMyAdmin configuration file. 

	Cheers,

	Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.                       7 Priory Courtyard
                                                      Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey         Ramsgate
                                                      Kent, CT11 9PW

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060528/d938bc34/signature.pgp