Easy way to get Mysql on your own computer/server

Edit : Wanted to add (windows) to the title.. primary for windows vista and 7 users.

Hi people, im new to Minecraft, and bought it instantly when i saw it
However im not new to server hosting, both in game terms and websites.

And ive been reading across this message board alot the last couple of days,
and i see alot of people having problems with xx-sql systems..

And id would like to inform you of a EASY and USER FRIENDLY way to
get mysql platform on your computer without a hassle..

There are several options out there..
just google for them..

I would like to introduce to those who dont know it "xampp" from Apache friends..

You Download it here : http://www.apachefriends.org/en/xampp.html

Just scroll down to your operating system,
download and simply install as you would any application.

For windows users, you will have the Xampp desktop icon to launch when ready
launch the app, and you get the small icon as on the screenshot above..

Now here is a TIP for minecraft servers,,
Many plugins such as Bigbrother etc.. can use the benefits of mysql
If you havent allready, just click the "start" button for Mysql, BUT ALSO Apache.
Apache is a webserver, its not required for Minecraft,
but we will use it to acces the mysql database via the admin feature (phpmyadmin)

If you want you can check the "Svc" which will launch the server, upon windows reboot..
I dont, i like to have personal control, cause i run multiple servers often.

Once Apache and Mysql is running..
Click the Admin button next to Mysql.

You should now see something like this,, and browser pointing to "http://localhost/phpadmin/"

Dont mind the language on the screenshot (its localized)

Where the red arrow is pointing just Enter "minecraft" without quotation marks.
and press enter, or new..
then the page will refresh, if it dosent click the small house on the left (home) and the new
database should appear in the list on the left.

You can close the browser window now, and In the Xampp control panel u can press STOP on the apache server.
and leave Mysql running.. Youre done..

Default information
By default most computers ip when connecting locally (on the same comp) you can use 192.168.1.1 OR just the plain text localhost
If your unsure on how to check your ip..

start DOS promt/cmd (windows 7 + vista) press windows button(start) and type cmd press enter
In the dos promt type ipconfig
scroll back up if multiple pages/lines


You are looking for the first entry called IPv4-address .. . . . . . . (IP SHOWN HERE)
the ip shown there is your LOCAL machine ip.

Xampp Mysql user is by default : root
Xampp Mysql password is by default :

Bigbrother mysql proberties..
This is a copy of my "localhostet" testservers bigbrother properties.
i have ofcourse "hidden" my password and user, never use default when online -
for the sake of this post

Code:

mysqlPass =  hiddenforwebuse  #Password for MySQL db (if applicable)
MySQL = true  #If true, uses MySQL. If false, uses Sqlite
mysqlUser = hiddenforwebuse #Username for MySQL db (if applicable)
stickItem = 280  #The item used for /bb stick
mysqlDB = jdbc:mysql://localhost:3306/minecraft  #DB for MySQL (if applicable)
engine = INNODB  #Engine for the Database (INNODB is recommended)
autoWatch = true  #Automatically start watching players
freedMem = 5279.885459899902  #The amount of memory freed by BB
sendDelay = 4  #Delay to batch send updates to database (4-5 recommended)
defaultSearchRadius = 2  #Default search radius for bbhere and bbfind
restoreFire = false  #Restore fire when rolling back
flatFileLogs = false  #If true, will also log actions to .logs (one for each player)

Hope this helps someone out there..
and remember you can use Xammp for other projects aswell
including websites, mysql/php development etc..

Martin