The .err file contains these messages:

100605 14:27:02 [Note] Plugin 'FEDERATED' is disabled.
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table
'mysql.plugin' doesn't exist
100605 14:27:02 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
100605 14:27:02 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the
doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
100605 14:27:03 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100605 14:27:03 InnoDB: Started; log sequence number 0 44233
100605 14:27:03 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
-------------------------------------------------------------

Does anyone have any suggestions for getting around this problem? A
number of posts that I read suggest that the Data path in my.ini file
may be incorrect, but it is correct and that folder contains these
files: ib_logfile0, ib_logfile1, ibdata1, inndb_status.1092

Are these the correct files for this folder? Is any file missing
that should be there?

When I attempt to run mySql_Upgrade, it gives me an error that the
server is not running, which is sort of a Catch-22 situation.

Help!

J

Joe <delphi562 (AT) cox (DOT) net> wrote:
<cut>

The `mysql` system database is missing.

There should be a subdirectory 'mysql' and in it several files like
'host.frm', 'host.MYD', 'host.MYI' (those are for the mentioned
'mysql.host' table) and several more.

Also the messages about InnoDB recovery suggest that there is actually
data in the InnoDB tablespace (the ibdata1 file). But then there should
also be some subdirectories for databases, containing the .frm files
for the InnoDB tables.

Has this server ever run? If yes, then there should be a valid datadir
somewhere and the 'datadir' variable in my.ini should point to it.
The InnoDB files are by default located in the datadir, but can be
relocated quite freely. Seeing the ibdata1 file in some dir is not a
valid proof that this is the datadir. The default datadir on Windoze
is $installdir/data

If you cannot find an old (and usable) datadir, then mysql_install_db
can be used to populate an empty datadir with defaults. All user data
will be gone after that.


XL

On Sat, 05 Jun 2010 14:34:50 -0700, Joe wrote:


www.ubuntu.org
www.linuxmint.com

Thank you for the response.

To answer your question, no - the MySQL server has never run before on
this machine. I am installing it and attempting to run it for the
first time. I downloaded the Windows installation package and ran
it, but apparently that does not create the MySQL system database, as
I would have expected.

I will search for the mysql_install_db program that you mentioned and
see if that creates the necessary files.

Can you recommend any good books on MySQL? because I obviously need
help.....

J

Joe <delphi562 (AT) cox (DOT) net> wrote:
I guess you meant to reply to me...

It does so when you run the "Instance Configuration Wizard". Maybe you
downloaded the no-install package? The .msi package suggests to run
that wizard right after the installation.

I just checked my Windoze testbed. This program does not exist in the
Windoze port (but all UN*X ports). I guess this functionality is all
bundled in the mentioned wizard (MySQLInstanceConfig.exe)

The manual? http://dev.mysql.com/doc/
There is also a tutorial included...


XL

Greetings,
My solution to your problem is:
1- Run MySQL Configuration Wizzard.
2- Choose to remove any previous configuration.
3- Restart your MySQL service.
4- Use XAMPP to access your MySQL Database with user "root" and passwrd "" (empty).
Consider getting a place online to host your MySQL database as I did.
First just for a proof of concept, but now I'm running a business site after some try/error issues.
Signup Now with Instant Activation -
http://www.000webhost.com/420083.html