Crash when editing my.cnf - MySQL

0

Whenever I try to do the adjustment of the variables in Ubuntu by editing my.cnf located in

etc / mysql / my.cnf

and restart the system, crashes related to connection failure

Can not connect to local MySQL server through socket '/var/mysql/mysql.sock'

I check the folder and see that the mysql.sock file has been deleted. So, every time I need to uninstall and reinstall mysql for everything to work again.

The bank runs on localhost on Ubuntu with version 5.6 .

Does anyone know what's going on? Thanks

    
asked by anonymous 18.01.2016 / 19:31

1 answer

0

At the end of the file the

[mysqld]

key_buffer_size = 64M

max_connections = 200

[client]

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

I just gave up making changes to my.cnf and used a new .cnf file inside the /etc/mysql/mysql.conf.d containing the above excerpt. apparently everything went back to read permission for groups and others.

Thanks for the help. Everything returned to normal, but I only remain with the question of why my.cnf crashes when it is edited. Hugs.

    
19.01.2016 / 05:33