[Gllug] [OT] MySQL experts?

[John Hearns]

Are there any MySQL experts on the list please?
Continuing my LANdb saga, I'm unable to set up the
users it needs properly - which are superuser and admin.
The install script SHOULD do this, but seems to screw up
for me.

I'm adding a user by hand, using:

GRANT DROP, CREATE, INSERT, UPDATE, DELETE, SELECT, USAGE, ALTER on
nis1.* to superuser@"%" identified by 'blargh';


Then FLUSH PRIVILEGES; and exit and  mysqladmin reload  
just to be sure.

But then
mysqlaccess localhost superuser nis1 
says that superuser has no password

And trying to set the password manually by
 mysqladmin -u  superuser password blargh
comes back to me and says that 'you are using MySQL as an
anonymous user'

But superuser is in the mysql.user table.
I'm lost...

Guess I really should take this to the MySQL lists.
But if a passing guru can help me please...


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug