Jump to content
TrinityCore

Could not connect to MySQL database


just a turtle
 Share

Recommended Posts

I am trying to intall Trinity core for the first time, It was going well untill i reached the part where i had to run authserver.exe and worldserver.exe. When i open any of those two, it instantly crashes and in the ```DBErrors.txt```, this was the only line written in it - ```Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)```. I have tried to update the databases using sqlog and running the scripts from ```\TrinityCore\sql\updates``` folder  for auth, world and characters(not sure if this is the correct way to update, if it is not please point out he correct way to update databases :) ). Could I get some suggestions on how to fix this? I have already tried to go through 

 but I could not find any issues related to this one. I only want to play offline without any players joining in. 

Edited by just a turtle
Link to comment
Share on other sites

Good evening, I have added the following lines to worldserver.conf -

```LoginDatabaseInfo     = "127.0.0.1;3307;trinity;trinity;auth"
WorldDatabaseInfo     = "127.0.0.1;3307;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3307;trinity;trinity;characters"

```

and ```
LoginDatabaseInfo = "127.0.0.1;3307;trinity;trinity;auth"``` for auth.conf. I had to choose port 3307 while installing sql since 3306 was already in use, could this cause any issues? and also I am not sure how to add this part. 

8 hours ago, jojo72 said:

add your ip to the list of allowed in MySQL

 

Link to comment
Share on other sites

Are you able to connect to your database using something like SQLyog or HeidiSQL using port 3307 and the username trinity, password trinity. If you can you should be good. Personally, i would uninstall MYSQL and re-install it to use the correct port.

As for installing the database, you shouldn't be doing it manually. Just put it in the BIN folder and let it do it by itself. 

You need to read over the WIKI again and follow the steps exactly.

 

Link to comment
Share on other sites

Ok, i have basically reinstalled Mysql again since there were some other instances of mysql server running in my windows services using the default 3306 port.  Now i just tried to run authserver and it gives me this error - "Could not connect to MySQL database at 127.0.0.1: Access denied for user 'trinity'@'localhost' (using password: YES)". I guess i will try to resolve this tomorrow since this is a different error. If you guys know how to resolve this feel free to comment or close this thread since this is now a different error. Thanks for helping out! :) 

Link to comment
Share on other sites

  • 1 year later...

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.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...