MySQL Installation

[meastaugh1]

Hi,

can somebody tell me how to install mysql properly. These are the steps I have followed:
1) download and run the setup with all components installing.
2) start winmysqladmin, install and run the service.

after reaching this point, and trying to run the service Win 2k pro says that it can't start it on the local computer, err 1067 process terminated unexpectedly.

The only time I seem to be able to start mysql server is by opening a command prompt and running in standalone mode 'mysqld-nt --standalone'. After running this, it does not seem to finish the command as the window does not return to a command prompt. however, when I go back into winmysqladmin it seems to be running.

Erm, any ideas, please?

 

[meastaugh1]

I was trying to install to a drive different to the default so installed it to C and it worked.

 

[RougeDev]

Are you using apache & php too???

I downloaded phpTriad, It gives u php+apache+mysql in a single hit, installs fine on WIN98 and I belive it does so on WIN2K.

Get it here:

http://sourceforge.net/projects/phptriad

It installs itself in C:\apache under here u will find a dir named mysql, go into the bin dir under mysql and run mysqld.exe or mysqld-nt.exe

Or u could just start either of these from Start > Programs > PHPTriad > MYSQL > MYSQL-D/MYSQL-DNT

Now when u run this it pops up a window that dissapears, but the mysql server is now running in the background, to check this do a CTRL+ATL+DEL and look for mysqld* process

Worth noting tho is that this an older version of apache and has some security risks, for the lastest version go to:

http://www.apache.org/dist/httpd/

Hope this helped somewhat

 

[ToeShot]

it does finish the comand it just does'nt give you a prompt becuase it is running.
you will have a my.ini file (should be in your system directory) and you need to make sure the settings are correct in it.


[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld-opt.exe <location of the MysqlServer
user=root <user name
password=1111 <user password will be different for yours
QueryInterval=10

[mysqld]
basedir=C:/MYSQL <location of the Mysql installation directory
#bind-address=127.0.0.1 <believe it is the IP address host machine that has the mysql server. Check Documentation
datadir=C:/MYSQL/data
#language=C:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M


HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait