Server Database

I have a question, maybe it's silly, but how do I create my Server Database on MySQL, because some plugins don't work properly and I think that's the problem !

Quote from Bogus

Maybe, he mean how he can his server to a mysql database ?

@'red51 Yes, how can I have my server on MySQl ?

Quote from red51

You need a MySQL server for that. If you have a MySQL server, create a new database there (the name doesn't matter, for example "risingworlddb"), then go to your RW server directory, open the server.properties file and change these parameters:

database_mysql_connections	max. numbers of connections the server is allowed to establish to MySQL. It's recommendable to keep it at 10
database_mysql_database	the name of your MySQL database (e.g. "risingworlddb")
database_mysql_password	the password to login to your MySQL server
database_mysql_server_ip	the ip of your MySQL server. If it runs on the same machine, use "127.0.0.1" (without quot. marks)
database_mysql_server_port	the port of your MySQL server (usually it is 3306)
database_mysql_user	the login name to login on your MySQL server
database_type	put a "mysql" here (without quot. marks)

Okey, big thanks !

Quote from red51

You need a MySQL server for that. If you have a MySQL server, create a new database there (the name doesn't matter, for example "risingworlddb"), then go to your RW server directory, open the server.properties file and change these parameters:

database_mysql_connections	max. numbers of connections the server is allowed to establish to MySQL. It's recommendable to keep it at 10
database_mysql_database	the name of your MySQL database (e.g. "risingworlddb")
database_mysql_password	the password to login to your MySQL server
database_mysql_server_ip	the ip of your MySQL server. If it runs on the same machine, use "127.0.0.1" (without quot. marks)
database_mysql_server_port	the port of your MySQL server (usually it is 3306)
database_mysql_user	the login name to login on your MySQL server
database_type	put a "mysql" here (without quot. marks)

I'm trying for a couple of days to make a MySQL server with MySQL Workshop, but it fails every time. I even tried with HeidiSQL and XAMPP, but nothing happens.

Fatal error occurred!
java.sql.SQLException: Could not connect: Unknown database 'risingworlddb'
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.Driver.connect(Driver.java:115)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at x.a$a.d(SourceFile:104)
at x.a$a.<init>(SourceFile:100)
at server.e.a(SourceFile:993)
at server.Main.d(SourceFile:419)
at server.Main.initApplication(SourceFile:248)
at commons.JIWApplication.initialize(SourceFile:231)
at com.jme3.system.NullContext.initInThread(NullContext.java:87)
at com.jme3.system.NullContext.run(NullContext.java:130)
at java.lang.Thread.run(Unknown Source)
Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Unknown database 'risingworlddb'
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:558)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:500)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:709)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:280)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
... 11 more
org.mariadb.jdbc.internal.common.QueryException: Could not connect: Unknown database 'risingworlddb'
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:558)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:500)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:709)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:280)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at x.a$a.d(SourceFile:104)
at x.a$a.<init>(SourceFile:100)
at server.e.a(SourceFile:993)
at server.Main.d(SourceFile:419)
at server.Main.initApplication(SourceFile:248)
at commons.JIWApplication.initialize(SourceFile:231)
at com.jme3.system.NullContext.initInThread(NullContext.java:87)
at com.jme3.system.NullContext.run(NullContext.java:130)
at java.lang.Thread.run(Unknown Source)

Quote from red51

The database "risingworlddb" does not exist. First you have to create this database before starting the server.

I have it created of course in MySQL Workbench.

I think it doesn't connect to database, because I deleted it and it still showed that it can't connect. Do I need to have XAMPP ? @red51

Can someone make a tutorial how to create database and connect it ?