Cant connect mysql server

[Cunoo 210]

Hello everyone i cant login in server anyone help me with this ? i can login in char select but after kick me i dont know why.

 

 

Sysser client : 

0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 HeadNub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 Ponytail1Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 L Finger0Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 L Finger1Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 L Finger2Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 R Finger0Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 R Finger1Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 R Finger2Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 L Toe0Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 R Toe0Nub' in the ToSkeleton
0805 12:23:06529 :: GRANNY: NewMeshBinding: Unable to find bone: 'Bip01 TailNub' in the ToSkeleton
 

 

Server DB sysser: 

SYSERR: Aug  3 19:21:20 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Aug  3 19:21:21 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Aug  3 19:21:25 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Aug  3 19:21:26 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Aug  3 19:21:27 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Aug  3 19:21:28 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug  3 19:21:28 :: pid_deinit: 
End of pid

SYSERR: Aug  3 19:21:35 :: pid_init: 
Start of pid: 31735

SYSERR: Aug  3 19:29:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Aug  3 19:29:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug  3 19:29:56 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug  3 19:29:56 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug  3 19:29:56 :: pid_deinit: 
End of pid

SYSERR: Aug  5 14:16:07 :: pid_init: 
Start of pid: 6534

SYSERR: Aug  5 14:19:38 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug  5 14:19:38 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug  5 14:19:38 :: pid_deinit: 
End of pid

SYSERR: Aug  5 14:26:25 :: pid_init: 
Start of pid: 8102

 

 

I think there its problem ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)

but i dont know how to fix it can anyone help me please ?

[iltizio 213]

Be sure your mysql server is running and can accept connection from 127.0.0.1. Be sure your config files have correct port (default 3306)

So, to do that run this:
netstat -na | grep 3306

 

To try the connection:

mysql -h 127.0.0.1 

 

You should not use 127.0.0.1 but localhost, in this way you will use unix socket instead loopback interface.

[Cunoo 210]

mysql is running.

 

 

16 minutes ago, iltizio said:

Be sure your mysql server is running and can accept connection from 127.0.0.1. Be sure your config files have correct port (default 3306)

So, to do that run this:
netstat -na | grep 3306

 

To try the connection:

mysql -h 127.0.0.1 

 

You should not use 127.0.0.1 but localhost, in this way you will use unix socket instead loopback interface.

Look how i can fix this ? https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png look acces denied but how i can allow ?

Edited September 11, 2022 by Metin2 Dev
Core X - External 2 Internal

[iltizio 213]

58 minutes ago, Cunoo said:

mysql is running.

 

 

Look how i can fix this ? https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png look acces denied but how i can allow ?

mysql -h 127.0.0.1 -u root -p

And enter the [email protected] password

 

https://www.freebsd.org/cgi/man.cgi?query=mysql

Edited September 11, 2022 by Metin2 Dev
Core X - External 2 Internal

[Denny2399 8]

1. mysql -u root -p
2. create user 'root'@'localhost' identified by 'password you wish';
3. grant all privileges on *.* to 'root'@'localhost' identified by 'same pass' with grant option;
4. flush privileges;
5. exit

You can also create a completely new user where you put instead of 'root@'localhost' - 'user'@'%'. Don't forget to add privileges.
Now you should be able to connect from your MySQL client to the server using IP of the virtual machine, chosen username and password.
If you need further assistance send me a DM.

Regards.