Mysql problem when iniciating server

[Thorn]

Hello guys, well long story short...
im using a launcher from a 2.52 otx server, my original into a server 11.00 global
and i can't get it to work, im trying to get this new server up in localhost with the exe i had (because there's only the datapack available)
here are some images:

i hope you guys can help mee

 

[MyAAC]

Are you sure root user has no password set?

If I would be you, then I would create a new user in the database named global, with all privileges to database global. It's more secure.

 

[Thorn]

Are you sure root user has no password set?

If I would be you, then I would create a new user in the database named global, with all privileges to database global. It's more secure.

Ok here is what i did, aparently i had a password, but i have no idea wich one is it, so i went to users and set the user root@localhost with no password, then i reset mysql and got this D;

Fixed this last issue, i just reinstalled xampp, now this is how it looks

 

[Znote]

In phpmyadmin, create a new user for your OT server along with a new database.

Watch a few minutes from my tutorial:

from timestamp 5:11 to 7:09 (2 minutes).
In the host field, don't use local or localhost, use the IP 127.0.0.1. This is also what you type in config.lua under mysql host details, as well as config.php (if using Znote AAC).

Stop screwing around with root. Even if it is just local hosting and testing.

 

[Thorn]

In phpmyadmin, create a new user for your OT server along with a new database.

Watch a few minutes from my tutorial:

from timestamp 5:11 to 7:09 (2 minutes).
In the host field, don't use local or localhost, use the IP 127.0.0.1. This is also what you type in config.lua under mysql host details, as well as config.php (if using Znote AAC).

Stop screwing around with root. Even if it is just local hosting and testing.

thanks for the anwer man, i created a new user but i still cant run this thing, here are some photos

i created user juego password juego with all privileges and still can't iniciate the game D;

ooh and i tried using 127.0.0.1 but is the same :/

 

[Znote]

thanks for the anwer man, i created a new user but i still cant run this thing, here are some photos

i created user juego password juego with all privileges and still can't iniciate the game D;

ooh and i tried using 127.0.0.1 but is the same :/

When creating the user and database "juego" in phpmyadmin, you must set ip to 127.0.0.1 not localhost.
And then you can connect with juego/juego 127.0.0.1. You cant do 127.0.0.1 in config.lua and have localhost in phpmyadmin.

 

[Thorn]

When creating the user and database "juego" in phpmyadmin, you must set ip to 127.0.0.1 not localhost.
And then you can connect with juego/juego 127.0.0.1. You cant do 127.0.0.1 in config.lua and have localhost in phpmyadmin.

Ok i did what you said, check this

there is juego 127.0.0.1, soo in config.lua

and in console

 

[Webo]

try: mysqlHost = "localhost"
and ip = "127.0.0.1"

 

[Thorn]

try: mysqlHost = "localhost"
and ip = "127.0.0.1"

same

 

[Webo]

re install xampp XAMPP Installers and Downloads for Apache Friends

 

[Thorn]

re install xampp XAMPP Installers and Downloads for Apache Friends

i have reinstalled xampp multipl times with no sucess :/

 

[Webo]

Try install this version 1.6.6

You may have locked ports