Sign in to follow this  
Followers 0
Jyard

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

4 posts in this topic

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.

1 person likes this

Share this post


Link to post
Share on other sites

Cool! glad you got it working.

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  
Followers 0