Hmm,
if I look at user accounts, there is only ONE account created, that is
mine, and account type is ADMINISTRATOR.
But, as I said, it is not as with Windows 2000, where you could set
SECURITY for each folder and file - I do not have this option on my
WinXP PRO. And this is kind of weird...
-::::::::::::::::::::::::::-
> Is it possible, you don't have admin privileges on your machine?
>> -----Original Message-----
>> From: labsy@stripped [mailto:labsy@stripped]
>> Sent: Tuesday, January 20, 2004 1:08 AM
>> To: win32@stripped
>> Subject: Re[5]: Instalation: FATAL ERROR
>>
>> Elou Randy,
>>
>> I changed install partition, thinking that might help. So I edited
>> my.ini file to match the c: drive:
>>
>> [mysqld]
>> basedir=c:/mysql
>> datadir=c:/mysql/data/mysql
>>
>> I also scanned C: and D: disk for my.cnf file - but there is no such
>> file on my machine, I deleted all of them.
>>
>> But I still get the same error... :((
>>
>> Might it be because of weird privileges settings on my
>> machine? I have NTFS partitions, but I cannot find any
>> SECURITY tabs anywhere?! If I click on folder properties,
>> there is no option where I could set access privileges for a
>> folder or file.
>> But, since MYSQLD created all these databases with no
>> problem, I hope there is no problem with privileges settings.
>>
>>
>> -::::::::::::::::::::::::::-
>>
>> > All the proper files exist in c:\mysql\data\mysql, but your my.ini
>> > points to d:\mysql\data\mysql. Check both your
>> c:\windows\my.ini and c:\my.cnf.
>>
>> > BTW, on a windows machine, my.cnf will appear to be file type
>> > SpeedDial. The icon will indicate that it is a shortcut.
>> Use notepad
>> > to open the file. It should be a plain text file
>>
>> > Randy
>>
>> > At 12:31 AM 01/20/2004 +0100, you wrote:
>> >>Elou Armin,
>> >>
>> >> I re-installed MySQL, started IIS, and then again
>> >>
>> >> mysqld --console
>> >>
>> >> "Fatal error: Can't open privilege tables: Table 'mysql.host'
>> >> doesn't exist"
>> >>
>> >>in MySQL tables folder it created these files:
>> >>
>> >>
>> >> Folder: C:\mysql\data\mysql
>> >>
>> >>20.01.2004 00:23 <DIR> .
>> >>20.01.2004 00:23 <DIR> ..
>> >>15.12.2003 02:37 8.778 columns_priv.frm
>> >>15.12.2003 02:37 0 columns_priv.MYD
>> >>15.12.2003 02:37 1.024 columns_priv.MYI
>> >>15.12.2003 02:37 9.088 db.frm
>> >>15.12.2003 02:37 153 db.MYD
>> >>15.12.2003 02:37 3.072 db.MYI
>> >>15.12.2003 02:37 9.064 host.frm
>> >>15.12.2003 02:37 0 host.MYD
>> >>15.12.2003 02:37 1.024 host.MYI
>> >>15.12.2003 02:37 8.877 tables_priv.frm
>> >>15.12.2003 02:37 0 tables_priv.MYD
>> >>15.12.2003 02:37 1.024 tables_priv.MYI
>> >>15.12.2003 02:37 9.806 user.frm
>> >>15.12.2003 02:37 152 user.MYD
>> >>15.12.2003 02:37 2.048 user.MYI
>> >>15.12.2003 02:37 8.641 func.frm
>> >>15.12.2003 02:37 0 func.MYD
>> >>15.12.2003 02:37 1.024 func.MYI
>> >>20.01.2004 00:26 10.485.760 ibdata1
>> >>20.01.2004 00:26 5.242.880 ib_logfile0
>> >>20.01.2004 00:26 5.242.880 ib_logfile1
>> >>20.01.2004 00:26 25.088 ib_arch_log_0000000000
>> >>
>> >>
>> >>
>> >>--
>> >>-::::::::::::::::::::::::::-
>> >>
>> >> > Just top be sure:
>> >> > You have additionally a folder d:\mysql\data\mysql and
>> it contains
>> >> > all of the below files:?
>> >>
>> >>
>> >> > 03.12.2003 15:41 8.820 columns_priv.frm
>> >> > 03.12.2003 15:41 0 columns_priv.MYD
>> >> > 03.12.2003 15:41 1.024 columns_priv.MYI
>> >> > 03.12.2003 15:41 9.178 db.frm
>> >> > 02.01.2004 20:47 1.071 db.MYD
>> >> > 02.01.2004 20:47 3.072 db.MYI
>> >> > 03.12.2003 15:41 9.148 host.frm
>> >> > 03.12.2003 15:41 0 host.MYD
>> >> > 03.12.2003 15:41 1.024 host.MYI
>> >> > 03.12.2003 15:41 8.925 tables_priv.frm
>> >> > 22.12.2003 09:51 1.425 tables_priv.MYD
>> >> > 22.12.2003 09:51 3.072 tables_priv.MYI
>> >> > 03.12.2003 15:41 9.992 user.frm
>> >> > 02.01.2004 20:05 396 user.MYD
>> >> > 02.01.2004 20:05 2.048 user.MYI
>> >> > 35 Datei(en) 121.471 Bytes
>> >> > 2 Verzeichnis(se), 1.286.184.960 Bytes frei
>> >>
>> >> > Regards,
>> >> > Armin.
>> >>
>> >>
>> >> >> -----Original Message-----
>> >> >> From: labsy@stripped [mailto:labsy@stripped]
>> >> >> Sent: Monday, January 19, 2004 11:01 PM
>> >> >> To: win32@stripped
>> >> >> Subject: Re[2]: Instalation: FATAL ERROR
>> >> >>
>> >> >>
>> >> >> Elou Randy,
>> >> >>
>> >> >> thanx, but no help.
>> >> >> If I change that setting in my.ini, MySQL creates
>> these 4 files in
>> >> >> d:\mysql\data folder:
>> >> >> -------------------------------------------------
>> >> >> ib_arch_log_00000000000 25 kB
>> >> >> ib_logfile0 5.120 kB
>> >> >> ib_logfile1 5.120 kB
>> >> >> ibdata1 10.240 kB
>> >> >> -------------------------------------------------
>> >> >>
>> >> >> Then it says again:
>> >> >> 040119 22:51:17 Fatal error: Can't open privilege
>> tables: Table
>> >> >> 'mysql.host' doesn't exist
>> >> >>
>> >> >> Any idea?
>> >> >>
>> >> >> --
>> >> >> -::::::::::::::::::::::::::-
>> >> >>
>> >> >> > Labsy,
>> >> >>
>> >> >> > Try this in your my.ini:
>> >> >>
>> >> >> > datadir=D:/mysql/data
>> >> >>
>> >> >> > mySql uses this folder as the base directory. It
>> expects to find
>> >> >> > a sub-directory named mysql in the base directory.
>> Each database
>> >> >> > you create will be placed in a sub-directory with the name
> of
>> >> >> the database
>> >> >> > you create.
>> >> >>
>> >> >> > It also writes the error logs and slow-query log into the
>> >> >> base directory.
>> >> >>
>> >> >> > Randy
>> >> >>
>> >> >> > At 06:29 PM 01/19/2004 +0000, you wrote:
>> >> >> >>Hello!
>> >> >> >>
>> >> >> >>I am trying to install MySQL 4.0.17 on Windoze XP Pro
> with
>> >> >> IIS server.
>> >> >> >>What I did?
>> >> >> >>1.) I stopped IIS
>> >> >> >>2.) I installed MySQL with SETUP.EXE
>> >> >> >> Setup directory was D:\mysql
>> >> >> >>3.) I started IIS
>> >> >> >>4.) I created file my.ini in D:\WINDOWS directory
>> >> >> >> In my.ini file I created these lines:
>> >> >> >>
>> >> >> >>-------- MY.INI --------
>> >> >> >>[mysqld]
>> >> >> >>basedir=D:/mysql
>> >> >> >>datadir=D:/mysql/data/mysql
>> >> >> >>
>> >> >> >>[WinMySQLAdmin]
>> >> >> >>Server=D:/mysql/bin/mysqld-nt.exe
>> >> >> >>------------------------
>> >> >> >>
>> >> >> >>5.) Then I started command prompt, navigated to
>> D:\mysql\bin and
>> >> >> >> entered this command:
>> >> >> >>
>> >> >> >> > D:\mysql\bin> mysqld --console
>> >> >> >>
>> >> >> >> Here is the console output what I got:
>> >> >> >>
>> >> >> >>-------- CONSOLE OUTPUT --------
>> >> >> >>InnoDB: The first specified data file .\ibdata1 did not
> exist:
>> >> >> >>InnoDB: a new database to be created!
>> >> >> >>040119 19:10:49 InnoDB: Setting file .\ibdata1 size to
> 10 MB
>> >> >> >>InnoDB: Database physically writes the file full:
> wait...
>> >> >> >>040119 19:10:50 InnoDB: Log file .\ib_logfile0 did
> not
>> >> >> exist: new to
>> >> >> >>be created
>> >> >> >>
>> >> >> >>InnoDB: Setting log file .\ib_logfile0 size to 5 MB
>> >> >> >>InnoDB: Database physically writes the file full:
> wait...
>> >> >> >>040119 19:10:50 InnoDB: Log file .\ib_logfile1 did
> not
>> >> >> exist: new to
>> >> >> >>be created
>> >> >> >>
>> >> >> >>InnoDB: Setting log file .\ib_logfile1 size to 5 MB
>> >> >> >>InnoDB: Database physically writes the file full:
> wait...
>> >> >> >>InnoDB: Doublewrite buffer not found: creating new
>> >> >> >>InnoDB: Doublewrite buffer created
>> >> >> >>InnoDB: Creating foreign key constraint system tables
>> >> >> >>InnoDB: Foreign key constraint system tables created
>> >> >> >>040119 19:10:59 InnoDB: Started
>> >> >> >>040119 19:10:59 Fatal error: Can't open privilege
> tables:
>> >> >> Table 'mysql.host'
>> >> >> >>do
>> >> >> >>esn't exist
>> >> >> >>040119 19:10:59 Aborting
>> >> >> >>
>> >> >> >>040119 19:10:59 InnoDB: Starting shutdown...
>> >> >> >>040119 19:11:01 InnoDB: Shutdown completed
>> >> >> >>040119 19:11:01 mysqld: Shutdown Complete
>> >> >> >>--------------------------------
>> >> >> >>
>> >> >> >>6.) I observer directory for databases, databases
>> were initialised,
>> >> >> >> BUT SERVER DOES NOT WANT TO START!
>> >> >> >>
>> >> >> >>
>> >> >> >>I did try it over and over again, but no help. Anybody
> has an
>> >> >> >>idea what could be wrong?
>> >> >> >>
>> >> >> >>--
>> >> >> >>Labsy,
>> >> >> >>WebSlave
>> >> >> >>
>> >> >>
>> >>
>> >>----------------------------------------------------------------
>> >> >> >>This message was sent using splet.biz webmail
> software.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>--
>> >> >> >>MySQL Windows Mailing List
>> >> >> >>For list archives: http://lists.mysql.com/win32 To
>> unsubscribe:
>> >> >> >>http://lists.mysql.com/win32?unsub=1
>> >> >>
>> >> >> > Thanks for using Astro-Auction.com.
>> >> >>
>> >> >> > Randy Clamons
>> >> >> > Systems Programming
>> >> >>
>> >> >>
>> >> >>
>> >> >> -.::::::::::::::::::::::::.-
>> >> >> ::::::::::::::::::::::::::
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> MySQL Windows Mailing List
>> >> >> For list archives: http://lists.mysql.com/win32 To
> unsubscribe:
>> >> >>
>> http://lists.mysql.com/win32?unsub=1
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >> > --
>> >> > MySQL Windows Mailing List
>> >> > For list archives: http://lists.mysql.com/win32
>> >> > To unsubscribe:
>> >> > http://lists.mysql.com/win32?unsub=1
>> >>
>> >>
>> >>
>> >>-.::::::::::::::::::::::::.-
>> >> ::::::::::::::::::::::::::
>> >>
>> >>
>> >>
>> >>
>> >>--
>> >>MySQL Windows Mailing List
>> >>For list archives: http://lists.mysql.com/win32
>> >>To unsubscribe:
>> >>http://lists.mysql.com/win32?unsub=1
>>
>> > Thanks for using Astro-Auction.com.
>>
>> > Randy Clamons
>> > Systems Programming
>>
>>
>>
>> -.::::::::::::::::::::::::.-
>> ::::::::::::::::::::::::::
>>
>>
>>
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
>> http://lists.mysql.com/win32?unsub=1
>>
>>
>>
>>
>>
-.::::::::::::::::::::::::.-
::::::::::::::::::::::::::
