> Peter,
> Actually,
>
> Mysql -uUSERNAME -pPASSWORD works just fine.
>
> Donny
And `mysql -u root -p somepassword` will not work. With the space between
-p and "somepassword", mysql will attempt to interpret "somepassword" as the
name of a database.
As to the original question, the problem app
Peter,
Actually,
Mysql -uUSERNAME -pPASSWORD works just fine.
Donny
> -Original Message-
> From: Sunmaia [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 31, 2004 7:44 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Root users permissions not working
>
>
hi
this may be the problem or it may just be a typo!
you are showing
#mysql -u root -psomepassword
which should be
#mysql -u root -p somepassword
(note the space after -p)
the first will not pass the password, which would explain the lack of
privileges.
Otherwise start with skip-grant-tables
