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