[SOLVED] Worldserver can't connect to MySQL

[FoxGaming]

Like the title says my TC Worldserver cannot connect to the database. The strange thing is that my Auth Server connects just fine. Here are the log files.


Auth Server:

TrinityCore rev. 3432c872e11f 2014-08-23 17:23:53 +0300 (master branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
Using SSL version: OpenSSL 1.0.1i 6 Aug 2014 (library: OpenSSL 1.0.1i 6 Aug 2014)
Using Boost version: 1.55.0
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.6.20 
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.5.9
MySQL server ver: 5.6.20 
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
Started auth database connection pool.
Updating Realm List...
Added realm "Trinity" at 127.0.0.1:8085.

World Server:

TrinityCore rev. 3432c872e11f 2014-08-23 17:23:53 +0300 (master branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org                    \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1i 6 Aug 2014 (library: OpenSSL 1.0.1i 6 Aug 2014)
Using Boost version: 1.55.0
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world

*Note* The issue is not the username/password, they're identical in both files and work just fine in heidisql.

Random error i've never seen before, I've switched mysql server version and still no connection...

Any ideas?

 

[Hyperion]

Did you import the sql's from update/ into your world DB?

 

[FoxGaming]

Did you import the sql's from update/ into your world DB?

Yes, but I dumped a bunch of tables. Will it not connect if let's say the item_template was empty?


I've dumped tables before, but it used to connect and try to load the tables then spit out errors. Right now my DB has no creatures/items

 

[FoxGaming]

Actually, I got it figured out. Please mark as solved.

It was a table structure i thought i changed and didn't.