phpMyAdmin 2.6.1-rc1 cant create database

[Matthew Seaman]

Noah wrote:
> 
> phpMyAdmin 2.6.1-rc1
> freeBSD-4.9
> 
> phpMyAdmin claims that there are no priviledges to create a database even as
> root.  how do I fix this?

All phpMyAdmin is doing is reporting what MySQL tells it.  If you used 
the mysql(1) command line interface from that account, you'll see 
exactly the same problem.

You need to check the privilege settings within mysql to enable that 
capability -- note that the capabilities functionality has been revised 
and extended in recent MySQL releases so it's entirely possible that 
even if you started out with root at yourhostname with ALL PRIVILEGES, 
after a few upgrades,  that account might be lacking a few new 
privileges nowadays.

	Cheers,

	Matthew


-- 
Dr Matthew J Seaman MA, D.Phil.                       8 Dane Court Manor
                                                       School Rd
PGP: http://www.infracaninophile.co.uk/pgpkey         Tilmanstone
Tel: +44 1304 617253                                  Kent, CT14 0JL UK
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 372 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20041221/82b44b3f/signature.bin