I've a question. I guess it's a stupid question, but I really need help.
I have a little problem with mysql. So, with innodb_force_recovery=3 in /etc/my.cnf is working in recovery mode.
If I put innodb_force_recovery=0 I get many errors like mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111), sometimes mysql doesn't start.
There is a way to give a reinstall to mysql without losing databases and users? I've got many databases and users.
Please, help! Thank you!
I have a little problem with mysql. So, with innodb_force_recovery=3 in /etc/my.cnf is working in recovery mode.
If I put innodb_force_recovery=0 I get many errors like mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111), sometimes mysql doesn't start.
There is a way to give a reinstall to mysql without losing databases and users? I've got many databases and users.
Please, help! Thank you!