Tag: engine

Sphinx As MySQL Storage Engine (SphinxSE)

SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So […]

How to change the mysql port

To change the port, select the “my.cnf file. Change it to whatever you like and remove the # from the front. Then restart the engine and you should be set for that. Open /etc/my.cnf file: # vi /etc/my.cnf Set new port 5123: port=5123 Here is is my sample /etc/my.cnf file: […]