this error appear when i try to start my server you can see on photo
ServerFiles utilizat:athera2
Tipologie server(PvM / PvP):PVP
Syserr:nothing
Poză: *Detalii suplimentare:so i cant start my server because of this error.i did this:
use the command : /service mysql-server stop
then order : mysqld_safe --skip-grant-tables &
mysql server should start , open navicat and look at the user who has '%' and try to reset the user's password
later i set on configs the user that have %. then this error appear: failed, retrying in 5 secondsmysql_real_connect: Unknown MySQL server host '%' (0).i returned to my old configs.i try multiple times reseting the athera2_local password but doesnt change something,also i changed the configs to many users on localhost but same error..
PLEASE HELP !!!
THANKS FOR YOUR TIME

/usr/game/cores --> CONFIG sau /usr/home/game/coresc --> CONFIG

PLAYER_SQL: localhost root password account
COMMON_SQL: localhost root password common
LOG_SQL: localhost root password log

now: , https : // imgur. com/ zMb7ET3 https : // imgur. com/ cY31LZo

Ok, let's do this in the most proper way:
-first: open a new sesion into your console(putty) and write this commandto kill all running mysql processes,
-second: start your mysql server then stop it in order to listen the following commands,
-third:after stoping mysql server, write this command:and go to your navicat sesion.You should be able to login. Go to mysql database/user table, and make sure that you have the following access and user set: The password isn't so important right now, but you can input that if you want.
-Go back to your putty and write the following commands:Where it says put_your_password_here, write your password -Now write the following commands: You should be prompted for password, so write your password there, then write Now go to your ftp client(WinSCP/FileZilla) and locate all the CONFIG files, within cores/channels, and also conf.txt from DB(you might not have the same directory names so watch for it), and change user with root, and password with your password, then save all files and start the server.

Good luck.

http://prntscr.com/pypdgk also on my configs i dont have somewhere that i can put the password..its like this:
PLAYER_SQL: localhost ath2_local mt2 player
COMMON_SQL: localhost ath2_local mt2 common
only thing i can do is replace ath2_local for root.
+ thanks for your time look like you spent a lot write all this...

apoelaras123 scrie: ↑18 Noi 2019, 21:04 http://prntscr.com/pypdgk also on my configs i dont have somewhere that i can put the password..its like this:
PLAYER_SQL: localhost ath2_local mt2 player
COMMON_SQL: localhost ath2_local mt2 common
only thing i can do is replace ath2_local for root.
+ thanks for your time look like you spent a lot write all this...

In your files: ath2_local is your current user, and mt2 your current password, what's so difficult?

omg thanks solved!