Hi, I've just installed mysql on solaris 10. eg

Quote: gunzip -c mysql-5.0.18.tar.gz | tar xvf - cd mysql-5.0.18 ./configure make make install

Although I am reading the mysql manuel, I am pretty confused on how to actually set it up. Like I'm supposed to create a new user/group or so. Basically I need some kind of list of steps on what to do now. Thanks

Some good info here to start with.
Note that you should use some options with the configure script so you can do

# make uninstall (remove the currently installed files first)
# ./configure
# make
# make install

part over again with the options to configure mentioned in the howto.
Hopefully it works for Solaris and MySQL version 5 too ^^

[Edited by - pulpfist on February 1, 2006 2:13:31 AM]

I recommend that you go to sunfreeware.com and use a precompiled mysql package - it's more likely to do what you want and be easy to install.

Also using a premade package will sort out creating users and startup / shutdown scripts - starting mysql as a system service etc.

If you build it yourself, you'll find you need to do these things manually.

Mark

have you looked here?

great reference

Thanks guys, after reading the manuel a bit more, i think i know how it all works now.

Note on a common hang-up;
When you create the database, make sure you're logged in as mysql. If you're root, then mysql can't read the DB, if you're a regular user, then you can't create the files.

Sounds obvious, but I swear 99% of screwed up installs are for that reason.