Wrong mysql socket

UWRP

New Member
Joined
Aug 31, 2020
Messages
16
Reaction score
3
Credits
133
Good day,

Today we started converting our gameserver from sqlite3 to MySQL. However, I get this error:
Code:
[09/01/20 23:34:16] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

I tried to find out which socket is running, if any..
I found this one to be running after the 'sudo find / -type s' command.

/opt/lampp/var/mysql/mysql.sock <- socket that is currently running is different than the one from the error log

Since we use xampp, I guess our socket is set to this one instead of ubuntu 20.04's default one?

How could I solve this? How do I make it go for the xampp socket instead?
Thanks in advance!
 


Good day,

Today we started converting our gameserver from sqlite3 to MySQL. However, I get this error:
Code:
[09/01/20 23:34:16] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

I tried to find out which socket is running, if any..
I found this one to be running after the 'sudo find / -type s' command.

/opt/lampp/var/mysql/mysql.sock <- socket that is currently running is different than the one from the error log

Since we use xampp, I guess our socket is set to this one instead of ubuntu 20.04's default one?

How could I solve this? How do I make it go for the xampp socket instead?
Thanks in advance!

change that property in my.ini
 

Staff online


Top