This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu
Pages: [1]

Author Topic: Slight problem editing class level stats. /solved  (Read 1989 times)

Tompoolk

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 15
    • View Profile
Slight problem editing class level stats. /solved
« on: August 29, 2015, 04:54:58 pm »
OK so I have set up the modding environment as instructed and everything works correctly, except I am having problems opening files with Navicat Premium, which I used to use to open and edit the server files that contained the class level statistics, is there another tool I should be using to open MYI and MYD and frm files as I cant connect with Navicat? The file I am trying to open is the Playercreateinfo. I am using trinity core.
« Last Edit: September 12, 2015, 03:27:23 am by Admin »
Logged

Valkryst

  • Moderators
  • Model Change Addict
  • *****
  • Posts: 224
    • View Profile
    • http://valkryst.com/blog/
Re: Slight problem editing class level stats.
« Reply #1 on: August 29, 2015, 06:14:39 pm »
Use HeidiSQL.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged
MY BLOG IS NOW HERE.

Tompoolk

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 15
    • View Profile
Re: Slight problem editing class level stats.
« Reply #2 on: August 30, 2015, 12:45:14 am »
The problem I'm having is that on both SQL editors I am getting the error 'root"@localhost using password NO) when trying to open the mySql database on the trinity server, I am using the server the tutorial suggested and I can connect to the sql server on workbench, but not on the sql editors.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

Valkryst

  • Moderators
  • Model Change Addict
  • *****
  • Posts: 224
    • View Profile
    • http://valkryst.com/blog/
Re: Slight problem editing class level stats.
« Reply #3 on: August 30, 2015, 01:17:19 am »
Quote from: "Tompoolk"
The problem I'm having is that on both SQL editors I am getting the error 'root"@localhost using password NO) when trying to open the mySql database on the trinity server, I am using the server the tutorial suggested and I can connect to the sql server on workbench, but not on the sql editors.

O.o Are you running the server & database on your personal computer?
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged
MY BLOG IS NOW HERE.

Tompoolk

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 15
    • View Profile
Re: Slight problem editing class level stats.
« Reply #4 on: August 30, 2015, 01:46:12 am »
Yes this is my personal computer, and yes it is quite strange, could it be a weird authentication error? I have recently done a fresh install of my computer, and like I said everything but this is working fine.





Also if this helps with coming up with a solution I remember having a similar problem on an older version of Mysql when I had no password, and it only accepted my connection when I imputed a password (Though this took ages and I am not entirely sure how I did it) But as I said I completely wiped my computer and installed the essentials from the ground up again, so no old version of mysql is present just the one the tutorial provides.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

Kaev

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 308
    • View Profile
Re: Slight problem editing class level stats.
« Reply #5 on: August 30, 2015, 08:23:33 am »
'root"@localhost using password NO

This means that you're trying to connect to your MySQL server with a password, but actually it doesn't have a password. Set a password and connect with it or connect without a password.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

Tompoolk

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 15
    • View Profile
Re: Slight problem editing class level stats.
« Reply #6 on: August 30, 2015, 03:56:56 pm »
Quote from: "Kaev"
'root"@localhost using password NO

This means that you're trying to connect to your MySQL server with a password, but actually it doesn't have a password. Set a password and connect with it or connect without a password.


How exactly would I go about resetting or adding a password to the mysql given to me by the tutorial? I have changed a password for my old mysql before the wipe but now I cant seem to change this password. Also will I have to change anything in the trinity server for it to work with a password? Thanks for the help.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

detonatorss

  • Registred Member
  • Model Change Addict
  • *****
  • Posts: 233
    • View Profile
Re: Slight problem editing class level stats.
« Reply #7 on: September 04, 2015, 03:23:03 am »
Quote from: "Tompoolk"
Quote from: "Kaev"
'root"@localhost using password NO

This means that you're trying to connect to your MySQL server with a password, but actually it doesn't have a password. Set a password and connect with it or connect without a password.


How exactly would I go about resetting or adding a password to the mysql given to me by the tutorial? I have changed a password for my old mysql before the wipe but now I cant seem to change this password. Also will I have to change anything in the trinity server for it to work with a password? Thanks for the help.

You have to change all the database acces examples authserver.con and worldserver.conf
The port, the user and password
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged
Desktop


Laptop
Pages: [1]