[Page 1, 2 Next]

Topic: need help with mysql. (mysqld-nt.exe --install wont work)

[1]

Topic: need help with mysql. (mysqld-nt.exe --install wont work)

[Jakesy-2K8]

..... be patient however i am a very fast learner and i have installed apache server before but it was a old 1

so what i need help with is im installing the apache tutorial thats on here at the moment,but i have done this much upto yet .....

Install the Microsoft VC++ Redistributable
The reason for this is because it is NOT included in the latest versions of Windows; and Steffen's builds are compiled using Microsoft Visual C++ 2008. See the Readme in the httpd-2.2.x-win32-x86-ssl.zip from http://www.apachelounge.com/download/

Apache Setup
Download httpd-2.2.x-win32-x86-ssl.zip from http://www.apachelounge.com/download/

Note: you can substitue drive letters to what will work best for you or your situation. I advise however, that you DO NOT place PHP in the Apache root though.

Unzip this ZIP file in a new folder called something like C:\Apache2. Then, read the file named Read Me First !!.txt. It will tell you how to setup the service for Apache. If you want or need ApacheMonitor you can create shortcuts however you like. Before installing ANYTHING else, ensure Apache will start. Open a command prompt and navigate to the BIN folder of Apache:

1. At the prompt enter httpd
2. If there's anything seriuosly wrong Apache will not start - the cursor will drop down one line and blink (you should be able to use your browser and navigate to http://localhost and see "It Work!".
3. With focus on the Command Prompt window - Hold down CTRL hit the C key then release both - within a couple of seconds the prompt will be released (Apach will Stop).

After you validate that Apache starts, stop it before proceding.

but the part i am stuck on is this

at the prompt enter httpd and so on

how can i test to see if apache starts

and is a dos box a cmd boxi unzip'd apache to c:/ is that right?

and also

thanks

[Jakesy-2K8]

its ok i think i get it now

i have got a dos box up from c:\apache 2\bin\httpd.exe

but it wont let me type nothing in there ??

[James Blond]

You don't need to type anything in! Just open your browser and open http://localhost

You may read A Fast, Reliable and Proven Setup :: Apache PHP MySQL Perl

if you still have a question please post here again.

[Jakesy-2K8]

thats the tutorial that i bin following but i dont get the first part

and when i put http://localhost in my browser it just says page cannot be displayed

right all i done from scratch is

1 install the redist package that it says on here from microsoft

2 unzip apache 2 to C:\

and dont get the next ,i am really sorry about this and thank you.

[admin]

Jakesy-2K8:

Please use a meaningful, specific subject header, hi all can any1 help me as i am a beginner at this so please makes no sense. And repeating the guide is also not a good idea.

See the forum rules at http://www.apachelounge.com/viewtopic.php?t=106

unzip apache 2 to C:\ : after unzipping you should have c:\apache2\bin, c:\apache2\config etc. etc.

in a Dos box httpd.exe: If there's anything seriuosly wrong Apache will not start - when it starts then the cursor will drop down one line and blink

[Jakesy-2K8]

ok sorry about that i will make sure that it is meaningful in the future and sorry i didnt have apache started when i went to localhost and it has come up as it works so i will carry on now thank you

[Jakesy-2K8]

ok can any1 tell me where i can find httpd -k installis so i can install

i have looked in the bin folder but i cant see it any where, the only httpd i can see is the 1 that starts the dos box thanks


and also what does this mean ...

THIS MUST BE ACCOMPLISHED (see note below): Add the folder that you put the PHP files into in the PATH ENVIRONMENT (System Properties | Advanced | Environment Variables | System variables | Path).

Example:

Variable name: Path
Variable value: C:\php5;%SystemRoot%\system32;.....

[glsmith]

[Jakesy-2K8]

ok thank you for your great help however cd\apache2\bin works in cmd but others dont


sorry it is working now

[peacemaker]

hi Jakesy-2K8.
I was stucked a bit of different problem. But with the help of james blond i solved the problem. I use the same file for installing php. Wat i would like to sugges u is that. download the zip file and straight away extract that file to the desired directory of php where u want to install. After that do the path settings as given below the turorial of Steffen

"THIS MUST BE ACCOMPLISHED (see note below): Add the folder that you put the PHP files into in the PATH ENVIRONMENT (System Properties | Advanced | Environment Variables | System variables | Path). "

Do the above task and then include the directory path,load module statemets in the httpd.config file of apache. After that start apache hope ur php will start working.

After that test in ur browser

http:\\localhost

if everything is write then u will see the result as
"It Works" will come on screen. and then try the function

<?php
phpinfo();
?>

if it works the ur php is properly installed. If this is not the proper answer for ur question the i am sorry for that. Else give this a try.

If u want u can read the problem that i had and solution that James gave me in this forum.

[Jakesy-2K8]

thanks for your help mate but i already gone past and done that bit and it is working lol thank you anyway

[Jakesy-2K8]

hi im stuck on the bit that says copy the my-large.ini to my.ini but i cant see any my.ini in mysql folder all i see is my-huge.ini my-large.ini my-small.ini my medium.ini and my-innodb-heavy-4g.ini

so which 1 does the copy of my-large.ini go thanks

also it wont work when i type mysqld-nt.exe --install
it says it doesnt recognise it so what am i doing wrong cheers


also what does it mean when it says edit my.ini and change the parameters for your site.

thank you all for your help

[glsmith]

How about copy my-large.ini then rename it my.ini

It's was is meant by that statement

If your DOS box were in the mysql folder you could type something this which would do just that, copy renamed


copy my-large.ini my.ini

then you would see both files

G

[Jakesy-2K8]

sorry but i must be a little thick lol could you be more specific for me

i am sorry bout this and thanks very much

oh yes i also copied my-large.ini and renamed it to my.ini and put it in mysql
but i havent changed any parameters in there because i dont no what to change
and i am wanting a forum from all this lol plus i dont no what else i can do besides put my files in there so ppl can download them as a ftp am i right about that

[Jakesy-2K8]

so can any1 help me then or not

i no i am annoying but every1 has to start from begining dont they
and plus thats what this thread is for yh

cheers

[James Blond]

You can use which brings a msi file with GUI Wizzard to configure mysql. That is easier for you! After installation you can view the my.ini And learn a bit more how to configure mysql server.

[Jakesy-2K8]

ok thank you mate but i can already open the my.ini up with notepad or something like but i still dont no what to edit and that and also when i do that mysqld-nt.exe --install (coz thats the part that i have got to) in cmd it just says that it is not a recognised file for some reason so thats the part i am stuck on

And i am also wanting a forum out of all this so i hope that is possible.

I have installed the old apache and php and mysql but they was the older versions and it was on another pc plus it wasnt like this it was just with the installers if you get me,so i would very much apreciate it if you could help me through this cheers mate

[Jakesy-2K8]

can any 1 please help me coz i have been stuck on this bit for a few days now and i dont understand the things that you are telling me to do
im sorry and i dont mean that in a nasty way its just that i am a little stupid lol well i am a learner after all


if any1 would like to help me they are very welcome

thank you all!

[James Blond]

If you don't want to use the installer see the docs for that

http://dev.mysql.com/doc/refman/5.1/en/windows-create-option-file.html
and
http://dev.mysql.com/doc/refman/5.1/en/mysql-config-wizard-editing.html

[Jakesy-2K8]

thanks mate

but its ok doing it this way

the bit that i have got to is this ...

MySQL Setup


1. Download from mysql.com community downloadpage --> Windows downloads -- Without installer (unzip in C:\) --> » No thanks, just take me to the downloads!
2.Unzip the mysql-noinstall-5.x.xx-win32.zip to e.g. C:\ rename it to mysql
3. Uninstall any previous MySQL Windows service


all that above i have done as it says but this bit below ...

4. Copy one of the MySQL\*.ini files (usually my-large.ini) to MySQL\my.ini
5. Edit my.ini and change any parameters for your site.
6. You can install mysqld.exe as a Windows service with
(see also : http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html )



Code:

mysqld-nt.exe --install


After you install the service be sure to:

Secure the initial MySQL accounts MySQL access controls. Be aware that default both root and the anonymous account are set up with no password, so anyone can connect to the MySQL server as root.

i cant do coz when i put mysqld-nt.exe --install the cmd window doesnt recognize it so dont i have to put something else in the cmd window 1st or when i open the cmd window do i just put mysqld-nt.exe --install in

thanks mate