Cannot connect to mysql after install....

I have followed a direction for installing mysql4.1.7 and at the end of it,
when I try to get in I get error 2003.

Mysql starts and then terminates after a short while. Can someone tell me
what I am doing wrong or is there a simpler way to install this program?

I followed the instruction here:
http://www.analysisandsolutions.com/code/mybasic.htm

However, the file that was created for my.cnf was quite confusing

At one time, the error I was getting was:

Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

Once I started the server per instruction #11, I did not know how to get to
mysql prompt. I thought I had to login and each time I tried login in, I get
the following error message.

CAn someone help please?

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

c:\program files\mysql41\bin>mysql -u root mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

c:\program files\mysql41\bin>



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

Re: Cannot connect to mysql after install....

Ola One wrote:

> Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

> c:\program files\mysql41\bin>mysql -u root mysql
> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Ola,

Have you changed the location for mysql data files? (with a datadir=C:\
command in your my.ini/my.cnf file)

mysql.host is a table created in your database for MySQL's own use.
If it can't find it, either you've specified a new data file path and
not moved the files to the new location, or there was some kind of problem
during installation and the data files weren't created.


--
Peter Monk ~ IT Department
United Water International

Phone ....... 08 8301 2736
Fax ......... 08 8357 9728
Mobile ...... 0410 487 723

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