MYSQL error

[FALLEN1 1]

Hello guys, i have this problem when i start the server,. i tried to reset pw on mysql, to change user and pw and nothing...

And i tried to give all acces on this user

PUBLIC_IP: 188.212.100.58 interface em0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: mysql db: common
cannot start server while no common sql connected
HOSTNAME: channel1
 

 

Edit

I find this in sysser on database

 

SYSERR: Mar 12 09:02:56 :: pid_init: 
Start of pid: 1174

SYSERR: Mar 12 09:02:57 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:02:57 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:02:57 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:03:03 :: pid_init: 
Start of pid: 1189

SYSERR: Mar 12 09:03:03 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:03:03 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:03:03 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:03:08 :: pid_init: 
Start of pid: 1198

SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Lost connection to MySQL server during query
query: SELECT MAX(id) FROM item  WHERE id >= 50000001 and id <= 60000000
SYSERR: Mar 12 09:03:13 :: InitializeTables: InitializeItemTable FAILED
SYSERR: Mar 12 09:03:13 :: Initialize: Table Initialize FAILED
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 50000001 AND id <= 60000000
SYSERR: Mar 12 09:03:13 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:03:13 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item  WHERE id >= 30000001 and id <= 40000000
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 30000001 AND id <= 40000000
SYSERR: Mar 12 09:03:13 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Mar 12 09:03:18 :: pid_init: 
Start of pid: 1213

SYSERR: Mar 12 09:04:59 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:04:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:04:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:04 :: pid_init: 
Start of pid: 1463

SYSERR: Mar 12 09:05:04 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:04 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:09 :: pid_init: 
Start of pid: 1471

SYSERR: Mar 12 09:05:10 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:10 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:10 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:11 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:11 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:18 :: pid_init: 
Start of pid: 1477

SYSERR: Mar 12 09:05:18 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:18 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:25 :: pid_init: 
Start of pid: 1483

SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item  WHERE id >= 110000001 and id <= 120000000
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 110000001 AND id <= 120000000
SYSERR: Mar 12 09:05:25 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 90000001 and id <= 100000000
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 90000001 AND id <= 100000000
SYSERR: Mar 12 09:05:25 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:05:30 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:30 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:30 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:30 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:30 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:35 :: pid_init: 
Start of pid: 1504

SYSERR: Mar 12 09:05:35 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:35 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:41 :: pid_init: 
Start of pid: 1509

SYSERR: Mar 12 09:05:41 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:41 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:05:41 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:41 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:41 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:46 :: pid_init: 
Start of pid: 1517

SYSERR: Mar 12 09:05:47 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:47 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:05:55 :: pid_init: 
Start of pid: 1523

SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 130000001 and id <= 140000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 130000001 AND id <= 140000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 170000001 and id <= 180000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 170000001 AND id <= 180000000
SYSERR: Mar 12 09:05:55 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:55 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:06:00 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:00 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:06:00 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:06:00 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:00 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:05 :: pid_init: 
Start of pid: 1541

SYSERR: Mar 12 09:06:05 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:05 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:06:12 :: pid_init: 
Start of pid: 1549

SYSERR: Mar 12 09:06:13 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:13 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:06:23 :: pid_init: 
Start of pid: 1553

SYSERR: Mar 12 09:06:29 :: pid_init: 
Start of pid: 1568

SYSERR: Mar 12 09:06:29 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:29 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:29 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:06:32 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:35 :: pid_init: 
Start of pid: 1575

SYSERR: Mar 12 09:06:35 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:06:36 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:36 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:36 :: pid_deinit: 
End of pid

SYSERR: Mar 12 09:06:41 :: pid_init: 
Start of pid: 1579

SYSERR: Mar 12 09:06:43 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:43 :: pid_deinit: 
End of pid

Thanks

Edited March 12, 2020 by FALLEN1

[joshi 32]

Look this:

 

MySQL root password reset