Control Web Panel
WebPanel => CentOS 7 Problems => Topic started by: nionet on October 19, 2021, 10:24:31 AM
-
Hi my server was down due to low space in cl-root and i tried this ssh commands to move mysql to home
mkdir /home/var_mysql
mv /var/lib/mysql /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
ln -s /home/var_mysql/mysql /var/lib/mysql
/etc/init.d/mysql start
but it broke my server mysql system and now i'm struggling to fix it please help me
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
-
Please help me fix it i'm having blank screen now , i can share my root detail
thank you .
-
You can set the datadir in /etc/my.cnf instead of strange ln -s /home/var_mysql/mysql /var/lib/mysql
Also, if you using CentOS 7 or CentOS 8 you will have to set ProtectHome=No in /usr/lib/systemd/system/mariadb.service