Can someone make a tutorial how to create database and connect it ?
Posts by xSlashLV057
-
-
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
-
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.
-
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) -
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 !
-
Maybe, he mean how he can his server to a mysql database ?
@'red51 Yes, how can I have my server on MySQl ?
-
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 !