Jump to content
Sign in to follow this  
Jyard

ACE Compiled/sql all set but when it tries to connect it crashes

Recommended Posts

Exception: The user specified as a definer ('root'@'localhost') does not exist.

Checked permissions in phpmyadmin, root has all privs for all databases. 

Made a new user, granted all privs, changed config file, still says root and fails. 

I'm stumped. Any help would be appreciated. Thanks. 

Share this post


Link to post
Share on other sites

It looks like it is connecting ok to auth and character, but doesn't connect to world. maybe there is an issue with the world permissions. I use mySQL  workbench and HeidiSQL , haven't used phpmyadmin in ages.

Share this post


Link to post
Share on other sites

alright i'm not sure why, but using the mysql command line and granting privileges that way worked.. something with phpmyadmin i guess.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×