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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
