SEO

I wonder if someone can lend me a hand here? I dont have any database
experience.

I used this link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
first-start.html

I used this command:
C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console

I got this error, and i dont know how to respond to fix it. I do use
anti virus.

InnoDB operating system error number 32 in a file operation
InnoDB the error meabs that another program is using InnoDB s file
name
InnoDB of mysql please close it to get rid of this error
This might be a back or antivirus software or another instance

Can anyone please help me?
Andrew

newbie schreef:
> I wonder if someone can lend me a hand here? I dont have any database
> experience.
>
> I used this link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> first-start.html
>
> I used this command:
> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>
> I got this error, and i dont know how to respond to fix it. I do use
> anti virus.
>
> InnoDB operating system error number 32 in a file operation
> InnoDB the error meabs that another program is using InnoDB s file
> name
> InnoDB of mysql please close it to get rid of this error
> This might be a back or antivirus software or another instance
>
> Can anyone please help me?
> Andrew

try:
C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"

probabley MySQL is already running

at the end of the error-message is "or another instance"....

--
Luuk

On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
> newbie schreef:
>
>
>
> > I wonder if someone can lend me a hand here? I dont have any database
> > experience.
>
> > I used this link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> > first-start.html
>
> > I used this command:
> > C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>
> > I got this error, and i dont know how to respond to fix it. I do use
> > anti virus.
>
> > InnoDB operating system error number 32 in a file operation
> > InnoDB the error meabs that another program is using InnoDB s file
> > name
> > InnoDB of mysql please close it to get rid of this error
> > This might be a back or antivirus software or another instance
>
> > Can anyone please help me?
> > Andrew
>
> try:
> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>
> probabley MySQL is already running
>
> at the end of the error-message is "or another instance"....
>
> --
> Luuk

hmm i typed in mysql and it said it wanted switches...
i typed in mysql \h and i got all the switches for other parameters.
ok now i did this sounds like it s running? but what can i give as a
command to see the server is running?
Again, thanks for your post. I feel fortunate to have such nice people
out there like you.
I see that here is a file to populate the database ...maybe i can try
that too so i can run some command s and see something occur?
I have the mysql "crash course" book from ben forta

On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1999@yahoo.com> wrote:

> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
>> newbie schreef:
>>
>>
>>
>> > I wonder if someone can lend me a hand here? I dont have any database
>> > experience.
>>
>> > I used this
>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
>> > first-start.html
>>
>> > I used this command:
>> > C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>>
>> > I got this error, and i dont know how to respond to fix it. I do use
>> > anti virus.
>>
>> > InnoDB operating system error number 32 in a file operation
>> > InnoDB the error meabs that another program is using InnoDB s file
>> > name
>> > InnoDB of mysql please close it to get rid of this error
>> > This might be a back or antivirus software or another instance
>>
>> > Can anyone please help me?
>> > Andrew
>>
>> try:
>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>>
>> probabley MySQL is already running
>>
>> at the end of the error-message is "or another instance"....
>
> hmm i typed in mysql and it said it wanted switches...
> i typed in mysql \h and i got all the switches for other parameters.
> ok now i did this sounds like it s running? but what can i give as a
> command to see the server is running?

Usually it's registered as a service, and you can see it running there.

Just try a 'mysql' (without any switches), if you get a response,
especially something about missing or wrong credentials, the mysql deamon
is definitely running :P

Most common switches would be -u for username, -p for password, -h for
host.
--
Rik Wasmus

On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
> > On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
> >> newbie schreef:
>
> >> > I wonder if someone can lend me a hand here? I dont have any database
> >> > experience.
>
> >> > I used this
> >> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> >> > first-start.html
>
> >> > I used this command:
> >> > C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>
> >> > I got this error, and i dont know how to respond to fix it. I do use
> >> > anti virus.
>
> >> > InnoDB operating system error number 32 in a file operation
> >> > InnoDB the error meabs that another program is using InnoDB s file
> >> > name
> >> > InnoDB of mysql please close it to get rid of this error
> >> > This might be a back or antivirus software or another instance
>
> >> > Can anyone please help me?
> >> > Andrew
>
> >> try:
> >> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>
> >> probabley MySQL is already running
>
> >> at the end of the error-message is "or another instance"....
>
> > hmm i typed in mysql and it said it wanted switches...
> > i typed in mysql \h and i got all the switches for other parameters.
> > ok now i did this sounds like it s running? but what can i give as a
> > command to see the server is running?
>
> Usually it's registered as a service, and you can see it running there.
>
> Just try a 'mysql' (without any switches), if you get a response,
> especially something about missing or wrong credentials, the mysql deamon
> is definitely running :P
>
> Most common switches would be -u for username, -p for password, -h for
> host.
> --
> Rik Wasmus

Thank you for your post.
I looked in the control panel for installed software and the mysql
server is there.
When i loaded the software i noticed it was loading the server,
command shell, command utils and server instance config

When i go into control panel and go into services i see that there is
no mysql service listed there.
Now i am REALLY confused. Everything seems to logical and up front but
its not working as expected?
Now i am thinking now what? I dont any idea of what to do next?...help!

newbie schreef:
> On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
>>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
>>>> newbie schreef:
>>>>> I wonder if someone can lend me a hand here? I dont have any database
>>>>> experience.
>>>>> I used this
>>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
>>>>> first-start.html
>>>>> I used this command:
>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>>>>> I got this error, and i dont know how to respond to fix it. I do use
>>>>> anti virus.
>>>>> InnoDB operating system error number 32 in a file operation
>>>>> InnoDB the error meabs that another program is using InnoDB s file
>>>>> name
>>>>> InnoDB of mysql please close it to get rid of this error
>>>>> This might be a back or antivirus software or another instance
>>>>> Can anyone please help me?
>>>>> Andrew
>>>> try:
>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>>>> probabley MySQL is already running
>>>> at the end of the error-message is "or another instance"....
>>> hmm i typed in mysql and it said it wanted switches...
>>> i typed in mysql \h and i got all the switches for other parameters.
>>> ok now i did this sounds like it s running? but what can i give as a
>>> command to see the server is running?
>> Usually it's registered as a service, and you can see it running there.
>>
>> Just try a 'mysql' (without any switches), if you get a response,
>> especially something about missing or wrong credentials, the mysql deamon
>> is definitely running :P
>>
>> Most common switches would be -u for username, -p for password, -h for
>> host.
>> --
>> Rik Wasmus
>
> Thank you for your post.
> I looked in the control panel for installed software and the mysql
> server is there.
> When i loaded the software i noticed it was loading the server,
> command shell, command utils and server instance config
>
> When i go into control panel and go into services i see that there is
> no mysql service listed there.
> Now i am REALLY confused. Everything seems to logical and up front but
> its not working as expected?
> Now i am thinking now what? I dont any idea of what to do next?...help!

try running:
mysqladmin version

if you see this:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password:
NO)'

this will mean MySQL is running, even if it does not show in SERVICES.

if it is running type:
mysql -u root

you should get the mysql-prompt.
(unless there is a default password in a Windows config... )



--
Luuk

On Mar 12, 11:50 am, Luuk <L...@invalid.lan> wrote:
> newbie schreef:
>
>
>
> > On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> >> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
> >>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
> >>>> newbie schreef:
> >>>>> I wonder if someone can lend me a hand here? I dont have any database
> >>>>> experience.
> >>>>> I used this
> >>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> >>>>> first-start.html
> >>>>> I used this command:
> >>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
> >>>>> I got this error, and i dont know how to respond to fix it. I do use
> >>>>> anti virus.
> >>>>> InnoDB operating system error number 32 in a file operation
> >>>>> InnoDB the error meabs that another program is using InnoDB s file
> >>>>> name
> >>>>> InnoDB of mysql please close it to get rid of this error
> >>>>> This might be a back or antivirus software or another instance
> >>>>> Can anyone please help me?
> >>>>> Andrew
> >>>> try:
> >>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
> >>>> probabley MySQL is already running
> >>>> at the end of the error-message is "or another instance"....
> >>> hmm i typed in mysql and it said it wanted switches...
> >>> i typed in mysql \h and i got all the switches for other parameters.
> >>> ok now i did this sounds like it s running? but what can i give as a
> >>> command to see the server is running?
> >> Usually it's registered as a service, and you can see it running there.
>
> >> Just try a 'mysql' (without any switches), if you get a response,
> >> especially something about missing or wrong credentials, the mysql deamon
> >> is definitely running :P
>
> >> Most common switches would be -u for username, -p for password, -h for
> >> host.
> >> --
> >> Rik Wasmus
>
> > Thank you for your post.
> > I looked in the control panel for installed software and the mysql
> > server is there.
> > When i loaded the software i noticed it was loading the server,
> > command shell, command utils and server instance config
>
> > When i go into control panel and go into services i see that there is
> > no mysql service listed there.
> > Now i am REALLY confused. Everything seems to logical and up front but
> > its not working as expected?
> > Now i am thinking now what? I dont any idea of what to do next?...help!
>
> try running:
> mysqladmin version
>
> if you see this:
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' (using password:
> NO)'
>
> this will mean MySQL is running, even if it does not show in SERVICES.
>
> if it is running type:
> mysql -u root
>
> you should get the mysql-prompt.
> (unless there is a default password in a Windows config... )
>
> --
> Luuk

Say, that was really helpful! thanks
I got error, cant connect to mysql server on local host 10061
check that mysql is running on local host and that the port is 3306.
It says that you can check this by doing a telnet local host 3306.

May i ask what to do now that we know the server isnt running?

newbie schreef:
> On Mar 12, 11:50 am, Luuk <L...@invalid.lan> wrote:
>> newbie schreef:
>>
>>
>>
>>> On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>>>> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
>>>>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
>>>>>> newbie schreef:
>>>>>>> I wonder if someone can lend me a hand here? I dont have any database
>>>>>>> experience.
>>>>>>> I used this
>>>>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
>>>>>>> first-start.html
>>>>>>> I used this command:
>>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>>>>>>> I got this error, and i dont know how to respond to fix it. I do use
>>>>>>> anti virus.
>>>>>>> InnoDB operating system error number 32 in a file operation
>>>>>>> InnoDB the error meabs that another program is using InnoDB s file
>>>>>>> name
>>>>>>> InnoDB of mysql please close it to get rid of this error
>>>>>>> This might be a back or antivirus software or another instance
>>>>>>> Can anyone please help me?
>>>>>>> Andrew
>>>>>> try:
>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>>>>>> probabley MySQL is already running
>>>>>> at the end of the error-message is "or another instance"....
>>>>> hmm i typed in mysql and it said it wanted switches...
>>>>> i typed in mysql \h and i got all the switches for other parameters.
>>>>> ok now i did this sounds like it s running? but what can i give as a
>>>>> command to see the server is running?
>>>> Usually it's registered as a service, and you can see it running there.
>>>> Just try a 'mysql' (without any switches), if you get a response,
>>>> especially something about missing or wrong credentials, the mysql deamon
>>>> is definitely running :P
>>>> Most common switches would be -u for username, -p for password, -h for
>>>> host.
>>>> --
>>>> Rik Wasmus
>>> Thank you for your post.
>>> I looked in the control panel for installed software and the mysql
>>> server is there.
>>> When i loaded the software i noticed it was loading the server,
>>> command shell, command utils and server instance config
>>> When i go into control panel and go into services i see that there is
>>> no mysql service listed there.
>>> Now i am REALLY confused. Everything seems to logical and up front but
>>> its not working as expected?
>>> Now i am thinking now what? I dont any idea of what to do next?...help!
>> try running:
>> mysqladmin version
>>
>> if you see this:
>> mysqladmin: connect to server at 'localhost' failed
>> error: 'Access denied for user 'ODBC'@'localhost' (using password:
>> NO)'
>>
>> this will mean MySQL is running, even if it does not show in SERVICES.
>>
>> if it is running type:
>> mysql -u root
>>
>> you should get the mysql-prompt.
>> (unless there is a default password in a Windows config... )
>>
>> --
>> Luuk
>
> Say, that was really helpful! thanks
> I got error, cant connect to mysql server on local host 10061
> check that mysql is running on local host and that the port is 3306.
> It says that you can check this by doing a telnet local host 3306.
>
> May i ask what to do now that we know the server isnt running?

this:
netstat -anb | findstr /i "mysql"

should show something like:
TCP 127.0.0.1:3306 127.0.0.1:3595 TIME_WAIT 0
[mysqld.exe]
(especially the ":3306" is important here ...)

if this line does not show,( or no lines shows), than MySQL is not running.


--
Luuk

On Mar 12, 12:07 pm, Luuk <L...@invalid.lan> wrote:
> newbie schreef:
>
>
>
> > On Mar 12, 11:50 am, Luuk <L...@invalid.lan> wrote:
> >> newbie schreef:
>
> >>> On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> >>>> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
> >>>>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
> >>>>>> newbie schreef:
> >>>>>>> I wonder if someone can lend me a hand here? I dont have any database
> >>>>>>> experience.
> >>>>>>> I used this
> >>>>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> >>>>>>> first-start.html
> >>>>>>> I used this command:
> >>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
> >>>>>>> I got this error, and i dont know how to respond to fix it. I do use
> >>>>>>> anti virus.
> >>>>>>> InnoDB operating system error number 32 in a file operation
> >>>>>>> InnoDB the error meabs that another program is using InnoDB s file
> >>>>>>> name
> >>>>>>> InnoDB of mysql please close it to get rid of this error
> >>>>>>> This might be a back or antivirus software or another instance
> >>>>>>> Can anyone please help me?
> >>>>>>> Andrew
> >>>>>> try:
> >>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
> >>>>>> probabley MySQL is already running
> >>>>>> at the end of the error-message is "or another instance"....
> >>>>> hmm i typed in mysql and it said it wanted switches...
> >>>>> i typed in mysql \h and i got all the switches for other parameters.
> >>>>> ok now i did this sounds like it s running? but what can i give as a
> >>>>> command to see the server is running?
> >>>> Usually it's registered as a service, and you can see it running there.
> >>>> Just try a 'mysql' (without any switches), if you get a response,
> >>>> especially something about missing or wrong credentials, the mysql deamon
> >>>> is definitely running :P
> >>>> Most common switches would be -u for username, -p for password, -h for
> >>>> host.
> >>>> --
> >>>> Rik Wasmus
> >>> Thank you for your post.
> >>> I looked in the control panel for installed software and the mysql
> >>> server is there.
> >>> When i loaded the software i noticed it was loading the server,
> >>> command shell, command utils and server instance config
> >>> When i go into control panel and go into services i see that there is
> >>> no mysql service listed there.
> >>> Now i am REALLY confused. Everything seems to logical and up front but
> >>> its not working as expected?
> >>> Now i am thinking now what? I dont any idea of what to do next?...help!
> >> try running:
> >> mysqladmin version
>
> >> if you see this:
> >> mysqladmin: connect to server at 'localhost' failed
> >> error: 'Access denied for user 'ODBC'@'localhost' (using password:
> >> NO)'
>
> >> this will mean MySQL is running, even if it does not show in SERVICES.
>
> >> if it is running type:
> >> mysql -u root
>
> >> you should get the mysql-prompt.
> >> (unless there is a default password in a Windows config... )
>
> >> --
> >> Luuk
>
> > Say, that was really helpful! thanks
> > I got error, cant connect to mysql server on local host 10061
> > check that mysql is running on local host and that the port is 3306.
> > It says that you can check this by doing a telnet local host 3306.
>
> > May i ask what to do now that we know the server isnt running?
>
> this:
> netstat -anb | findstr /i "mysql"
>
> should show something like:
> TCP 127.0.0.1:3306 127.0.0.1:3595 TIME_WAIT 0
> [mysqld.exe]
> (especially the ":3306" is important here ...)
>
> if this line does not show,( or no lines shows), than MySQL is not running.
>
> --
> Luuk

Luuk,
You are correct! using that cool netstat command resulted in no mysql
running!
Well i thought that if i ran the download to install the db then
everything would be present.
I know there is software installed on the hard drive. In the pc OS
registry, i see software from mysql.....
So could i ask ? now that we know its not running? how do we get the
server up and running?

newbie schreef:
> On Mar 12, 12:07 pm, Luuk <L...@invalid.lan> wrote:
>> newbie schreef:
>>
>>
>>
>>> On Mar 12, 11:50 am, Luuk <L...@invalid.lan> wrote:
>>>> newbie schreef:
>>>>> On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>>>>>> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
>>>>>>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
>>>>>>>> newbie schreef:
>>>>>>>>> I wonder if someone can lend me a hand here? I dont have any database
>>>>>>>>> experience.
>>>>>>>>> I used this
>>>>>>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
>>>>>>>>> first-start.html
>>>>>>>>> I used this command:
>>>>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
>>>>>>>>> I got this error, and i dont know how to respond to fix it. I do use
>>>>>>>>> anti virus.
>>>>>>>>> InnoDB operating system error number 32 in a file operation
>>>>>>>>> InnoDB the error meabs that another program is using InnoDB s file
>>>>>>>>> name
>>>>>>>>> InnoDB of mysql please close it to get rid of this error
>>>>>>>>> This might be a back or antivirus software or another instance
>>>>>>>>> Can anyone please help me?
>>>>>>>>> Andrew
>>>>>>>> try:
>>>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
>>>>>>>> probabley MySQL is already running
>>>>>>>> at the end of the error-message is "or another instance"....
>>>>>>> hmm i typed in mysql and it said it wanted switches...
>>>>>>> i typed in mysql \h and i got all the switches for other parameters.
>>>>>>> ok now i did this sounds like it s running? but what can i give as a
>>>>>>> command to see the server is running?
>>>>>> Usually it's registered as a service, and you can see it running there.
>>>>>> Just try a 'mysql' (without any switches), if you get a response,
>>>>>> especially something about missing or wrong credentials, the mysql deamon
>>>>>> is definitely running :P
>>>>>> Most common switches would be -u for username, -p for password, -h for
>>>>>> host.
>>>>>> --
>>>>>> Rik Wasmus
>>>>> Thank you for your post.
>>>>> I looked in the control panel for installed software and the mysql
>>>>> server is there.
>>>>> When i loaded the software i noticed it was loading the server,
>>>>> command shell, command utils and server instance config
>>>>> When i go into control panel and go into services i see that there is
>>>>> no mysql service listed there.
>>>>> Now i am REALLY confused. Everything seems to logical and up front but
>>>>> its not working as expected?
>>>>> Now i am thinking now what? I dont any idea of what to do next?...help!
>>>> try running:
>>>> mysqladmin version
>>>> if you see this:
>>>> mysqladmin: connect to server at 'localhost' failed
>>>> error: 'Access denied for user 'ODBC'@'localhost' (using password:
>>>> NO)'
>>>> this will mean MySQL is running, even if it does not show in SERVICES.
>>>> if it is running type:
>>>> mysql -u root
>>>> you should get the mysql-prompt.
>>>> (unless there is a default password in a Windows config... )
>>>> --
>>>> Luuk
>>> Say, that was really helpful! thanks
>>> I got error, cant connect to mysql server on local host 10061
>>> check that mysql is running on local host and that the port is 3306.
>>> It says that you can check this by doing a telnet local host 3306.
>>> May i ask what to do now that we know the server isnt running?
>> this:
>> netstat -anb | findstr /i "mysql"
>>
>> should show something like:
>> TCP 127.0.0.1:3306 127.0.0.1:3595 TIME_WAIT 0
>> [mysqld.exe]
>> (especially the ":3306" is important here ...)
>>
>> if this line does not show,( or no lines shows), than MySQL is not running.
>>
>> --
>> Luuk
>
> Luuk,
> You are correct! using that cool netstat command resulted in no mysql
> running!
> Well i thought that if i ran the download to install the db then
> everything would be present.
> I know there is software installed on the hard drive. In the pc OS
> registry, i see software from mysql.....
> So could i ask ? now that we know its not running? how do we get the
> server up and running?

i googled the error message:
http://www.google.com/search?source=...e+zoeken&meta=
(or this one: http://tinyurl.com/29gk44 )

the first link is this:
http://bugs.mysql.com/bug.php?id=9709

its a long story, so i did not read the entire story ;-)

--
Luuk