Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Tompoolk on August 29, 2015, 04:54:58 pm

Title: Slight problem editing class level stats. /solved
Post by: Tompoolk 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.

Title: Re: Slight problem editing class level stats.
Post by: Valkryst on August 29, 2015, 06:14:39 pm

Use HeidiSQL.

Title: Re: Slight problem editing class level stats.
Post by: Tompoolk 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.

Title: Re: Slight problem editing class level stats.
Post by: Valkryst 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?

Title: Re: Slight problem editing class level stats.
Post by: Tompoolk 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.

Title: Re: Slight problem editing class level stats.
Post by: Kaev 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.

Title: Re: Slight problem editing class level stats.
Post by: Tompoolk 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.

Title: Re: Slight problem editing class level stats.
Post by: detonatorss 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