installing mysql...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Nit
Forum Newbie
Posts: 5
Joined: Mon May 27, 2002 6:00 am
Location: Israel
Contact:

installing mysql...

Post by Nit »

I downloaded MySql but I'm having problems installing it (I'm using windows 2000 + iis 5), how do I do it?
thanks
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

probably you've downloaded mysql-3.23.47-win.zip. This is a quick, very basic way of installing it.
  1. extract it
  2. run the contained setup.exe (self-explainary)
  3. copy my-example.cnf to c:\ and rename it to my.cnf
  4. edit my.cnf remove # from
    • #basedir = d:/mysql/ basedir - is what you typed in as installation directory during setup
    • #datadir = d:/mysql/data/ - datadir you may choose freely but make sure the directory exists when you start up your mysql-server and use / instead of \
  5. install mysql as service: from the commandline in <mysql-basedir>\bin you call 'mysql-nt.exe -install' or 'mysqld-max-nt.exe -install'
The server will start automatically the next time you start your windows. If you'd like to start it now manually use the commandline and type 'net start mysql' or use the services panel where you may also change the start-type if you don't like mysql starting on boot time


3 & 4) you may skip these steps if you've installed mysql in c:\mysql
if you change the datadir copy the contents of the original datadir to the new one
Post Reply