Re: can't run mysqld after installing from zip archive on windows vista ( Table 'mysql.plugin' doesn't exist / Can't open and lock privilege

[Umesh Shastry]

Try this way

cd to c:/tmp/mysql/mysql-5.1.39-win32/bin

and invoked the command:(leave the window open as it is)

mysqld --defaults-file=../my.ini

orelse.. you can create the service and then go for NET START MySQL instead
of each time running above commands
# need to provide abs path for my.ini

mysqld --defaults-file=../my.ini --install
On Thu, Oct 15, 2009 at 11:22 AM, spam bin <spambin@stripped> wrote:

> Hi, I was unable to install and run mysql on windows vista using the
> installation
> from zip method described here:
>    http://dev.mysql.com/doc/refman/5.1/en/windows-install-archive.html
>
>
> I downloaded the zip archive for mysql-5.1.39-win32, then I extracted it
> to:
>
>    c:/tmp/mysql/mysql-5.1.39-win32
>
>
> I did a mkdir c:/tmp/mysql/data
>
>
> Then I created a  my.ini in c:/tmp/mysql/mysql-5.1.39-win32
> as described here:
>    http://dev.mysql.com/doc/refman/5.1/en/windows-create-option-file.html
>
>
> The contents of the my.ini file i created are:
>
> [mysqld]
> # set basedir to your installation path
> basedir=c:/tmp/mysql/mysql-5.1.39-win32
> # set datadir to the location of your data directory
> datadir=c:/tmp/mysql/data
>
>
>
> I then did a cd to c:/tmp/mysql/mysql-5.1.39-win32/bin
>
> and invoked the command:
>
>        ./mysqld --console
>
> I received the error output below (see ERROR OUTPUT), and am wondering what
> might have gone wrong ?
> Any advice most appreciated !
>
>
> Chris Bedford
> --------------
> Founder & Lead Lackey
> Build Lackey Labs
> http://buildlackey.com
>
>
>
> ERROR OUTPUT
>
>
>
> CBEDFORD@Owner-PC: /tmp/mysql/mysql-5.1.39-win32/bin > ./mysqld --console
> 091014 22:43:37 [Note] Plugin 'FEDERATED' is disabled.
> c:\tmp\mysql\mysql-5.1.39-win32\bin\mysqld.exe: Table 'mysql.plugin'
> doesn't
> exist
> 091014 22:43:37 [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
> 091014 22:43:37  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
> 091014 22:43:37  InnoDB: Starting an apply batch of log records to the
> database...
> InnoDB: Progress in percents: 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
> 091014 22:43:38  InnoDB: Started; log sequence number 0 44233
> 091014 22:43:38 [ERROR] Fatal error: Can't open and lock privilege tables:
> Table 'mysql.host' doesn't exist
>



-- 
Thanks,
Umesh