User Privilege Issues

[Jonny Holt]

Hi,

I seem to be having a few issues with, MySQL Administrator and assigning privileges to users.

I am running:

Vista
MySQL Community 5.0.8
MySQL Administrator 1.2.17

I am also using Toad for MySQL

When using MySQL Administrator it appears that the after assigning privileges, and applying changes, none are activated on the user table which I can view using Toad?? If i grant privileges using toad then this works fine, but if I then modify again using MySQL Administrator then it removes them all again.

I have also had issues of it th eother way round, i.e. privileges are granted, removed with MySQL Administrator, but not actually removed on the user table??

Is anyone else experiencing any issues like this, or just me??

I am competent in SQL, used MSSQL Server alot, but relativly new to MySQL.

Thanks in advance

Jonny



Edited 1 time(s). Last edit at 11/26/2009 10:04AM by Jonny Holt.