Deploying MySQL Community Server - How?

[Miscbrah]

Hello all,

 

I'm tearing my hair out and my socks off over this. We use wpkg here (though I can make use of an msi, for anyone who's not heard of that) and I'm failing horribly to install MySQL server silently at all. They provide an msi, but that only installs the pre-setup, which then prompts users (potentially students) with all sorts of HORRIBLE queries before crashing out.

 

Has anyone installed this before? Please halp. :/

 

Thanks for any and all pointers. Except "give up."

 

[danbuntu]

do you need to install it locally and not just install it centrally and give students a DB?

[howartp]

do you need to install it locally and not just install it centrally and give students a DB?

Ditto!

 

With the exception of our programming VMs, which have it installed locally, I go for this approach.

 

Peter

[Miscbrah]

I, er, dunno!

 

I mean, I guess I REALLY don't know what it does.

 

Anyone explain quick or am I best going away and trying to find out a bit more?

 

Bless you guys.

[zag]

Just run it on a central web server, and create accounts for the students to use.

 

The Microsoft web platform installer will do it all for you if your using IIS.

[Miscbrah]

Just run it on a central web server, and create accounts for the students to use.

 

The Microsoft web platform installer will do it all for you if your using IIS.

 

Zag thanks so much for that reply. Okay, this is way more complicated than I thought.

 

I know nothing about IIS or MySQL. TBH I thought it'd just be a case of installing a bit of software like any other onto PCs. Yeesh, I've bitten off more than I can chew.

 

So, with this approach (I apologise greatly as this is about to get painful) I set up a student IIS server, lock it down a bit somehow, install this software on it, they all have accounts created, and all have a client on the PCs too, then do their MySQL business?

 

If that's about right I'll go away and research it some more, and if there's ANYTHING along the lines of getting this set up you have written down, or any bone you can throw me I'll be very VERY grateful (we're talking beer in the post etc.)

 

Thanks so much!

[zag]

Yep thats about right.

 

Once MYSQL is installed you can connect to it using a simple url and port.

 

I install phpmyadmin myself to mess around with users and databases. But you can use the mysql GUI client if you want.

 

You might want to take a look at WampServer, la plate-forme de développement Web sous Windows - Apache, MySQL, PHP as well, if you want it really easy just running on any windows pc.

[Miscbrah]

So... I can install whatever that is on, say a teacher PC and then some kind of client on student PCs? Have I got that right?

 

You're a kind person btw.

[zag]

Yep its normally meant for developers to install on their laptops or whatever, but works just as well on any PC you choose.

[Decimas6]

I have done this here. We dug out an old server, installed MySQL Server (MSI at: https://dev.mysql.com/downloads/mysql/) on to it. Then installed workbench (same MSI, but only Workbench this time). When you first load up work bench as a user, you'll need to add a connection to the server, which for us is simply the server name under "hostname". Then users can log on using the account and password we made them in SQL Workbench under users.

[Miscbrah]

Cheers all for the info.

 

In the end I had to read up a bit more and got myself fully informed on the controlled assessment. Looks like they will need *sigh* local installs of MySQL and only that will do. They'll run scripts that create databases and 'do' everything on the fly. Good job too as there's no way to redirect datadir (at least no way I can get to work) to home drives anyway.

 

Whole thing's just a bit of a shower but I'm more knowledgeable thanks to everyone's help.

[mavhc]

There's many parts to MySQL, which do you need? https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html

 

Also https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html might be of help