Erroring out when Starting for the first time on MySQL 4.1

I am following the instructions from url: http://www.analysisandsolutions.=
com/code/mybasic.htm
Seemed logical since I have SQL experience but no experience with MySQL. I=
nstall seem to go well and I selected:=20

NT/2000/XP. Named pipes.
mysqld-nt --install mysql40=20
=09
I am just trying to run a local version to get experience with and also ti=
e in with Perl which I use constantly.

When I try to start I get error 1067 and I looked at the err file and it s=
ays it can not find or create mysql.host I checked the location of the data=
dir which is datadir =3D C:/mysql41/data/

I went in as myself and was able to create a file at that location, so I d=
on't believe it is a permission problem. Unsure what to do or try. =09

Any questions and/or problems, please let me know.

Thanks!

Wags ;)



*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************


--
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: Erroring out when Starting for the first time on MySQL 4.1

--=_alternative 0069866085256FB8_=
Content-Type: text/plain; charset="US-ASCII"

"Wagner, David --- Senior Programmer Analyst --- WGO"
wrote on 03/02/2005 01:14:51 PM:

> I am following the instructions from url: http://www.
> analysisandsolutions.com/code/mybasic.htm
> Seemed logical since I have SQL experience but no experience with
> MySQL. Install seem to go well and I selected:
>
> NT/2000/XP. Named pipes.
> mysqld-nt --install mysql40
>
> I am just trying to run a local version to get experience with
> and also tie in with Perl which I use constantly.
>
> When I try to start I get error 1067 and I looked at the err file
> and it says it can not find or create mysql.host I checked the
> location of the datadir which is datadir = C:/mysql41/data/
>
> I went in as myself and was able to create a file at that
> location, so I don't believe it is a permission problem. Unsure
> what to do or try.
>
> Any questions and/or problems, please let me know.
>
> Thanks!
>
> Wags ;)
>

I have a few questions about your installation:

1) Are you installing this as an XP executable or as an installation
inside of Cygwin? Both sets of directions are on the page you listed.

2) (If as XP executable) Is the MySQL server running as a service? (Was
the installer able to register it as a service and is it running?). If
it's registered but not running can you start it? Read the contents of
c:\mysql\data\*.err and review your XP Event Viewer for any possible
problems getting the MySQL server service started.

3) (Again, if installed as an XP executable) I recently walked someone
else through making an initial connection with their server using only
named pipes on XP and we had to use the -h parameter with a . for the host
name to make the connection. Assuming your server is started, what do you
get if you execute (in a command shell) the following command and give it
the password you assigned to the root user:

c:\mysql41\bin\mysql -h . -u root -p

4) What were you doing when you got the error? What was the command the
generated the error you listed?

Tons of additional troubleshooting information is available from the MySQL
Manual:
http://dev.mysql.com/doc/mysql/en/problems.html

And a different set of installation procedures is also available for
possible comparison. (Maybe there is something here that your other
directions missed):
http://dev.mysql.com/doc/mysql/en/installing.html

Sorry I couldn't be more precisely helpful but I couldn't divine your
setup and operating environment(s) well enough to diagnose your problem.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--=_alternative 0069866085256FB8_=--

RE: Erroring out when Starting for the first time on MySQL 4.1

------_=_NextPart_001_01C51F5E.63586E4C
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

"Wagner, David --- Senior Programmer Analyst --- WGO" ight.fedex.com> wrote on 03/02/2005 01:14:51 PM:

> I am following the instructions from url: http://www.
> analysisandsolutions.com/code/mybasic.htm
> Seemed logical since I have SQL experience but no experience with
> MySQL. Install seem to go well and I selected:=20
>=20
> NT/2000/XP. Named pipes.
> mysqld-nt --install mysql40=20
> =20
> I am just trying to run a local version to get experience with=20
> and also tie in with Perl which I use constantly.
>=20
> When I try to start I get error 1067 and I looked at the err file
> and it says it can not find or create mysql.host I checked the=20
> location of the datadir which is datadir =3D C:/mysql41/data/
>=20
> I went in as myself and was able to create a file at that=20
> location, so I don't believe it is a permission problem. Unsure=20
> what to do or try. =20
>=20
> Any questions and/or problems, please let me know.
>=20
> Thanks!
>=20
> Wags ;)
>=20

I have a few questions about your installation:=20

1) Are you installing this as an XP executable or as an installation inside=
of Cygwin? Both sets of directions are on the page you listed.=20

[Wagner, David --- Senior Programmer Analyst --- WGO] As Xp Executable
=20
2) (If as XP executable) Is the MySQL server running as a service? (Was the=
installer able to register it as a service and is it running?). If it's re=
gistered but not running can you start it? Read the contents of c:\mysql\da=
ta\*.err and review your XP Event Viewer for any possible problems getting =
the MySQL server service started.=20

[Wagner, David --- Senior Programmer Analyst --- WGO] It is setup as a serv=
ice, but when I try to start it errors out with the 1067. I went to the fo=
lder and as myeelf, added a a file with no problem. I was thena ble to dele=
te the file. I looked through the url and no where do i find anything abou=
t mysql.host. So unsure where it is suppose to come from.

3) (Again, if installed as an XP executable) I recently walked someone else=
through making an initial connection with their server using only named pi=
pes on XP and we had to use the -h parameter with a . for the host name to =
make the connection. Assuming your server is started, what do you get if yo=
u execute (in a command shell) the following command and give it the passwo=
rd you assigned to the root user:=20

c:\mysql41\bin\mysql -h . -u root -p=20
[Wagner, David --- Senior Programmer Analyst --- WGO] the server dies after=
the rror on the mysql.host=20

4) What were you doing when you got the error? What was the command the gen=
erated the error you listed?=20
[Wagner, David --- Senior Programmer Analyst --- WGO] I enter; net s=
tart mysql41
and I then get the error.
=20
Tons of additional troubleshooting information is available from the MySQL =
Manual:=20
http://dev.mysql.com/doc/mysql/en/problems.html=20

And a different set of installation procedures is also available for possib=
le comparison. (Maybe there is something here that your other directions mi=
ssed):=20
http://dev.mysql.com/doc/mysql/en/installing.html=20

Sorry I couldn't be more precisely helpful but I couldn't divine your setup=
and operating environment(s) well enough to diagnose your problem.=20
[Wagner, David --- Senior Programmer Analyst --- WGO] Sorry, but I thought =
I was giveing engouh info, but will try to provide more in the future as I =
work through this.
=20
Thank you for the response and I will see what I can find out.
=20

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine=20



*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************


------_=_NextPart_001_01C51F5E.63586E4C--

RE: Erroring out when Starting for the first time on MySQL 4.1

--=_alternative 006CF3A885256FB8_=
Content-Type: text/plain; charset="US-ASCII"

"Wagner, David --- Senior Programmer Analyst --- WGO"
wrote on 03/02/2005 02:31:10 PM:

> "Wagner, David --- Senior Programmer Analyst --- WGO" > Wagner@freight.fedex.com> wrote on 03/02/2005 01:14:51 PM:
>
> > I am following the instructions from url: http://www.
> > analysisandsolutions.com/code/mybasic.htm
> > Seemed logical since I have SQL experience but no experience with
> > MySQL. Install seem to go well and I selected:
> >
> > NT/2000/XP. Named pipes.
> > mysqld-nt --install mysql40
> >
> > I am just trying to run a local version to get experience with
> > and also tie in with Perl which I use constantly.
> >
> > When I try to start I get error 1067 and I looked at the err file
> > and it says it can not find or create mysql.host I checked the
> > location of the datadir which is datadir = C:/mysql41/data/
> >
> > I went in as myself and was able to create a file at that
> > location, so I don't believe it is a permission problem. Unsure
> > what to do or try.
> >
> > Any questions and/or problems, please let me know.
> >
> > Thanks!
> >
> > Wags ;)
> >
>
> I have a few questions about your installation:
>
> 1) Are you installing this as an XP executable or as an installation
> inside of Cygwin? Both sets of directions are on the page you listed.
>
> [Wagner, David --- Senior Programmer Analyst --- WGO] As Xp
Executable
>
> 2) (If as XP executable) Is the MySQL server running as a service?
> (Was the installer able to register it as a service and is it
> running?). If it's registered but not running can you start it? Read
> the contents of c:\mysql\data\*.err and review your XP Event Viewer
> for any possible problems getting the MySQL server service started.
>
> [Wagner, David --- Senior Programmer Analyst --- WGO] It is setup as
> a service, but when I try to start it errors out with the 1067. I
> went to the folder and as myeelf, added a a file with no problem. I
> was thena ble to delete the file. I looked through the url and no
> where do i find anything about mysql.host. So unsure where it is
> suppose to come from.
>
> 3) (Again, if installed as an XP executable) I recently walked
> someone else through making an initial connection with their server
> using only named pipes on XP and we had to use the -h parameter with
> a . for the host name to make the connection. Assuming your server
> is started, what do you get if you execute (in a command shell) the
> following command and give it the password you assigned to the root
user:
>
> c:\mysql41\bin\mysql -h . -u root -p
> [Wagner, David --- Senior Programmer Analyst --- WGO] the server
> dies after the rror on the mysql.host
>
> 4) What were you doing when you got the error? What was the command
> the generated the error you listed?
> [Wagner, David --- Senior Programmer Analyst --- WGO] I enter;
> net start mysql41
> and I then get the error.
>
> Tons of additional troubleshooting information is available from the
> MySQL Manual:
> http://dev.mysql.com/doc/mysql/en/problems.html
>
> And a different set of installation procedures is also available for
> possible comparison. (Maybe there is something here that your other
> directions missed):
> http://dev.mysql.com/doc/mysql/en/installing.html
>
> Sorry I couldn't be more precisely helpful but I couldn't divine
> your setup and operating environment(s) well enough to diagnose
yourproblem.
> [Wagner, David --- Senior Programmer Analyst --- WGO] Sorry, but I
> thought I was giveing engouh info, but will try to provide more in
> the future as I work through this.
>
> Thank you for the response and I will see what I can find out.
>
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>

OK, I think I'm caught up. When I read farther down into your tutorial, it
said that a 1067 error can also be caused not just by lack of permissions
but by typos in your config file (my.cnf).

I know your tutorial said to use / and not \ for path separators...
however, I had to use \ to get my config file to work on win2k. Also, if
you installed your service with the name "mysql41" (which I think you did)
you only need to fill in information for the [mysql41] section, the other
section won't be read (less typing should mean less typos). I think if you
edit your my.cnf file, swap all of the / for \, and verify your paths then
your service should start.

(BTW - it is not "incorrect" to use "my.cnf" on windows installations but
if you prefer (stress -prefer-) you could rename it to "my.ini" to be more
"M$-like"... exact same file, different name. It's just a gates-ism that
the file should be called *.ini. I keep mine in the WINNT folder but
anywhere in one of the system paths will do.)

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--=_alternative 006CF3A885256FB8_=--

RE: Erroring out when Starting for the first time on MySQL 4.1

------_=_NextPart_001_01C51F63.AEE4A138
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

"Wagner, David --- Senior Programmer Analyst --- WGO" ..fedex.com> wrote on 03/02/2005 02:31:10 PM:=20

> "Wagner, David --- Senior Programmer Analyst --- WGO" > Wagner@freight.fedex.com> wrote on 03/02/2005 01:14:51 PM:=20
>=20
> > I am following the instructions from url: http://www.=20
> > analysisandsolutions.com/code/mybasic.htm=20
> > Seemed logical since I have SQL experience but no experience with=20
> > MySQL. Install seem to go well and I selected:=20
> >=20
> > NT/2000/XP. Named pipes.=20
> > mysqld-nt --install mysql40=20
> > =20
> > I am just trying to run a local version to get experience with=20
> > and also tie in with Perl which I use constantly.=20
> >=20
> > When I try to start I get error 1067 and I looked at the err file=20
> > and it says it can not find or create mysql.host I checked the=20
> > location of the datadir which is datadir =3D C:/mysql41/data/=20
> >=20
> > I went in as myself and was able to create a file at that=20
> > location, so I don't believe it is a permission problem. Unsure=20
> > what to do or try. =20
> >=20
> > Any questions and/or problems, please let me know.=20
> >=20
> > Thanks!=20
> >=20
> > Wags ;)=20
> >=20
>=20
> I have a few questions about your installation:=20
>=20
> 1) Are you installing this as an XP executable or as an installation=20
> inside of Cygwin? Both sets of directions are on the page you listed.=20
>=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] As Xp Executabl=
e=20
> =20
> 2) (If as XP executable) Is the MySQL server running as a service?=20
> (Was the installer able to register it as a service and is it=20
> running?). If it's registered but not running can you start it? Read=20
> the contents of c:\mysql\data\*.err and review your XP Event Viewer=20
> for any possible problems getting the MySQL server service started.=20
>=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] It is setup as=20
> a service, but when I try to start it errors out with the 1067. I=20
> went to the folder and as myeelf, added a a file with no problem. I=20
> was thena ble to delete the file. I looked through the url and no=20
> where do i find anything about mysql.host. So unsure where it is=20
> suppose to come from.=20
>=20
> 3) (Again, if installed as an XP executable) I recently walked=20
> someone else through making an initial connection with their server=20
> using only named pipes on XP and we had to use the -h parameter with=20
> a . for the host name to make the connection. Assuming your server=20
> is started, what do you get if you execute (in a command shell) the=20
> following command and give it the password you assigned to the root user:=
>=20
> c:\mysql41\bin\mysql -h . -u root -p=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] the server=20
> dies after the rror on the mysql.host=20
>=20
> 4) What were you doing when you got the error? What was the command=20
> the generated the error you listed?=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] I enter; =20
> net start mysql41=20
> and I then get the error.=20
> =20
> Tons of additional troubleshooting information is available from the=20
> MySQL Manual:=20
> http://dev.mysql.com/doc/mysql/en/problems.html=20
>=20
> And a different set of installation procedures is also available for=20
> possible comparison. (Maybe there is something here that your other=20
> directions missed):=20
> http://dev.mysql.com/doc/mysql/en/installing.html=20
>=20
> Sorry I couldn't be more precisely helpful but I couldn't divine=20
> your setup and operating environment(s) well enough to diagnose yourprobl=
em.=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] Sorry, but I=20
> thought I was giveing engouh info, but will try to provide more in=20
> the future as I work through this.=20
> =20
> Thank you for the response and I will see what I can find out.=20
> =20
>=20
> Shawn Green=20
> Database Administrator=20
> Unimin Corporation - Spruce Pine=20
>=20
>=20

OK, I think I'm caught up. When I read farther down into your tutorial, it =
said that a 1067 error can also be caused not just by lack of permissions b=
ut by typos in your config file (my.cnf).=20

[Wagner, David --- Senior Programmer Analyst --- WGO] Like I stated in the =
earlier eamil, I was able to generate files into the mysql41\data\ folder, =
add and delete. Where is mysql.host suppose to reside.
=20
I know your tutorial said to use / and not \ for path separators... however=
, I had to use \ to get my config file to work on win2k. Also, if you insta=
lled your service with the name "mysql41" (which I think you did) you only =
need to fill in information for the [mysql41] section, the other section wo=
n't be read (less typing should mean less typos). I think if you edit your =
my.cnf file, swap all of the / for \, and verify your paths then your servi=
ce should start.=20
[Wagner, David --- Senior Programmer Analyst --- WGO] I changed the / to \ =
and also changed from cnf to ini. It still abortson the startup. here is=
a portion of the error log w/in mysql41/data/:

050302 12:01:25 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...
050302 12:01:25 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050302 12:01:25 InnoDB: Flushing modified pages from the buffer pool...
050302 12:01:25 InnoDB: Started; log sequence number 0 43634
050302 12:01:25 [ERROR] Fatal error: Can't open privilege tables: Table 'my=
sql.host' doesn't exist

Wags ;)=20
(BTW - it is not "incorrect" to use "my.cnf" on windows installations but i=
f you prefer (stress -prefer-) you could rename it to "my.ini" to be more "=
M$-like"... exact same file, different name. It's just a gates-ism that the=
file should be called *.ini. I keep mine in the WINNT folder but anywhere =
in one of the system paths will do.)=20

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine=20



*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************


------_=_NextPart_001_01C51F63.AEE4A138--

RE: Erroring out when Starting for the first time on MySQL 4.1

--=_alternative 007121A985256FB8_=
Content-Type: text/plain; charset="US-ASCII"

"Wagner, David --- Senior Programmer Analyst --- WGO"
wrote on 03/02/2005 03:09:04 PM:

> "Wagner, David --- Senior Programmer Analyst --- WGO" > Wagner@freight.fedex.com> wrote on 03/02/2005 02:31:10 PM:
>
> > "Wagner, David --- Senior Programmer Analyst --- WGO" > > Wagner@freight.fedex.com> wrote on 03/02/2005 01:14:51 PM:
> >
> > > I am following the instructions from url: http://www.
> > > analysisandsolutions.com/code/mybasic.htm
> > > Seemed logical since I have SQL experience but no experience with

> > > MySQL. Install seem to go well and I selected:
> > >
> > > NT/2000/XP. Named pipes.
> > > mysqld-nt --install mysql40
> > >
> > > I am just trying to run a local version to get experience with
> > > and also tie in with Perl which I use constantly.
> > >
> > > When I try to start I get error 1067 and I looked at the err file

> > > and it says it can not find or create mysql.host I checked the
> > > location of the datadir which is datadir = C:/mysql41/data/
> > >
> > > I went in as myself and was able to create a file at that
> > > location, so I don't believe it is a permission problem. Unsure
> > > what to do or try.
> > >
> > > Any questions and/or problems, please let me know.
> > >
> > > Thanks!
> > >
> > > Wags ;)
> > >
> >
> > I have a few questions about your installation:
> >
> > 1) Are you installing this as an XP executable or as an installation
> > inside of Cygwin? Both sets of directions are on the page you listed.
> >
> > [Wagner, David --- Senior Programmer Analyst --- WGO] As Xp
Executable
> >
> > 2) (If as XP executable) Is the MySQL server running as a service?
> > (Was the installer able to register it as a service and is it
> > running?). If it's registered but not running can you start it? Read
> > the contents of c:\mysql\data\*.err and review your XP Event Viewer
> > for any possible problems getting the MySQL server service started.
> >
> > [Wagner, David --- Senior Programmer Analyst --- WGO] It is setup as
> > a service, but when I try to start it errors out with the 1067. I
> > went to the folder and as myeelf, added a a file with no problem. I
> > was thena ble to delete the file. I looked through the url and no
> > where do i find anything about mysql.host. So unsure where it is
> > suppose to come from.
> >
> > 3) (Again, if installed as an XP executable) I recently walked
> > someone else through making an initial connection with their server
> > using only named pipes on XP and we had to use the -h parameter with
> > a . for the host name to make the connection. Assuming your server
> > is started, what do you get if you execute (in a command shell) the
> > following command and give it the password you assigned to the root
user: >
> > c:\mysql41\bin\mysql -h . -u root -p
> > [Wagner, David --- Senior Programmer Analyst --- WGO] the server
> > dies after the rror on the mysql.host
> >
> > 4) What were you doing when you got the error? What was the command
> > the generated the error you listed?
> > [Wagner, David --- Senior Programmer Analyst --- WGO] I enter;
> > net start mysql41
> > and I then get the error.
> >
> > Tons of additional troubleshooting information is available from the
> > MySQL Manual:
> > http://dev.mysql.com/doc/mysql/en/problems.html
> >
> > And a different set of installation procedures is also available for
> > possible comparison. (Maybe there is something here that your other
> > directions missed):
> > http://dev.mysql.com/doc/mysql/en/installing.html
> >
> > Sorry I couldn't be more precisely helpful but I couldn't divine
> > your setup and operating environment(s) well enough to diagnose
> yourproblem.
> > [Wagner, David --- Senior Programmer Analyst --- WGO] Sorry, but I
> > thought I was giveing engouh info, but will try to provide more in
> > the future as I work through this.
> >
> > Thank you for the response and I will see what I can find out.
> >
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
> >
>
> OK, I think I'm caught up. When I read farther down into your
> tutorial, it said that a 1067 error can also be caused not just by
> lack of permissions but by typos in your config file (my.cnf).
>
> [Wagner, David --- Senior Programmer Analyst --- WGO] Like I stated
> in the earlier eamil, I was able to generate files into the
> mysql41\data\ folder, add and delete. Where is mysql.host suppose to
reside.
>
> I know your tutorial said to use / and not \ for path separators...
> however, I had to use \ to get my config file to work on win2k.
> Also, if you installed your service with the name "mysql41" (which I
> think you did) you only need to fill in information for the
> [mysql41] section, the other section won't be read (less typing
> should mean less typos). I think if you edit your my.cnf file, swap
> all of the / for \, and verify your paths then your service should
start.
> [Wagner, David --- Senior Programmer Analyst --- WGO] I changed the
> / to \ and also changed from cnf to ini. It still abortson the
> startup. here is a portion of the error log w/in mysql41/data/:
>
> 050302 12:01:25 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...
> 050302 12:01:25 InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 43634.
> InnoDB: Doing recovery: scanned up to log sequence number 0 43634
> 050302 12:01:25 InnoDB: Flushing modified pages from the buffer pool...
> 050302 12:01:25 InnoDB: Started; log sequence number 0 43634
> 050302 12:01:25 [ERROR] Fatal error: Can't open privilege tables:
> Table 'mysql.host' doesn't exist
>
> Wags ;)
> (BTW - it is not "incorrect" to use "my.cnf" on windows
> installations but if you prefer (stress -prefer-) you could rename
> it to "my.ini" to be more "M$-like"... exact same file, different
> name. It's just a gates-ism that the file should be called *.ini. I
> keep mine in the WINNT folder but anywhere in one of the system
> paths will do.)
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>

Just curious, which installation method did you use? Somewhere you are
either missing a file or you have not identified your datadir correctly.

Make sure that your path exists and has at least a "mysql"
folder in it and that the mysql folder has several files in it (including
these 3: host.frm, host.myd, host.myi). If it doesn't, you need to go get
both of your "initial" data folders (there should be 2: "mysql" and
"test") from your installation ZIP or copy them from wherever the
installer's MSI script put them and put them into your folder.
(hence the question about HOW you installed your MySQL. I believe that the
4.1 distribution comes in an MSI and non-MSI varieties. How to find your
missing files can depend on which package you used.)

I don't know if it's important but my *dir (basedir, datadir, etc)
settings do not end with a "\". My mysql server runs as "mysqld" and this
is an excerpt from my my.ini file:

[mysqld]
basedir=C:\MYSQL
datadir=C:\MYSQL\data

We are very close to getting this going. We just have to sync up the paths
with the data files and you should be golden.

One other thing.... search your system for any other "my.ini" or "my.cnf"
file. Delete them if they exist as they COULD be in conflict with the one
you are editing.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




--=_alternative 007121A985256FB8_=--

RE: Erroring out when Starting for the first time on MySQL 4.1

------_=_NextPart_001_01C51F6D.38CB25D0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

"Wagner, David --- Senior Programmer Analyst --- WGO" ..fedex.com> wrote on 03/02/2005 03:09:04 PM:=20

> "Wagner, David --- Senior Programmer Analyst --- WGO" > Wagner@freight.fedex.com> wrote on 03/02/2005 02:31:10 PM:=20
>=20
> > "Wagner, David --- Senior Programmer Analyst --- WGO" > > Wagner@freight.fedex.com> wrote on 03/02/2005 01:14:51 PM:=20
> >=20
> > > I am following the instructions from url: http://www.=20
> > > analysisandsolutions.com/code/mybasic.htm=20
> > > Seemed logical since I have SQL experience but no experience with=
> > > MySQL. Install seem to go well and I selected:=20
> > >=20
> > > NT/2000/XP. Named pipes.=20
> > > mysqld-nt --install mysql40=20
> > > =20
> > > I am just trying to run a local version to get experience with=20
> > > and also tie in with Perl which I use constantly.=20
> > >=20
> > > When I try to start I get error 1067 and I looked at the err file=
> > > and it says it can not find or create mysql.host I checked the=20
> > > location of the datadir which is datadir =3D C:/mysql41/data/=20
> > >=20
> > > I went in as myself and was able to create a file at that=20
> > > location, so I don't believe it is a permission problem. Unsure=20
> > > what to do or try. =20
> > >=20
> > > Any questions and/or problems, please let me know.=20
> > >=20
> > > Thanks!=20
> > >=20
> > > Wags ;)=20
> > >=20
> >=20
> > I have a few questions about your installation:=20
> >=20
> > 1) Are you installing this as an XP executable or as an installation=20
> > inside of Cygwin? Both sets of directions are on the page you listed.=
> >=20
> > [Wagner, David --- Senior Programmer Analyst --- WGO] As Xp Executa=
ble=20
> > =20
> > 2) (If as XP executable) Is the MySQL server running as a service?=20
> > (Was the installer able to register it as a service and is it=20
> > running?). If it's registered but not running can you start it? Read=20
> > the contents of c:\mysql\data\*.err and review your XP Event Viewer=20
> > for any possible problems getting the MySQL server service started.=20
> >=20
> > [Wagner, David --- Senior Programmer Analyst --- WGO] It is setup as=20
> > a service, but when I try to start it errors out with the 1067. I=20
> > went to the folder and as myeelf, added a a file with no problem. I=20
> > was thena ble to delete the file. I looked through the url and no=20
> > where do i find anything about mysql.host. So unsure where it is=20
> > suppose to come from.=20
> >=20
> > 3) (Again, if installed as an XP executable) I recently walked=20
> > someone else through making an initial connection with their server=20
> > using only named pipes on XP and we had to use the -h parameter with=20
> > a . for the host name to make the connection. Assuming your server=20
> > is started, what do you get if you execute (in a command shell) the=20
> > following command and give it the password you assigned to the root use=
r: >=20
> > c:\mysql41\bin\mysql -h . -u root -p=20
> > [Wagner, David --- Senior Programmer Analyst --- WGO] the server=20
> > dies after the rror on the mysql.host=20
> >=20
> > 4) What were you doing when you got the error? What was the command=20
> > the generated the error you listed?=20
> > [Wagner, David --- Senior Programmer Analyst --- WGO] I enter; =20
> > net start mysql41=20
> > and I then get the error.=20
> > =20
> > Tons of additional troubleshooting information is available from the=20
> > MySQL Manual:=20
> > http://dev.mysql.com/doc/mysql/en/problems.html=20
> >=20
> > And a different set of installation procedures is also available for=20
> > possible comparison. (Maybe there is something here that your other=20
> > directions missed):=20
> > http://dev.mysql.com/doc/mysql/en/installing.html=20
> >=20
> > Sorry I couldn't be more precisely helpful but I couldn't divine=20
> > your setup and operating environment(s) well enough to diagnose=20
> yourproblem.=20
> > [Wagner, David --- Senior Programmer Analyst --- WGO] Sorry, but I=20
> > thought I was giveing engouh info, but will try to provide more in=20
> > the future as I work through this.=20
> > =20
> > Thank you for the response and I will see what I can find out.=20
> > =20
> >=20
> > Shawn Green=20
> > Database Administrator=20
> > Unimin Corporation - Spruce Pine=20
> >=20
> >=20
>=20
> OK, I think I'm caught up. When I read farther down into your=20
> tutorial, it said that a 1067 error can also be caused not just by=20
> lack of permissions but by typos in your config file (my.cnf).=20
>=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] Like I stated=20
> in the earlier eamil, I was able to generate files into the=20
> mysql41\data\ folder, add and delete. Where is mysql.host suppose to res=
ide.=20
> =20
> I know your tutorial said to use / and not \ for path separators...=20
> however, I had to use \ to get my config file to work on win2k.=20
> Also, if you installed your service with the name "mysql41" (which I=20
> think you did) you only need to fill in information for the=20
> [mysql41] section, the other section won't be read (less typing=20
> should mean less typos). I think if you edit your my.cnf file, swap=20
> all of the / for \, and verify your paths then your service should start.=
> [Wagner, David --- Senior Programmer Analyst --- WGO] I changed the=20
> / to \ and also changed from cnf to ini. It still abortson the=20
> startup. here is a portion of the error log w/in mysql41/data/:=20
>=20
> 050302 12:01:25 InnoDB: Database was not shut down normally!=20
> InnoDB: Starting crash recovery.=20
> InnoDB: Reading tablespace information from the .ibd files...=20
> InnoDB: Restoring possible half-written data pages from the doublewrite=
> InnoDB: buffer...=20
> 050302 12:01:25 InnoDB: Starting log scan based on checkpoint at=20
> InnoDB: log sequence number 0 43634.=20
> InnoDB: Doing recovery: scanned up to log sequence number 0 43634=20
> 050302 12:01:25 InnoDB: Flushing modified pages from the buffer pool...=
> 050302 12:01:25 InnoDB: Started; log sequence number 0 43634=20
> 050302 12:01:25 [ERROR] Fatal error: Can't open privilege tables:=20
> Table 'mysql.host' doesn't exist=20
>=20
> Wags ;)=20
> (BTW - it is not "incorrect" to use "my.cnf" on windows=20
> installations but if you prefer (stress -prefer-) you could rename=20
> it to "my.ini" to be more "M$-like"... exact same file, different=20
> name. It's just a gates-ism that the file should be called *.ini. I=20
> keep mine in the WINNT folder but anywhere in one of the system=20
> paths will do.)=20
>=20
> Shawn Green=20
> Database Administrator=20
> Unimin Corporation - Spruce Pine=20
>=20
>=20

Just curious, which installation method did you use? Somewhere you are eit=
her missing a file or you have not identified your datadir correctly.=20
[Wagner, David --- Senior Programmer Analyst --- WGO] I used the MSI. So I=
got some other info and unistalled mysql. Then I thought ok, I will do th=
e full load and let the wizard's do the work. It loaded and started withou=
t failing. Unforunately it was not running as a non privileged account, so=
tried to do that and I have now come full circle back to the 1067. I chan=
ged back to run as local system account and the service works. So obviousl=
y have some security issues.
Though when i try to run mysql ( and I have tried just straight mysql and m=
ysql -u root), but I get:

c:\program files\mysql\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'ro=
ot'@'localhost' (using password: NO)=20
=20
Make sure that your path exists and has at least a "mysql" folder=
in it and that the mysql folder has several files in it (including these 3=
: host.frm, host.myd, host.myi). If it doesn't, you need to go get both of =
your "initial" data folders (there should be 2: "mysql" and "test") from yo=
ur installation ZIP or copy them from wherever the installer's MSI script p=
ut them and put them into your folder. (hence the question about =
HOW you installed your MySQL. I believe that the 4.1 distribution comes in =
an MSI and non-MSI varieties. How to find your missing files can depend on =
which package you used.)=20
[Wagner, David --- Senior Programmer Analyst --- WGO] Using the MSI, but at=
this point, I just seem to be getting into a vary deep and dark hole. I t=
hink I will have to step back and see what I want to do.
=20
Again thanks to the list for trying and I will hvae to evaluate whether=
to continue trying or take another tack in doing the work I want to do.
=20
Wags ;)
I don't know if it's important but my *dir (basedir, datadir, etc) setting=
s do not end with a "\". My mysql server runs as "mysqld" and this is an ex=
cerpt from my my.ini file:=20

[mysqld]=20
basedir=3DC:\MYSQL=20
datadir=3DC:\MYSQL\data=20

We are very close to getting this going. We just have to sync up the paths =
with the data files and you should be golden.=20

One other thing.... search your system for any other "my.ini" or "my.cnf" f=
ile. Delete them if they exist as they COULD be in conflict with the one yo=
u are editing.=20

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine=20






*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************


------_=_NextPart_001_01C51F6D.38CB25D0--

RE: Erroring out when Starting for the first time on MySQL 4.1

--=_alternative 0079399F85256FB8_=
Content-Type: text/plain; charset="US-ASCII"


>
> Just curious, which installation method did you use? Somewhere you
> are either missing a file or you have not identified your datadir
correctly.
> [Wagner, David --- Senior Programmer Analyst --- WGO] I used the
> MSI. So I got some other info and unistalled mysql. Then I thought
> ok, I will do the full load and let the wizard's do the work. It
> loaded and started without failing. Unforunately it was not running
> as a non privileged account, so tried to do that and I have now come
> full circle back to the 1067. I changed back to run as local system
> account and the service works. So obviously have some security issues.
> Though when i try to run mysql ( and I have tried just straight
> mysql and mysql -u root), but I get:
>
> c:\program files\mysql\bin>mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
>
> Make sure that your path exists and has at least a "mysql"
> folder in it and that the mysql folder has several files in it
> (including these 3: host.frm, host.myd, host.myi). If it doesn't,
> you need to go get both of your "initial" data folders (there should
> be 2: "mysql" and "test") from your installation ZIP or copy them
> from wherever the installer's MSI script put them and put them into
> your folder. (hence the question about HOW you installed
> your MySQL. I believe that the 4.1 distribution comes in an MSI and
> non-MSI varieties. How to find your missing files can depend on
> which package you used.)
> [Wagner, David --- Senior Programmer Analyst --- WGO] Using the MSI,
> but at this point, I just seem to be getting into a vary deep and
> dark hole. I think I will have to step back and see what I want to do.
>
> Again thanks to the list for trying and I will hvae to evaluate
> whether to continue trying or take another tack in doing the work I
> want to do.
>
> Wags ;)
> I don't know if it's important but my *dir (basedir, datadir, etc)
> settings do not end with a "\". My mysql server runs as "mysqld" and
> this is an excerpt from my my.ini file:
>
> [mysqld]
> basedir=C:\MYSQL
> datadir=C:\MYSQL\data
>
> We are very close to getting this going. We just have to sync up the
> paths with the data files and you should be golden.
>
> One other thing.... search your system for any other "my.ini" or
> "my.cnf" file. Delete them if they exist as they COULD be in
> conflict with the one you are editing.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>

I think you have just had a bad first experience. Don't sell MySQL short
based on just this one experience. It really is a fine product and if you
DON'T use the MSI version, it can still be relatively easy to install (I
barely trust MSI scripts anyway).

Here is how to install MySQL from a ZIP file.(paraphrasing from
http://dev.mysql.com/doc/mysql/en/windows-install-archive.ht ml)

1) get the zip
2) unzip contents to some folder. I will use C:\mysql as an example. Refer
to this location as "basedir".
3) Relocate the data folder to anywhere you like. However, it is not
recommended to put your data files on a networked share (various reasons).
For example, if you want the data to reside in e:\dbservers\mysql then
copy the _contents_ of the folder c:\mysql\data to e:\dbservers\mysql.
Refer to this location as "datadir"
4) if you want the MySQL server to operate under a separate user account,
make the account now (use whichever tool is appropriate to your version of
Windows). Assign read rights to the new user account to the "basedir"
folder and read+execute rights to "basedir"\bin. Give
read+write+create+delete privileges to that account for the "datadir"
folder and all objects and subfolders in it. (details:
http://dev.mysql.com/doc/mysql/en/changing-mysql-user.html)

5) Edit one of the pre-composed config files and save the results as
"basedir"\bin\my.cnf or create your own "my.cnf" file in that folder. Make
sure that in the section [mysqld] you properly identify the basedir= and
datadir= folders. For this example here is all you should need to get the
server started:

[mysqld]
basedir=C:\mysql
datadir=E:\dbservers\mysql

6) Initialize the server as a service. If you want to run more than one
server on the same machine read (
http://dev.mysql.com/doc/mysql/en/multiple-servers.html). To setup the
server as a service, all it takes is
mysqlxxx --install

WHERE xxx represents the version of the MySQL server you want to run. Some
have named pipes, some do not. Some have Innodb, some do not. See:
http://dev.mysql.com/doc/mysql/en/windows-select-server.html

7) If you want to change the server to run as an unprivileged user. Stop
the service then edit the entry in the Services Manager to reflect the new
account you want the server to run as (the same user you created in step
4). Restart the server.

Under most situations, that's all there is to it. As I said, there is a
lot of troubleshooting help (other user's experiences) built into the
MySQL manual and installation procedures (
http://dev.mysql.com/doc/mysql/en/index.html). You may want to read
through their procedures now that you have seen an install fail then work.
It took me just about 2 hours (from a cold read and starting from scratch)
to get my first server running using their install instructions. My fault
was, I was overcomplicating things. Once I got "simple" with it, it worked
like a charm.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine





--=_alternative 0079399F85256FB8_=--

RE: Erroring out when Starting for the first time on MySQL 4.1

------_=_NextPart_001_01C51F74.B29540A1
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Shawn,
I will give it a shot later this evening and see what happens. I aprec=
iate the time and effort. Will follow your little setup and see how it goe=
s.
Will report back tomorrow.
=20
Again thanks for the help and insight.
=20
Wags ;)
=20
=20
>=20
> Just curious, which installation method did you use? Somewhere you=20
> are either missing a file or you have not identified your datadir correct=
ly.=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] I used the=20
> MSI. So I got some other info and unistalled mysql. Then I thought=20
> ok, I will do the full load and let the wizard's do the work. It=20
> loaded and started without failing. Unforunately it was not running=20
> as a non privileged account, so tried to do that and I have now come=20
> full circle back to the 1067. I changed back to run as local system=20
> account and the service works. So obviously have some security issues.=
> Though when i try to run mysql ( and I have tried7 just straight=20
> mysql and mysql -u root), but I get:=20
>=20
> c:\program files\mysql\bin>mysql -u root=20
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using=20
> password: NO)=20
> =20
> Make sure that your path exists and has at least a "mysql"=20
> folder in it and that the mysql folder has several files in it=20
> (including these 3: host.frm, host.myd, host.myi). If it doesn't,=20
> you need to go get both of your "initial" data folders (there should=20
> be 2: "mysql" and "test") from your installation ZIP or copy them=20
> from wherever the installer's MSI script put them and put them into=20
> your folder. (hence the question about HOW you installed=20
> your MySQL. I believe that the 4.1 distribution comes in an MSI and=20
> non-MSI varieties. How to find your missing files can depend on=20
> which package you used.)=20
> [Wagner, David --- Senior Programmer Analyst --- WGO] Using the MSI,=20
> but at this point, I just seem to be getting into a vary deep and=20
> dark hole. I think I will have to step back and see what I want to do.=
> =20
> Again thanks to the list for trying and I will hvae to evaluate=20
> whether to continue trying or take another tack in doing the work I=20
> want to do.=20
> =20
> Wags ;)=20
> I don't know if it's important but my *dir (basedir, datadir, etc)=20
> settings do not end with a "\". My mysql server runs as "mysqld" and=20
> this is an excerpt from my my.ini file:=20
>=20
> [mysqld]=20
> basedir=3DC:\MYSQL=20
> datadir=3DC:\MYSQL\data=20
>=20
> We are very close to getting this going. We just have to sync up the=20
> paths with the data files and you should be golden.=20
>=20
> One other thing.... search your system for any other "my.ini" or=20
> "my.cnf" file. Delete them if they exist as they COULD be in=20
> conflict with the one you are editing.=20
>=20
> Shawn Green=20
> Database Administrator=20
> Unimin Corporation - Spruce Pine=20
>=20

I think you have just had a bad first experience. Don't sell MySQL short ba=
sed on just this one experience. It really is a fine product and if you DON=
'T use the MSI version, it can still be relatively easy to install (I barel=
y trust MSI scripts anyway).=20

Here is how to install MySQL from a ZIP file.(paraphrasing from http://dev.=
mysql.com/doc/mysql/en/windows-install-archive.html)=20

1) get the zip=20
2) unzip contents to some folder. I will use C:\mysql as an example. Refer =
to this location as "basedir".=20
3) Relocate the data folder to anywhere you like. However, it is not recomm=
ended to put your data files on a networked share (various reasons). For ex=
ample, if you want the data to reside in e:\dbservers\mysql then copy the _=
contents_ of the folder c:\mysql\data to e:\dbservers\mysql. Refer to this =
location as "datadir"=20
4) if you want the MySQL server to operate under a separate user account, m=
ake the account now (use whichever tool is appropriate to your version of W=
indows). Assign read rights to the new user account to the "basedir" folder=
and read+execute rights to "basedir"\bin. Give read+write+create+delete pr=
ivileges to that account for the "datadir" folder and all objects and subfo=
lders in it. (details: http://dev.mysql.com/doc/mysql/en/changing-mysql-use=
r.html)=20

5) Edit one of the pre-composed config files and save the results as "based=
ir"\bin\my.cnf or create your own "my.cnf" file in that folder. Make sure t=
hat in the section [mysqld] you properly identify the basedir=3D and datadi=
r=3D folders. For this example here is all you should need to get the serve=
r started:=20

[mysqld]=20
basedir=3DC:\mysql=20
datadir=3DE:\dbservers\mysql=20

6) Initialize the server as a service. If you want to run more than one ser=
ver on the same machine read (http://dev.mysql.com/doc/mysql/en/multiple-se=
rvers.html). To setup the server as a service, all it takes is=20
mysqlxxx --install=20

WHERE xxx represents the version of the MySQL server you want to run. Some =
have named pipes, some do not. Some have Innodb, some do not. See: http://d=
ev.mysql.com/doc/mysql/en/windows-select-server.html=20

7) If you want to change the server to run as an unprivileged user. Stop th=
e service then edit the entry in the Services Manager to reflect the new ac=
count you want the server to run as (the same user you created in step 4). =
Restart the server.=20

Under most situations, that's all there is to it. As I said, there is a lot=
of troubleshooting help (other user's experiences) built into the MySQL ma=
nual and installation procedures (http://dev.mysql.com/doc/mysql/en/index.h=
tml). You may want to read through their procedures now that you have seen =
an install fail then work. It took me just about 2 hours (from a cold read =
and starting from scratch) to get my first server running using their insta=
ll instructions. My fault was, I was overcomplicating things. Once I got "s=
imple" with it, it worked like a charm.=20

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine=20







*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************


------_=_NextPart_001_01C51F74.B29540A1--

Re: Erroring out when Starting for the first time on MySQL 4.1

I am not sure if you went trought this step already, but try checking
the list archives for your error, MANY hits, I assure you. One of the
things that cause this error is the lack of the "mysql" dir at the
"data" dir, the database called "mysql" stores information on
passwords, hosts and some more info related to the server behavior,
so, your "data" dir would look like this (if you never touched the
defaults":

MySQL
\
data
\
mysql
test

I never had trouble with permissions, because of my FAT32 system, but
if you're running NTFS, you should look at the permissions set,
specially the permissions assigned for the user that's RUNNING MySQL
service. You mentioned that YOU had permission to write at the "data"
dir, so, you should try stopping the service and running mysql from
the command line (mysqld) so, it will run with YOUR permissions and
maybe you'll be able to connect, anyway, as Shawn said, I prefer the
zipped version, the MSI is just too "automatic" :)

Hope that helps,

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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