Help a server owning noob! (MySQL & Logblock)

So here's the deal, I run my own Factions based server, and it's going pretty fine, but to deter foul play I want to install Logblock to catch out griefers.

My server is dedicated and I use Filezilla to login and edit my server files, however people tell me I need MYSQL or something to run with Logblock, does anyone have a way that I can add this to my dedicated server and run it alongside or something? The whole situation pretty much confuses me, but from what I understand it's a database where the logs are stored, anyhow, I'll need a basic and step by step guide on how to get MYSQL running with the Logblock plugin and my server.

If this is the complete wrong place to ask for such help please direct me to somewhere to ask, thanks for reading, I'm in a bit of a tough spot here and I'm learning how to manage my server as I go.

According to my log from the 24th August I'm running the following Craftbukkit build:

git-Bukkit-0.0.0-981-g13441f8-b1062jnks (MC: 1.7.3)

 

What software is your servers OS?

 

I believe it's a variation of Linux, I'm not sure how to find out exactly, I use nitrous-networks if that's any help.

If there's a server file with the answer to this question in I'll find it now I'd just need to know which one

 

personally I would use HawkEye instead, but thats just me. Anyway to set up your sql database you need a few things
1) assuming you have access to mysql and have an account with a password run this

Code:

CREATE DATABASE logblock;

2)make sure all the information in the plugins config is correct
3)run and the plugin should take care of the rest

 

What I'm unsure on is, is the database stored on MY computer? Because I don't have it on all the time, yet still want logs to be held all the time.

I ideally want the database to be stored on my dedicated server.

Ok so now by reading through the HawkEye installation guide they suggest that I ask my server hosts to set up the MySQL database? Can I not do this myself in any way? As I'm not 100% sure that they'll do it.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Use google "How to install MySQL on Linux"

Its simple, take a moment to look at all the helpfull people that have already posted how to do this.

 

Will do, thanks for the help!

 

if you really have a dedicated server you can setup the MySQL database on this server (no no, not on your home computer ^^). You need root access and for sure you should know which Linux distro it is

 

What was the point of your comment?

 

huh? more -needed- information? It doesn't look like he knows something more about his Server than how to upload the files.
I guess root access is needed to install MySQL and the distros have different ways how to install...

 

My post was pointing out that your comment had nothing helpful in it what so ever, you are just pointing out what he still has to learn and how much he is not aware of.

Don't be that person, everyone still has to learn. I learn new things every day and posts like yours have no place in a HELP forum.