Re: MySQL server won't start (Apple OS)

[Mike Levin]

ok so after a bit of reading on-line, I tried this:

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> select user(),current_user();
+--------+----------------+
| user() | current_user() |
+--------+----------------+
| root@ | @ |
+--------+----------------+
1 row in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* to 'root'@'localhost' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION
-> ;
Query OK, 0 rows affected (0.00 sec)

which looks like there's a root user here after all, and now I'm able to log in! But the MailStewardPro is telling me the database is empty. How do I figure out what happened - could the data still be there and just "disconnected" somehow (the server doesn't see the database or the file or something)? I had a huge (~300 GB) database - what do I do to see if it's still there somewhere and just not being seen?