LinuxSA Mailing list archives

  From: John Edwards <isplist@pinnacle.net.au>
  To  : Bordeaux Stan <stan.bordeaux@dchs.tas.gov.au>
  Date: Wed, 31 Jan 2001 09:17:21 +1030

Re: mysql problem

Bordeaux Stan wrote:
> 
>         Hmmm and a double hmmm.  After, trying to dechiper the documentation
> re granting access rights for MYSQL I seem to have stuffed up the password
> option even for root.  Now its seems even root has lost access (without the
> appropriate password).  Unfortunately, after many hours and cups of coffee
> (or was that cheap cask red wine) I think I entered some commands
> incorrectly and now, nutting?  I've tried all combinations of commands that
> I did with the password (I know, I know I should have stayed away from this)
> but can't get root on (this sounds vaguely crude).

Start Mysql with:

mysqld --skip-grant-tables

This will make it run without the permissions system, so you can change
the root password.

When changing passwords with sql statements, remember to use the
PASSWORD() function, otherwise the passwords are kept in plain text,
which newer versions of mysql will refuse to authenticate with (which is
probably your problem).

John Edwards

-- 
LinuxSA WWW: http://www.linuxsa.org.au/  IRC: #linuxsa on irc.linux.org.au
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject