When I run the command wp db optimize it returns: mysqlcheck: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } How can I set the SQL server sock to /run/mysqld/mysqld.sock ? Tried to change #socket = /tmp/mysql.sock socket = /run/mysqld/mysqld.sock if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } in MySQL configuration but it won't start MySQL server.

Panel default MySQL different to WP-CLI sock

aaP_haggis-jogger_0u

When I run the command wp db optimize it returns:

mysqlcheck: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect

How can I set the SQL server sock to /run/mysqld/mysqld.sock?

Tried to change

#socket		= /tmp/mysql.sock
socket = /run/mysqld/mysqld.sock

in MySQL configuration but it won't start MySQL server.

aaPanel_Kern

Hello, are you using openlitespeed? If so, please check the configuration of php. Are the following two configurations consistent?
pdo_mysql.default_socket=/tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

The mysql sock file of the panel is in /tmp/ by default. It is not recommended that you modify it.

aaP_haggis-jogger_0u

aaPanel_Kern Hello, thank you for your response.

Yes, the server is running OLS.
The default PHP configuration:

pdo_mysql.default_socket=/tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

does that mean I also need to modify PHP configuration, along with the MySQL configuration?

aaP_haggis-jogger_0u

aaPanel_Kern Hello, currently I'm leaving php.ini default as when installed.

aaP_haggis-jogger_0u Yes, the server is running OLS.
The default PHP configuration:

pdo_mysql.default_socket=/tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock
if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) {
window.hljsLoader.highlightBlocks(document.currentScript.parentNode);
}

aaPanel_Kern

Are you using the php.ini file pointed to?
This requires checking your mysql configuration sock

aaP_haggis-jogger_0u

aaPanel_Kern Hello, thanks for your response.

Here is the content of wp --info

OS:     Linux 5.15.0-25-generic #25-Ubuntu SMP Wed Mar 30 15:54:22 UTC 2022 x86_64
Shell:  /bin/bash
PHP binary:     /www/server/php/81/bin/php
PHP version:    8.1.30
php.ini used:   /www/server/php/81/etc/php-cli.ini
MySQL binary:   /usr/bin/mysql
MySQL version:  mysql  Ver 15.1 Distrib 10.6.22-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper
SQL modes:

It seems the PHP CLI bin and version is different, not OLS's.

# /usr/local/lsws/lsphp81/bin/php -v
PHP 8.1.32 (cli) (built: Mar 14 2025 00:30:15) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.32, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.32, Copyright (c), by Zend Technologies

# /www/server/php/81/bin/php -v
PHP 8.1.30 (cli) (built: Sep 27 2024 09:15:32) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.30, Copyright (c) Zend Technologies

aaPanel_Kern

Is it possible to specify php and php.ini?

aaP_haggis-jogger_0u