In order to use Sphinx, we need to add a user to our MariaDB database and configure the Sphinx daemon so that it indexes the content we want it to.
Install the SphinxSE as described in the Installing SphinxSE in MariaDB recipe in this chapter. Install the Sphinx daemon as described in either the Installing the Sphinx daemon on Linux recipe or the Installing the Sphinx daemon on Windows recipe, both in this chapter, depending on which operating system we are using.
mysqlcommand-line client and create a user with
SELECTrights for the tables in the databases we want the Sphinx daemon to index, using the following statements:
CREATE USER 'sphinx'@localhost IDENTIFIED BY 'sphinxsecretpassword'; ...