Recreate mysql

2003-07-03 Thread Mario
Hi! 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

Re: Recreate mysql

2003-07-03 Thread Victoria Reznichenko
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

Re: Recreate mysql

2003-07-03 Thread 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,

Re: Recreate mysql

2003-07-03 Thread Peter K Aganyo
Mario wrote: "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

Re: Recreate mysql

2003-07-03 Thread Nils Valentin
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:21Mario :

Re: Recreate mysql

2003-07-03 Thread Nils Valentin
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