[rt-users] Help - MySQL Problems

[David C. Troy]

Derek -- couple of thoughts.

Have you tried mysqladmin --password (I think)?

Also, all of the mysql perms are derived from the 'mysql' database and the
user, db, hosts tables.

What I would do is do a fresh mysql install on another machine and:

1. mv existing /var/lib/mysql/mysql to /var/lib/mysql/mysql.bak
2. copy the virgin /var/lib/mysql/mysql directory to your old install
3. restart mysql (to reset perms)

Give this ia shot...

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-544-6193 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net

On Sat, 22 Sep 2001, Derek Fage wrote:

> Hi there,
>
> I know this is a bit off-topic, but I tried joining the lists.mysql.com and
> posting there and it appears to be off the air at the moment.
>
> I thought I'd try this list (as it's my rt2 mysql database that is
> affected).
>
> I was trying to modify webmin to enable me to use it to manage mysql and I
> think I might have modified the root password.
>
> I've now spent about 3 hours trawling through the archives and trying all
> sorts of things, but whatever I do I cannot get into mysql as root (I've
> attached sample errors at the end).
>
> I'm currently running with --skip-grant-tables, but I still cannot access
> mysql
>
> I'd _really_ appreciate some help here as it's a lovely Saturday afternoon
> at 15:45 here, and I don't want to be here!
>
> Many thanks in advance to whoever can shed some light on these problems,
>
> Regards,
>
> Derek...
>
>
> ***************************************************************************************
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of Foreshore Limited.
>
> This e-mail is intended only for the individual or entity to which it is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to hostmaster at foreshore.net
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>