[thelist] RE: [offlist] Phpmyadmin not showing correct privileges

[fstorr]

Hi Chris

Thanks for the reply.  Yep - I tried doing it all via the command line.
This is what I really don't understand.  I set the privileges, and I can
test them by running different commands that I didn't set ('drop',
'reload' etc) and those tests seem to show that the privileges were set
correctly (ie, I get a 'not allowed' message).  If I check via
phpmyadmin and the command line, privileges that I granted ('select',
'update', 'delete' etc) are all set to 'N'.  Even after reloading.

Arrgh!

For the life me I can't see anything wrong with this:

Grant select, insert, update, delete on jargon.* to jargonadmin
identified by 'password';

But it just does not want to work.  The only way I can get it to work is
by inserting values into the 'user' table of the mysql db, but as I'm
running MySQL4.x version of MySQL, 'grant' should work.

Thanks for the heads up about MySQL control center - I'll check it out.

Regards

F

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org 
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris W. Parker
> Sent: 14 July 2003 20:47
> To: thelist at lists.evolt.org
> Subject: [thelist] RE: [offlist] Phpmyadmin not showing 
> correct privileges
> 
> 
> fstorr <mailto:fffrancis at fstorr.demon.co.uk> wrote:
> 
> Have you tried logging in via the command line and performing 
> the same actions? This can help clarify where the problem 
> lies, either in mysql itself or with phpmyadmin. Have you 
> tried restarting mysql also?
> 
> 
> And...
> 
> This is a little off (this) topic, but you may be interested 
> in not using phpMyAdmin at all and instead using MySQL 
> Control Center (desktop based GUI) available freely from the 
> MySQL website.
> (http://www.mysql.com/products/mysqlcc/index.html)
> 
> I have a very slow machine running MySQL and phpMyAdmin would 
> sometimes take 3-4 minutes to load a query. With MySQL 
> Control Center it is almost instant.
> 
> 
> 
> Chris.
> -- 
> * * Please support the community that supports you.  * * 
http://evolt.org/help_support_evolt/

Evolt.org conference in London, July 25-27 2003.  Register today at
http://evolt.org.uk

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !