vi /etc/my.cnf.d/server.cnf ??
[root@VM1 file]# vi /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
default-storage-engine=innodb
#skip-innodb
performance_schema=on
#OpenVZ AIO bug fix
innodb_use_native_aio=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]
when performing restoration
[root@VM1 file]# sh /script/mysql-optimize --select=repair
Mysql Check/Repair/Optimize/Upgrade
- Repairing database
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") when trying to connect
- MySQL Service restart
If you try to login kloxo gives an error message Alert: Login Unsuccessful
Issued when go to the website issue Error 500 - Internal Server Error
A generic error message, given when no more specific message is suitable