Help - MySQL Problems

Derek_Fage · September 22, 2001, 2:42pm

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@foreshore.net

David_C_Troy · September 22, 2001, 2:51pm

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:

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

Give this ia shot…

Dave

David C. Troy [dave@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.netOn 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@foreshore.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Derek_Fage · September 22, 2001, 3:39pm

David,

Thanks for your help.

It turned out that passing the -skip-grant-tables option to
/etc/init.d/mysql.server start did not pass this through when it started
mysql.

I made a copy of mysql.server that added the option and then I could go in
to mysql and reset the users password.