No, no you are welcome. ;-)
Note that the mysql_install_db script does NOT delete or oeverwrite an
existing mysql privilege database (folder /var/lib/mysql/mysql).
What I am saying is that you have to explicitly delete the folders contents
(if you wish to do so ).
You should also be able to use safe_mysqld --skip-grant-tables to start the
server without any passwords required. This way you can reset your password
for the administrator.
Then restart the server and set your password. Then you should be fine and
safe again ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 10:39、Mario さんは書きました:
> Arigatou, Nirusu-san :)
>
> Mario Luoni
> Tokyo/Japan
>
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > Hi Mario,
> >
> > Try this please:
> >
> > 1) stop the mysql server
> > 2) delete the contents in the folder /var/lib/mysql/mysql
> > 3) run mysql_install_db
> > 4) start the server
> > 5) log in to check that everything is reset
> >
> > 6) set your password
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> > 2003年 7月 4日 金曜日 09:21、Mario さんは書きました:
> > > "Victoria Reznichenko" <[EMAIL PROTECTED]> wrote:
> > > > "Mario" <[EMAIL PROTECTED]> wrote:
> > > > > I'm a newbie in experimental mode and have just deleted /ALL/
>
> databases
>
> > > on a
> > >
> > > > > MySQL server, i.e. including the one ("mysql") that contains all
> > > > > the administrative stuff like users, privileges, etc. Is there some
> > > > > way
>
> to
>
> > > > > recreate some default version of that database short of
> > > > > reinstalling the server? Thx!
> > > >
> > > > Run mysql_install_db script.
> > >
> > > OK, thanks, that helped - once or twice. After some more
>
> "experimenting",
>
> > > unfortunately, all access attempts are now denied. After running
> > > mysql_install_db over and over again (with no error mesages) and
>
> countless
>
> > > attempts to set the password using mysqladmin with all possible
> > > combinations of usernames, passwords, hosts and sockets I can think of
> > > (there are not that many of course), I still cannot connect. So, I'm
> > > now left wondering if there isn't a way to reinitialize the server to
> > > some /well/-defined state from which I can restart building tables???
> > > Thx
> >
> > --
> > ---
> > Valentin Nils
> > Internet Technology
> >
> > E-Mail: [EMAIL PROTECTED]
> > URL: http://www.knowd.co.jp
> > Personal URL: http://www.knowd.co.jp/staff/nils
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
