i apreciate the help
i ran a search on the hd, and found the db directory, no idea were it was, i
saw it and hit delete. it seems so far i am back to complete default
settings. i went back to the start of the mysql install in my howto's and
have worked my way up to adding back the users... after i run the command
"select * from user;" i end up with 3 users, root, snort, and base... in
instructions say i should have four, root, snort, root, base... i didnt
think you could have 2 root users... didnt think you would be able to have
two user's in general with the same name... oh well, im thinking and hopeing
its just a typo
thanks for the help
and just so i know, what does the f stand for in the command you mentioned
"rm -rf /var/lib/mysql/mysql/" i know the r stands for recursivly (right?)
jsn
In short, the simplest most fool-proof method would be to uninstall
mysql and remove the "mysql" database. This has tables like "user",
"db", etc. which contain the login information that control who can do
what with the databases. Removing the 'mysql' database and then
reinstalling should get you a fresh / default copy. On a Linux box I
could tell you that the files associated with the database live in
/var/lib/mysql/mysql/, and that running your distro's package remove
command (rpm -e mysql-server || dpkg -P mysql-server-<ver>) and them
blowing away that directory via `rm -rf /var/lib/mysql/mysql/` followed
by a fresh reinstall of the package would do nicely. As for translating
that into windows... unfortunately, I don't do that anymore. :)
Best of luck,
Aaron S. Joyner
--
TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ : http://trilug.org/faq/
TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
--
TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ : http://trilug.org/faq/
TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
