CoreProtect nastavení mysql

[panChemicky]

93.91.250.136:27051

Zdar. Z pluginu HawkEye jsem se rozhodl přejít na CoreProtect, ale jaksi bojuji s nastavení Mysql - přiznám, že to mi nikdy nešlo.

Kód: Vybrat vše

# MySQL is optional and not required.
# If you prefer to use MySQL, enable the following and fill out the fields.
use-mysql: true
table-prefix: co_
mysql-host: localhost
mysql-port: 3306
mysql-database: database
mysql-username: 124740_mysql_db
mysql-password: heslo

Kde dělám chybu?

Při pokusu o reload mi to samozřejmě vypíše do konzole chybovou hlášku

Spoiler: zobrazit

Kód: Vybrat vše

> [14:01:13 INFO]: [CoreProtect] Disabling CoreProtect v2.0.9
> [14:01:13 INFO]: [CoreProtect] Enabling CoreProtect v2.0.9
> [14:01:14 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '124740_mysql_db'@'%' to database 'database'
> [14:01:14 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> [14:01:14 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> [14:01:14 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [14:01:14 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> [14:01:14 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
> [14:01:14 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
> [14:01:14 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> [14:01:14 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
> [14:01:14 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
> [14:01:14 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
> [14:01:14 WARN]: at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
> [14:01:14 WARN]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
> [14:01:14 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
> [14:01:14 WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
> [14:01:14 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
> [14:01:14 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
> [14:01:14 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> [14:01:14 WARN]: at sun.reflect.GeneratedConstructorAccessor131.newInstance(Unknown Source)
> [14:01:14 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [14:01:14 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> [14:01:14 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
> [14:01:14 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
> [14:01:14 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
> [14:01:14 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:571)
> [14:01:14 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:215)
> [14:01:14 WARN]: at net.coreprotect.database.Database.getConnection(Database.java:39)
> [14:01:14 WARN]: at net.coreprotect.model.Config.loadDatabase(Config.java:773)
> [14:01:14 WARN]: at net.coreprotect.model.Config.init(Config.java:901)
> [14:01:14 WARN]: at net.coreprotect.CoreProtect.onEnable(CoreProtect.java:46)
> [14:01:14 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250)
> [14:01:14 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:350)
> [14:01:14 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:384)
> [14:01:14 WARN]: at com.rylinaux.plugman.utilities.PluginUtils.load(PluginUtils.java:168)
> [14:01:14 WARN]: at com.rylinaux.plugman.utilities.PluginUtils.load(PluginUtils.java:127)
> [14:01:14 WARN]: at com.rylinaux.plugman.utilities.PluginUtils.reload(PluginUtils.java:177)
> [14:01:14 WARN]: at com.rylinaux.plugman.commands.ReloadCommand.execute(ReloadCommand.java:59)
> [14:01:14 WARN]: at com.rylinaux.plugman.PlugManCommands.onCommand(PlugManCommands.java:59)
> [14:01:14 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
> [14:01:14 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:199)
> [14:01:14 WARN]: at org.bukkit.craftbukkit.v1_7_R1.CraftServer.dispatchCommand(CraftServer.java:543)
> [14:01:14 WARN]: at org.bukkit.craftbukkit.v1_7_R1.CraftServer.dispatchServerCommand(CraftServer.java:530)
> [14:01:14 WARN]: at net.minecraft.server.v1_7_R1.DedicatedServer.aw(DedicatedServer.java:286)
> [14:01:14 WARN]: at net.minecraft.server.v1_7_R1.DedicatedServer.u(DedicatedServer.java:251)
> [14:01:14 WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.t(MinecraftServer.java:545)
> [14:01:14 WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:457)
> [14:01:14 WARN]: at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617)
> [14:01:14 INFO]: CoreProtect version 2.0.9 is enabled!
> [14:01:14 INFO]: [CoreProtect] Using SQLite for data storage.

[AsraelCZ]

Místo

Kód: Vybrat vše

mysql-database: database

dej

Kód: Vybrat vše

mysql-database: 124740_mysql_db

[panChemicky]

Seš borec Děkuju moc.
Já na tyhle databáze prostě moc nejsem

[Smexhy]

Každý nie je dokonalý že

[panChemicky]

Ok, pohořel jsem znovu. Tentokrát na tom nastavení na webu CoreProtect Web Interference

Kód: Vybrat vše

<?php
/*
 * IMPORTANT: Rename this file to config.php
 */
$config = array(
   // Password for logging into the interface.
   'interfacePass' => 'admin',

   // MySQL settings
   'host' => 'localhost',
   'port' => 3306,
   'user' => '124740_mysql_db',
   'pass' => 'heslo',

   'database' => 'minecraft',
   'tablePrefix' => 'co_',
);

?>

Na Tom webu mi to píše tohle

Kód: Vybrat vše

MySQLi failed to connect:
Error 1045: Access denied for user '124740_mysql_db'@'localhost' (using password: YES)
Make sure the MySQL settings are correct in config.php

[zdenda204]

Kód: Vybrat vše

   'database' => 'minecraft',


Zase stejný jako jméno
A host nastav nejlíp na IP serveru nebo na ten jmenný název (např. loki.fakaheda.eu)

[Smexhy]

Miesto tohoto:

Kód: Vybrat vše

   'database' => 'minecraft',

tam zadaj čo más v user

[panChemicky]

Jéééé. Už to funguje
Dík

(NEzamykat)