Page 1 of 1

Help me set up a SQL server

Posted: 10 Mar 2010, 16:08
by DarkRanger
Hi,

We are interested in setting up an intraweb for our company. I would like to know if anyone knows of a good step by step tutorial/process/guide that will allow me to set up a mySQL server on the server that will be hosting the intraweb. The server is currently running Apache for hosting the intraweb.

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:27
by Nuke
"apt-get install mysql-server". Go drink some coffee. :)

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:29
by rustypup
what is apache currently running on?, (wamp/lamp)

mysql setup couldn't be simpler if they were to include cake and a cup of whisk... tea...

Nuke++

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:30
by DarkRanger
Apache is currently running on Windows XP.

That is what's hosting the site locally.

Remember that thing you helped us out with yesterday rusty? Regarding DNS and stuff? This is now just to allow me to use mySQL on the intraweb...

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:35
by rustypup
Windows Setup at dev.mysql

don't forget to grab workbench while you're at it...

<edit>seriously contemplate getting it off of XP if you're expecting more than 15 users.... XP sucks at this... :|

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:43
by DarkRanger
Ok, thanks for the heads up. We're expecting around 150 at peak... lol. So you would suggest getting linux on there?

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:51
by rustypup
err.. guess :lol:...

a lamp setup will cost you.... nothing... except some time and effort getting to grips with CLI, (unless you're comfortable with tools like webmin) - you will also need to do some fiddling with kerebos/samba with respect to your AD...

a 2003 setup will cost you... and keep costing you... for half the performance...

Re: Help me set up a SQL server

Posted: 10 Mar 2010, 16:52
by DarkRanger
Ok cool.

I'll run this past kenny. I don't think he'll be pleased. :lol:

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 12:24
by Kennyisalive
DR :violent1: Kenny

OK OK I will go do this!!! Will keep you all updated!!

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 12:44
by DarkRanger
Kenny, how far is that server?

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 12:52
by Kennyisalive
About 10 meters from my office

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 14:08
by DarkRanger
:lol: Smartass :lol:

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 14:12
by Kennyisalive
:study:

Re: Help me set up a SQL server

Posted: 11 Mar 2010, 14:15
by rustypup
what lamp are you looking at?

Re: Help me set up a SQL server

Posted: 09 Apr 2010, 16:22
by DeeVeeDee
rustypup wrote: except some time and effort getting to grips with CLI, (unless you're comfortable with tools like webmin)
.
PHP MyAdmin ?

If you chose to go linux just use ubuntu desktop or server and install Apache after that mySQL then PHP and then PHPMyadmin via its Synaptic manger or Apt Get.
Ive done it plenty times and never had issues.

Re: Help me set up a SQL server

Posted: 09 Apr 2010, 16:31
by rustypup
DeeVeeDee wrote:If you chose to go linux just use ubuntu desktop or server
cool.. another linux user... :D

DR hasn't been heard from in a while... so we suspect something along the lines of:
Image