[thelist] Please help me kill MySQL on my iBook (before it kills me)

[Rich Gray]

Mark

2 things to try...

You can re-start the server telling it to skip using the grant tables - this
should allow access to all tables which should allow you to reset the root
password...

--skip-grant-tables

Also you can  re-create the default grant tables by deleteing some files and
running mysql_install_db script again... check the manual for how to achieve
this.

HTH
Rich
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Mark Howells
Sent: 09 September 2002 13:37
To: thelist at lists.evolt.org
Subject: Re: [thelist] Please help me kill MySQL on my iBook (before it
kills me)


> Was this a DIY compile
> of MySQL or did you grab a package from somewhere like entropy.ch?

I used the setup instructions at entropy.ch

> 1: Has Mysql worked properly before this, or have you never been
> able to get in?

It worked on first install, but I've buggered it up since changing the
user rights.

> 2: Have you run 'mysql_install_db' since installing? This script sets
> up
> the baseline privs for mysql and can also be used to go back to a clean
> setup (with a little tweaking)

I've run it since the original problems started, but it doesn't reset
all the users and priviledges.

> 3: Have you tried logging in as root without the '-p' flag?

Yes, Access Denied

> 4: How about as 'root@<machinename>' instaed of just 'root' or
> 'root at localhost'?

Access Denied.

Thanks and regards
Mark Howells
<http://www.mark.ac/>
AIM: mhoaim

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !