Help me set up a SQL server

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Help me set up a SQL server

Post 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.
Image
Nuke
Registered User
Posts: 3515
Joined: 28 Feb 2004, 02:00
Processor: Xeon E5620
Motherboard: Asus P6T6 Workstation
Graphics card: MSI GTX770
Memory: 24GB Hynix
Location: ::1

Re: Help me set up a SQL server

Post by Nuke »

"apt-get install mysql-server". Go drink some coffee. :)
Image
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Help me set up a SQL server

Post 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++
Most people would sooner die than think; in fact, they do so - Bertrand Russel
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Re: Help me set up a SQL server

Post 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...
Image
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Help me set up a SQL server

Post 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... :|
Most people would sooner die than think; in fact, they do so - Bertrand Russel
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Re: Help me set up a SQL server

Post by DarkRanger »

Ok, thanks for the heads up. We're expecting around 150 at peak... lol. So you would suggest getting linux on there?
Image
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Help me set up a SQL server

Post 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...
Most people would sooner die than think; in fact, they do so - Bertrand Russel
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Re: Help me set up a SQL server

Post by DarkRanger »

Ok cool.

I'll run this past kenny. I don't think he'll be pleased. :lol:
Image
Kennyisalive
Registered User
Posts: 17269
Joined: 26 Feb 2007, 02:00
Contact:

Re: Help me set up a SQL server

Post by Kennyisalive »

DR :violent1: Kenny

OK OK I will go do this!!! Will keep you all updated!!
Don't Click me
Image
Forum Points:10018000
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Re: Help me set up a SQL server

Post by DarkRanger »

Kenny, how far is that server?
Image
Kennyisalive
Registered User
Posts: 17269
Joined: 26 Feb 2007, 02:00
Contact:

Re: Help me set up a SQL server

Post by Kennyisalive »

About 10 meters from my office
Don't Click me
Image
Forum Points:10018000
DarkRanger
Registered User
Posts: 8346
Joined: 10 May 2006, 02:00
Processor: Intel i5-3750
Motherboard: Gigabyte
Graphics card: nVidia GTX 550Ti
Memory: 8GB Jetram
Contact:

Re: Help me set up a SQL server

Post by DarkRanger »

:lol: Smartass :lol:
Image
Kennyisalive
Registered User
Posts: 17269
Joined: 26 Feb 2007, 02:00
Contact:

Re: Help me set up a SQL server

Post by Kennyisalive »

:study:
Don't Click me
Image
Forum Points:10018000
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Help me set up a SQL server

Post by rustypup »

what lamp are you looking at?
Most people would sooner die than think; in fact, they do so - Bertrand Russel
DeeVeeDee
Registered User
Posts: 172
Joined: 09 Apr 2010, 15:18

Re: Help me set up a SQL server

Post 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.
_̴ı̴̴̡̡̡ ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡ ̡͌l̡̡̡
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Help me set up a SQL server

Post 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
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Post Reply