{"node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "revisions": [{"id": "f23d4c90-2f95-11f1-8555-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\nRestore database\r\n-----------------------\r\n\r\nThe following command with restore a database from a backup .sql file\r\n\r\n.. code-block:: bash\r\n\r\n mysql -u username -p lostquery < lostquery-backup-2012-12-10.sql\r\n\r\n\r\n \r\nDrop user\r\n-------------\r\n\r\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\n\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist\r\n\r\n\r\nCreate a read only user for backing up databases\r\n------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n GRANT SELECT, LOCK TABLES ON *.* TO backup_user@localhost;\r\n\r\n\r\nBackup all databases into separate files\r\n--------------------------------------------------\r\n\r\n.. code-block:: bash\r\n\r\n #!/bin/bash\r\n \r\n USER=\"backup_user\"\r\n PASSWORD=\"\"\r\n TODAY=`date +%Y-%m-%d`\r\n OUTPUTDIR=\"/backup/db/$TODAY\"\r\n MYSQLDUMP=\"/usr/bin/mysqldump\"\r\n MYSQL=\"/usr/bin/mysql\"\r\n \r\n mkdir $OUTPUTDIR\r\n \r\n # get a list of databases\r\n databases=`$MYSQL --user=$USER --password=$PASSWORD \\\r\n  -e \"SHOW DATABASES;\" | tr -d \"| \" | grep -v Database`\r\n \r\n # dump each database in turn\r\n for db in $databases; do\r\n     $MYSQLDUMP --force --opt --user=$USER --password=$PASSWORD \\\r\n     --databases $db > \"$OUTPUTDIR/$db.sql\"\r\n done\r\n\r\nReference: `Backup multiple mysql databases into separate files <http://www.snowfrog.net/2005/11/16/backup-multiple-databases-into-separate-files/>`_", "source_format": "rst", "revision_number": 23, "created": 1356022339000}, {"id": "f23d4748-2f95-11f1-bdca-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\nRestore database\r\n-----------------------\r\n\r\nThe following command with restore a database from a backup .sql file\r\n\r\n.. code-block:: bash\r\n\r\n mysql -u username -p lostquery < lostquery-backup-2012-12-10.sql\r\n\r\n\r\n \r\nDrop user\r\n-------------\r\n\r\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\n\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist\r\n\r\n\r\nCreate a read only user for backing up databases\r\n------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n GRANT SELECT, LOCK TABLES ON *.* TO username@localhost IDENTIFIED BY 'passw0rd';\r\n\r\n\r\n", "source_format": "rst", "revision_number": 22, "created": 1356020617000}, {"id": "f23d3fdd-2f95-11f1-a423-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\nRestore database\r\n-----------------------\r\n\r\nThe following command with restore a database from a backup .sql file\r\n\r\n.. code-block:: bash\r\n\r\n mysql -u username -p lostquery < lostquery-backup-2012-12-10.sql\r\n\r\n\r\n \r\nDrop user\r\n-------------\r\n\r\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\n\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist\r\n\r\n\r\nCreate a read only user for backing up databases\r\n------------------------------------------------------------\r\n\r\n.. code-block::\r\n\r\n GRANT SELECT, LOCK TABLES ON *.* TO username@localhost IDENTIFIED BY 'passw0rd';\r\n\r\n\r\n", "source_format": "rst", "revision_number": 21, "created": 1356020594000}, {"id": "f23d3bc0-2f95-11f1-aff6-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\nRestore database\r\n-----------------------\r\n\r\nThe following command with restore a database from a backup .sql file\r\n\r\n.. code-block:: bash\r\n\r\n mysql -u username -p lostquery < lostquery-backup-2012-12-10.sql\r\n\r\n\r\n \r\nDrop user\r\n-------------\r\n\r\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\n\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist", "source_format": "rst", "revision_number": 20, "created": 1355162517000}, {"id": "f23d37a3-2f95-11f1-9676-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\n\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist", "source_format": "rst", "revision_number": 19, "created": 1336063843000}, {"id": "f23d33a9-2f95-11f1-8d31-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\nd\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n--------------------------------------------------------------------------\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist", "source_format": "rst", "revision_number": 18, "created": 1335864119000}, {"id": "f23d2fa5-2f95-11f1-aae3-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n\r\nd\r\n\r\nShow the MySQL processlist or list of currently running queries\r\n=======================================================================\r\n\r\n.. code-block:: mysql\r\n\r\n mysqladmin -u root -p processlist", "source_format": "rst", "revision_number": 17, "created": 1335864095000}, {"id": "f23d2bbc-2f95-11f1-a5b5-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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\n.. code-block:: sql\r\n\r\n DROP USER username@localhost\r\n\r\n\r\n\r\nDrop database\r\n-------------------------\r\n\r\n\r\n.. code-block:: sql\r\n\r\n DROP DATABASE databasename\r\n", "source_format": "rst", "revision_number": 16, "created": 1333270590000}, {"id": "f23d27cb-2f95-11f1-ad55-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\nOr optionally make Character set utf8 for unicode support\r\n\r\n.. code-block:: mysql\r\n \r\n CREATE DATABASE lostquery DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;\r\n\r\n\r\n\r\n\r\n\r\nCreate a user\r\n---------------------\r\n\r\nThe following command will create a user with a password and grant all privileges to the user on a particular database:\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": 15, "created": 1333237132000}, {"id": "f23d236c-2f95-11f1-8be3-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 with a password and grant all privileges to the user on a particular database:\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": 14, "created": 1303938267000}, {"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}, {"id": "f23d1385-2f95-11f1-9950-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": 12, "created": 1303938035000}, {"id": "f23d0da6-2f95-11f1-a4c0-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\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": 11, "created": 1303937978000}, {"id": "f23d0991-2f95-11f1-b781-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  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    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": 10, "created": 1301174080000}, {"id": "f23d056e-2f95-11f1-b4bc-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  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    GRANT ALL PRIVILEGES ON lostquery.* TO username@localhost IDENTIFIED BY 'p@ssw0rd' WITH GRANT OPTION\r\n\r\n\r\nDrop user\r\n-------------\r\n\r\nDROP USER username@localhost", "source_format": "rst", "revision_number": 9, "created": 1290645961000}, {"id": "f23d018b-2f95-11f1-9367-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": " http://www.anxietycare.net/ valium %-) http://www.qualityremedy.com/ buy 150 tramadol tablets 863607 ", "source_format": "rst", "revision_number": 8, "created": 1290634788000}, {"id": "f23cfbf1-2f95-11f1-951a-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": " http://www.anxietycare.net/ valium %-) http://www.qualityremedy.com/ buy 150 tramadol tablets 863607 ", "source_format": "rst", "revision_number": 7, "created": 1290634782000}, {"id": "f23cf78e-2f95-11f1-8da5-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  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    GRANT ALL PRIVILEGES ON lostquery.* TO username@localhost IDENTIFIED BY 'p@ssw0rd' WITH GRANT OPTION\r\n\r\n\r\nDrop user\r\n-------------\r\n\r\nDROP USER username@localhost", "source_format": "rst", "revision_number": 6, "created": 1289340201000}, {"id": "f23cf1fa-2f95-11f1-83af-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": "e6bOru  <a href=\"http://glkkyqifydug.com/\">glkkyqifydug</a>, [url=http://uqvnwcdkuksq.com/]uqvnwcdkuksq[/url], [link=http://jjuelxedncuw.com/]jjuelxedncuw[/link], http://zoanhzbalqge.com/", "source_format": "rst", "revision_number": 5, "created": 1289332897000}, {"id": "f23ced14-2f95-11f1-944b-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": "e6bOru  <a href=\"http://glkkyqifydug.com/\">glkkyqifydug</a>, [url=http://uqvnwcdkuksq.com/]uqvnwcdkuksq[/url], [link=http://jjuelxedncuw.com/]jjuelxedncuw[/link], http://zoanhzbalqge.com/", "source_format": "rst", "revision_number": 4, "created": 1289332891000}, {"id": "f23ce76e-2f95-11f1-9d1a-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": "45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/", "source_format": "rst", "revision_number": 3, "created": 1289288695000}, {"id": "f23ce238-2f95-11f1-a6ee-e86a64d24d78", "node_id": "f23c51d7-2f95-11f1-a39a-e86a64d24d78", "user_id": null, "author": null, "data": "45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/45Yp5B  <a href=\"http://swxyuwkaqjmz.com/\">swxyuwkaqjmz</a>, [url=http://pakfhnhydxuo.com/]pakfhnhydxuo[/url], [link=http://ednrbotqnkbn.com/]ednrbotqnkbn[/link], http://phvlkkcscupb.com/", "source_format": "rst", "revision_number": 2, "created": 1289288689000}, {"id": "f23cd5a6-2f95-11f1-956c-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  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    GRANT ALL PRIVILEGES ON lostquery.* TO username@localhost IDENTIFIED BY 'p@ssw0rd' WITH GRANT OPTION\r\n\r\n\r\nDrop user\r\n-------------\r\n\r\nDROP USER username@localhost", "source_format": "rst", "revision_number": 1, "created": 1276973869000}], "count": 23}