MySQL How to set up an Mysql database/with an sql server.

[ahmedrsrupma]

Hello. Now i'am going to show you how to make an sql database.

first of all download xampp, Welcome! - The Apache Software Foundation i think it's that

link or google for it. after downloaded, install it in C:/program.

put the 2 boxes install apache as service, and install mysql as service.

now, go to the file and put the button Xampp_start and start it.

or it won't work.

after installed, go to http://localhost/xampp then click on security

put in a new password in the 2 boxes, if the security doesn't come up use http://localhost/security/xamppsecurity.php

when you done this you have to stop the xampp and start it again.

now go to localhost/phpmyadmin and login with root and use ur password u chosen at the xampp security.

when u have logged in make an database, now import your mysql file found in ur server, maybe can be forgottenserver.schema.mysql or something like that.

then goto your config.lua and find up sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "your mysql password here"
sqlDatabase = "the name of your database here"

Now your server should work. with an database, if you want help with making gamemaster make me an pm, i will make an thread for that later.