Getting error loading character_database

[Khaennn]

When I try to load my characters_database for TrinityCore, I get the error:

cannot create table 'characters.group_members'.


I can't even load the sql file with a command. Anyone know how to solve this? I've searched and I can't find anything on my particular error.

[Envoke]

Are you trying to execute the characters.sql ? Is the trinity server (exe) giving you this error? I don't know what the issue is but sounds like a access restriction. Make sure the account you are using has the permission to create new tables.

[Khaennn]

I made sure my sql account is able to load the characters.sql.

It says not able to create the table group_member

[Envoke]

No not the option to load, but the option to CREATE. If your using navicat (which I recommend) then you should be able to click on Manage Users and it will give you a form like this one http://i165.photobucket.com/albums/u...man_2007/2.jpg

Make sure all the checkboxes are selected

[Khaennn]

Same error :/

[Envoke]

Okay make sure that the database you are executing the SQL to is called "characters" (no quotes).

[Khaennn]

Yes, the database is called characters.

[Envoke]

Okay that is some basic troubleshooting and doesn't seem to work so if you would like anymore help talk to me on msn: [email protected]