Relative Content

Mysql

Enable systemd to allow MySQL to be in /home directory

There are many cases systemd doesn’t allow the MySQL to work from a new/custom data directory path. It still restricts the path and stick to the default /var/lib/mysql even if we try to change it. To override this, disable ProtectHome on the following file.

Mysql error followed by Openfire XMPP server halt

I faced an issue as my IM messenger suddenly got disconnected from the openfire xmpp server. I checked the internet connection to my computer and it was still looking fine. So I hop into openfire server and tried to manually start it. It showed as openfire service starting, but it went off suddenly. I checked […]

Proper Method To Change Default Mysql Engine Permanently

Here the mysql engine is set to InnoDB by default and I want to change it to MyISAM for long run. It was the old way setting parameter “skip-innodb” and commenting “innodb_file_per_table=1” in my.cnf file. Additionally we used to execute mysql query “SET storage_engine=MYISAM;”. Now a days, the above changes wont work and perhaps the […]