Installing mysql on Win XP

[Stovio]

I know this is as basic as it gets but if someone would help i'd be greatful.

I have never worked with mysql and am trying to install it on winxp. Im following a step by step tutorial. After installing the binary the tutorial says this:

"If you are a MySQL virgin and you've never installed MySQL before, you need to create the default permissions, so type ... scripts/mysql_install_db to set these up. "

Where should i type this? In the command line? That doesn't work because mysql_install_db is not an executable. Do i need to install some perl interpretor?
The tutorial later says:

"Typing mysql.server start starts the server, and mysql.server stop stops the server."

Where should this be written and how do i make sure it works?

Again, sorry if im taking up your time with basics but no basic tutorial i've seen explains this so that i get it. Thanks.

 

[QatQat]

That scripts only works for the Linux version.

For XP version, just install the right server as a service


c:\mysql\bin\mysqld.exe -install

Then Restart your computer.

At first just login without password

c:\mysql\bin\mysql -u root (press enter)

Then, at Mysql prompt set the root user's permissions


grant all
on *.*
to root@'%'
identified by "your_password"
WITH GRANT OPTION
;
(press enter)
Bye

At next login you have to sepcify the password you have chosen

c:\mysql\bin\mysql -u root -p (press enter)


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[piti]

i think this applies only to the *nix install of mysql, when installing the win build, the default databases with permisions set should be created
on xp - open the services console and there should be a new service named mysql and start it from there

 

[QatQat]

As I wrote before


Mysql does not install itself as a service but you have to do it manually


c:\mysql\bin\mysqld -install


Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[piti]

well, i was building a computer for a friend of mine this weekend and did not run mysqld -install and the service was there, so i thought it's common behaviour
if not then sorry

 

[Schroeder]

I have just installed on XP as well. Although I never even went to a command prompt, the service is now running on my machine. I have however run winmysqladmin.exe which may well have set that up for me. I do believe the default databases (mysql and test) were set up by the installer before any services were installed or started.

 

[Stovio]

Thanks for all the help. I guess the Unix commands confused me enough to not realise that it actualy already was up and running (it seems to be, the service is running now anyway). Now on to the PHP part, I might consult you all later...

 

[strella]

There is a *nix free HowTo MYSQL for Windows users starting off with mysql at

http://www.roninsoftwaregroup.com/mysql/winhowto.htm

and Schroeder is right, WinMySQLAdmin.EXE does tend to set things up such as an INI in the %WinDir%. WinMySQLAdmin is very handy, and the explicit commands for MySQLd.exe and its variants give you command parameters for more control.