I'm trying to create a database on a server at work. IT has given me permission to do so, but I really have no idea what I'm doing (doesn't开发者_如何学Python that just scream confidence...). To give a bit of background information:
1) On the 'server', it is basically a shared drive at work. They have given me 'server space', which is basically a file folder that I can use and give access to select users.
2) Only a few people would use this thing, and I only really need a basic basic database. I've worked with mySQL databases before a bit, but only as (localhost). This server will simply have one table (wooo!) and will eventually, hopefully, be part of a C# program I'm creating to interact with it..
3) I have MySQL Workbench, if that makes things easier.
Basically what I'm wondering, is how do I set up a database on a server? Is it significantly different than creating one locally? Is it just a file I have to drag into this folder I'm given? I have a feeling I have to install something on the server, but I dont' know how / what...
Any help, tips etc is much appreciated! Cheers
You need to be able to install software on your server. The MySQL installation process is pretty simple - but it is environment specific, so the windows flavour is different to the Linux/unix flavour. The MySQL site has lots of info on how to do this (http://dev.mysql.com/doc/refman/5.1/en/installing.html).
Installing it is simple, but as it's open source and runs as a daemon/service, most IT departments get a bit antsy. You also need to make sure the network port on which the service "listens" is accessible to the various clients of your app.
Once installed, you need to make sure the MySQL Server starts whenever the machine is rebooted, and runs without specific user privileges (these are characteristics of daemon/service style software). The MySQL documentation is clear and specific on how to do that - but if you don't understand it, you'll need to find someone in the IT department who does.
精彩评论