mysql for windows 2000

I entered into the bin directory of the MySql directory and gave the
command, 'mysqld --console' in the windows command prompt.
the following error was reported...
050926 22:31:02 InnoDB: Started
050926 22:31:03 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050926 22:31:03 Aborting


also when i give 'mysql -u root -p', i get the following error message...
ERROR 2003: can't connect to My Sql server on 'localhost'<10061>

i donot know how to get connected...
i am desperately in need of Mysql to work with it...
please help me...

sincerely,
Janani.J

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: mysql for windows 2000

On 10/14/05, janani j wrote:
> I entered into the bin directory of the MySql directory and gave the
> command, 'mysqld --console' in the windows command prompt.

You don't need to run mysqld from the command line in windows 2000,
its a service enabled system, so you can just install mysqld as a
service using mysqld --install. Then "net start MySQL" should do it,
but you need to prepare your config file first.

> the following error was reported...
> 050926 22:31:02 InnoDB: Started
> 050926 22:31:03 Fatal error: Can't open privilege tables: Table
> 'mysql.host' doesn't exist
> 050926 22:31:03 Aborting
>

I don't know the exact cause of the error, but you need a properly set
my.cnf or my.ini and use the right syntax for mysqld to point to the
file. This is all described at the Manual, I suggest you download it.

> also when i give 'mysql -u root -p', i get the following error message...
> ERROR 2003: can't connect to My Sql server on 'localhost'<10061>

That's because mysqld is not running, so, you can't connect to it.

> i donot know how to get connected...
> i am desperately in need of Mysql to work with it...
> please help me...

Well, since you're so desperate, chech the MySQL Manual for the
"Installation" section and follow it, also check "Running mysql as a
service". We can't help you till you have a real problem installing or
running it.

Good luck,

"Teach a man how to fish instead of giving the fish and you've feed it fore=
ver"
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org