[TriLUG] hello and mysql help please

[jason watts]

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/