[Gllug] [OT] MySQL experts?

[Paul Brazier]

> 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...

Is there an entry in the password field for superuser in the mysql.user
table? It should be there in encrypted form.

I wonder if it's stopping you typing the password in plain text on the
commandline or something?
I vaguely remember having to do "mysql -u paul -p" and then entering the
password from a prompt.

Just some ideas...

Paul.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the originator.

This footnote also confirms that this email message has been checked
for the presence of computer viruses.

**********************************************************************


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