Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Magnuss last won the day on March 5

Magnuss had the most liked content!

Community Reputation

27 Excellent

About Magnuss

  • Rank
    Advanced Member

Profile Information

  • Gender
  • Location
    : Switzerland

Recent Profile Visitors

2821 profile views
  1. Well, never thought people really following the wiki exactly xD. For security reason you may will change later the default password for user trinity or never ever give other host rights than localhost. If you would give host right like % it's likely you will get hacked early or later. Atm, I don't know what the problem could be. You have a user trinity, that's good. The user trinity has permission to the 3 databases, that's also good. And as I understand you right you installed the mysql server and the trinity server on the same machine, so both are localhost. Last thing you may can try is to connect from Ubuntu terminal as user trinity: mysql -u trinity -p Enter password trinity and check if you can access.
  2. Now you have maybe more than you need ;-) If your databases are named auth, characters and world you can revoke rights to trinity_auth and so on. These was only example names to group trinity databases together. REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_auth.* FROM 'trinity'@'localhost'; REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_characters.* FROM 'trinity'@'localhost'; REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_world.* FROM 'trinity'@'localhost'; It seems you have a problem with your password or similar in your config file. Check this in your config file: LoginDatabaseInfo = ";3306;trinity;trinity;auth" WorldDatabaseInfo = ";3306;trinity;trinity;world" CharacterDatabaseInfo = ";3306;trinity;trinity;characters" You have to replace the password with your own password for user trinity.
  3. What's now the output of SELECT Host, User from mysql.user and SELECT Host, Db, User FROM mysql.db
  4. The mySQL server is an independent piece of software. It even could run on a complete different hardware. And it has it's own user management separated from your OS Ubuntu. The idea is to add different new users to the mysql server with fine graduated rights. A mysql user can have access to everything, or just only to specific databases, or only to a table. If you have a webserver, you add a user just only for the webser. If you have a mail server, you add a mailserver user. If you have a trinity server, you add a trinity user. For security reasons root f.ex. never should have set host=%. Better add a new user like adminfity and give admin rights and set host to %. Additionally add a user trinity and give only rights to auth, character and world database. Example for such a 'superuser': CREATE USER 'adminfity'@'%' IDENTIFIED BY 'somepassword'; GRANT ALL ON *.* TO 'adminfity'@'%' WITH GRANT OPTION; Example for trinity user: CREATE USER 'trinity'@'localhost' IDENTIFIED BY 'anotherpassword'; GRANT ALL ON trinity_auth.* TO 'trinity'@'localhost'; GRANT ALL ON trinity_characters.* TO 'trinity'@'localhost'; GRANT ALL ON trinity_world.* TO 'trinity'@'localhost'; As you see I give the trinity user only access on localhost. You would remote access with your adminfity user. Be aware: Examples are out of my brain. And my brain is not allways correct ^^ Edit: Reading the Trinity wiki very exactly helps better: Creating the Trinity databases in MySQL For 3.3.x: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql For master: https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql
  5. As you see, there is no user trinity ;-) Edit: Here's how to add users: https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
  6. SELECT Host, User from mysql.user - It seems you don't have added a user trinity (following the posting in the other forum). Therefore you can't access to mysql with this username, even you have a local account on Ubuntu with the same name. And of course you can give every rights to an existing mysql user, but you shouldn't. You shout give only rights really needed. - There are good reasons to NOT allow external access for mysql user root ;-) - And as you was told it seem a problem with password.
  7. There is absolutely nothing wrong with mySQL. Have you switched off Ubuntu firewall? Often the user root is not planned to have remote access and has rights only on localhost. You can try to add another user and give them proper rights. Both (mysql server and user) must have the right to access from external (means setting the host ip to or to your local network) If you have a GUI on your Ubuntu you also can install MySQL Workbench server which is similar to HeidiSql to manage the SQL server.
  8. Just some ideas: Spawn/despawn Change phase mask Change the the type_flags and make him a ghost.
  9. Be aware this may can be confusing for other players if a creature isn't available. And looking to the smartscript wiki page https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130108/smart+scripts the event On Target Quest Accepted isn't implemented yet.
  10. Today I wanted to edit a wiki page with some small changes. But after saving the page it was fucked up. All internal links was replaced and a lot other stupid changes was made: https://trinitycore.atlassian.net/wiki/pages/diffpagesbyversion.action?pageId=2130261&selectedPageVersions=118&selectedPageVersions=117 I had to revert it to version 117. However I checked it with other pages -> same issue. I even don't need to do any single change. I can just click on page edit, than immediately on page preview and have tons of changes I never made. I hate Atlassian products!
  11. Question 1: The field RequestItemsText in the table quest_template is old and doesn't exist anymore. Replaced by: Table quest_request_items, Field CompletionText
  12. Don't know what you mean exactly. Sounds for me as if you want a custom frame inside the wow client. You can do that with programming a WoW addon with Lua. Trinity core supports addon communication with the server with a small lib: https://github.com/TrinityCore/LibTrinityCore-1.0 https://www.amazon.com/World-Warcraft-Programming-Reference-Creating/dp/0470481285 (Free but illegal PDF of the book in internet available) http://wowprogramming.com/ However for that you need good experience in programming.
  13. May there are commands for that, but I do it in the table auth->account_access. Insert a record with your account_id and a level between 1-3. (3 is admin)
  14. Table: quest_template, Field: RewardXPDifficulty You don't give XP points instead you give the quest a difficulty (mostly between 1-8) and according to this difficulty the player gets some XP points rewarded. https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130261/quest+template#quest_template-RewardXPDifficulty
  • Create New...