We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Can't connect to local MySQL server through socket '/var/run
-
- Posts: 2
- Joined: Mon Aug 25, 2014 9:16 pm
Can't connect to local MySQL server through socket '/var/run
Hello today after installing vestacp my website its work fine but after some hour give this error ,
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
and when restart mysql work but give same error after e few hour
any solution please
my my.cnf file
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table
!includedir /etc/mysql/conf.d/
and i cant find /var/run/mysqld/mysqld.sock
i need fix it please i use
Ubuntu 14.04 x64
when i type sudo find / -name mysqld.sock
/run/mysqld/mysqld.sock
and if there is no solution anyone tell me how ot make cron job command on ubuntu restart mysql evry 1 hour for exemple ?
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
and when restart mysql work but give same error after e few hour
any solution please
my my.cnf file
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table
!includedir /etc/mysql/conf.d/
and i cant find /var/run/mysqld/mysqld.sock
i need fix it please i use
Ubuntu 14.04 x64
when i type sudo find / -name mysqld.sock
/run/mysqld/mysqld.sock
and if there is no solution anyone tell me how ot make cron job command on ubuntu restart mysql evry 1 hour for exemple ?
Re: Can't connect to local MySQL server through socket '/var
Hi,
Try to follow these commands
Try to follow these commands
Code: Select all
service mysqld stop
service mysqld start
-
- Posts: 2
- Joined: Mon Aug 25, 2014 9:16 pm
Re: Can't connect to local MySQL server through socket '/var
hello thanks for reply i kno wthat but after some hour mysql back stopped againimperio wrote:Hi,
Try to follow these commandsCode: Select all
service mysqld stop service mysqld start
i try install monit but not work i need solution to check mysql if down restart it automaticly
Re: Can't connect to local MySQL server through socket '/var
Show me please result of this commands
Try to optimize mysql settings in
/etc/mysql/my.cnf
Code: Select all
top
free -m
/etc/mysql/my.cnf
Re: Can't connect to local MySQL server through socket '/var
I had the same problem .
I have installed MariaDB instead
I have installed MariaDB instead