{"revision": {"id": "f23d1d4b-2f95-11f1-8498-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": "edc3f576-2f95-11f1-900f-e86a64d24d78", "author": "foxhop", "data": "mySQL\r\n========\r\n\r\nmySQL database information.\r\n\r\n.. contents::\r\n\r\nFull-Text Minimum word length\r\n--------------------------------\r\n\r\n\r\nFull-text minimum length default is set to 4.  To adjust this setting, edit /etc/mysql/my.cnf and add the following line under [mysqld]::\r\n\r\n ft_min_word_len = 3\r\n\r\nNext we need to restart mysql::\r\n\r\n $ sudo service mysql restart\r\n  \r\nLast repair the full-text index on the table::\r\n\r\n mysql> REPAIR TABLE table_name QUICK\r\n\r\n\r\nCreate database\r\n------------------\r\nlog into mysql as root:\r\n\r\n\r\n.. code-block:: mysql\r\n \r\n create database lostquery\r\n\r\nMake a user for this database...\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user, create its password, and grant it access to a database:\r\n\r\n\r\n.. code-block:: mysql\r\n\r\n GRANT ALL PRIVILEGES ON lostquery.* TO username@localhost IDENTIFIED BY 'passw0rd' WITH GRANT OPTION\r\n\r\n\r\nDrop user\r\n-------------\r\n\r\nDROP USER username@localhost", "source_format": "rst", "revision_number": 13, "created": 1303938157000}}