Jump to content
TrinityCore
Sign in to follow this  
jhatfield

MySQL query after fresh compiling

Recommended Posts

Hey guys,

i wanted to setup a complete fresh core and worked with the wiki Tutorial (not my first TC-Compiling!).

Compiling did work like charm but setting up the DB is probably.

As i said i used fresh data and compiled core. But anytime i start worldserver.exe for creating the new databases i get an permission error.

I already tested to create manually DB's with the same Login Data as in worldserver.conf and it did work, but anytime im doing it with the worldserver.exe i get the following error.

I already readed many threads where the same error appeared but nothing did help. Could it be that the core itself has a problem, cause 2 or 3 weeks ago there was no problem.

Any ideas out there? (It's my first time im posting here sorry if i put it in the wrong place)

 

Server.log

Edited by jhatfield

Share this post


Link to post
Share on other sites

Looks like your mysql user is missing privileges...

from the mysql prompt try:

grant all on dbname.* to 'user'@'%' identified by 'password';

change dbname to the name of the database in question, user to the mysql user and password to that user's password.

 

Share this post


Link to post
Share on other sites
1 hour ago, gkdr said:

hello,I think you can reload the bases.
Starts well by the Create Base and then to finish the updates

What do you mean exactly? Beginning with a new core compiling again or what do you mean with "you can reload bases". (MySQL TDB_full.... i just downloaded this morning)

 

54 minutes ago, gixxer_j said:

Looks like your mysql user is missing privileges...

from the mysql prompt try:

grant all on dbname.* to 'user'@'%' identified by 'password';

change dbname to the name of the database in question, user to the mysql user and password to that user's password.

Will try later and inform you if it worked

Edit:
So tried to fix privileges but didn't help.

Also startet at point 0 recompiled, sql reinstallation ... same problem.

Edited by jhatfield
actually informations

Share this post


Link to post
Share on other sites

Any luck? I've got 3.3.5 and 6x running ok with 5.6.28 (linux)

EDIT:

I set up mine like

create user 'trinity'@'%' identified by 'trinity';

create database auth;

create database characters;

create database world;

then 

grant all on auth.* to 'trinity'@'%' identified by 'trinity';

grant all on characters.* to 'trinity'@'%' identified by 'trinity';

grant all on world.* to 'trinity'@'%' identified by 'trinity';

ran the sql from sql/base

ran the sql from the db download

 

Edited by gixxer_j

Share this post


Link to post
Share on other sites

Sorry for my late response.

No it's still not working. Did it like you wrote by manually import the sqls but now i get:

"Didn't find executeable mysql binary at 'D:/BUILD_TrinityCore/bin/Release' or in path, correct the path in the *.conf ("Updates.MySqlCLIPath")."

Only by setting Updates.EnableDatabases = 0 (from 1) it seems to work but is this correct?

Share this post


Link to post
Share on other sites

Thanks a lot! Now it's working again.... don't know why there is not included automatically because in earlier Compilings i did'nt edit these lines. But... who cares. Now it works. THanks a lot again :)

Edited by jhatfield

Share this post


Link to post
Share on other sites

Glad to hear!  

Those lines are fairly new AFAICT - i think you only need to edit them if the mysql bin folder is NOT in your path, otherwise it won't find them.

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...