Create character

[Arezzo]

Hello.

When i want to create character on my server i get an error.
1INSERT ERROR: The user specified as a definer ('root'@'localhost') does not exist.

Previously i changed name of the database user.
Where is the problem?

 

[walkingdragon]

Are you asking where your problem lies or what is causing it?

 

[Arezzo]

Yes...

 

[walkingdragon]

Yes...

Yes what?

 

[Runes]

You can solve this by using:

grant all on *.* to 'root'@'%' identified by 'password' with grant option;

 

[walkingdragon]

You can solve this by using:

grant all on *.* to 'root'@'%' identified by 'password' with grant option;

Explain alittle clearer please, even I didn't understand where this is supposed to go...

 

[Runes]

Explain alittle clearer please, even I didn't understand where this is supposed to go...

You execute this query in the mysql database:

grant all on *.* to 'root'@'%' identified by 'password' with grant option;

 

[Summ]

You could try to change the database settings of your AAC so it uses the new user which you created.
Though I did not understand whether this happens ingame or on AAC, maybe you can add a few details.

 

[Runes]

You could try to change the database settings of your AAC so it uses the new user which you created.
Though I did not understand whether this happens ingame or on AAC, maybe you can add a few details.

This error occurs when you use MySql database and it is simply fixed by using the command I stated above.

 

[Loney]

Reinstall XAMPP, or better use UniServer.

 

[Ninja]

Better drop Windows, go for Debian with nginx or lighttpd. That's what I would recommend.

 

[Znote]

Better drop Windows, go for Debian with nginx or lighttpd. That's what I would recommend.

Jumping into Linux can be a steep learning curve.

Reinstall XAMPP, or better use UniServer.

This.

If you have no intentions of learning another operating system as of yet, I recommend you to get a proper hosting environment on your windows machine.
Here is a video tutorial I made containing everything you need to know to get started:
http://otland.net/f479/video-tutorial-nothing-fully-working-ot-server-website-shop-system-166818/

 

[Summ]

Why reinstall XAMPP? I understood that the problem is that he deleted "root" user and created a new one, for safety reasons maybe.
So the issue would be to change the config.lua and the AAC to use the new user.