Advertisement
Guest User

Mythtv problems

a guest
Oct 19th, 2013
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.71 KB | None | 0 0
  1. louis@backend-box:~$ cat /etc/mysql/conf.d/mythtv.cnf
  2. [mysqld]
  3. bind-address=0.0.0.0
  4.  
  5. louis@backend-box:~$ cat /etc/mysql/my.cnf
  6. #
  7. # The MySQL database server configuration file.
  8. #
  9. # You can copy this to one of:
  10. # - "/etc/mysql/my.cnf" to set global options,
  11. # - "~/.my.cnf" to set user-specific options.
  12. #
  13. # One can use all long options that the program supports.
  14. # Run program with --help to get a list of available options and with
  15. # --print-defaults to see which it would actually understand and use.
  16. #
  17. # For explanations see
  18. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  19.  
  20. # This will be passed to all mysql clients
  21. # It has been reported that passwords should be enclosed with ticks/quotes
  22. # escpecially if they contain "#" chars...
  23. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  24. [client]
  25. port = 3306
  26. socket = /var/run/mysqld/mysqld.sock
  27.  
  28. # Here is entries for some specific programs
  29. # The following values assume you have at least 32M ram
  30.  
  31. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  32. [mysqld_safe]
  33. socket = /var/run/mysqld/mysqld.sock
  34. nice = 0
  35.  
  36. [mysqld]
  37. #
  38. # * Basic Settings
  39. #
  40. user = mysql
  41. pid-file = /var/run/mysqld/mysqld.pid
  42. socket = /var/run/mysqld/mysqld.sock
  43. port = 3306
  44. basedir = /usr
  45. datadir = /var/lib/mysql
  46. tmpdir = /tmp
  47. lc-messages-dir = /usr/share/mysql
  48. skip-external-locking
  49. #
  50. # Instead of skip-networking the default is now to listen only on
  51. # localhost which is more compatible and is not less secure.
  52. #bind-address = 127.0.0.1
  53. bind-address = 192.168.1.132
  54. #
  55. # * Fine Tuning
  56. #
  57. key_buffer = 16M
  58. max_allowed_packet = 16M
  59. thread_stack = 192K
  60. thread_cache_size = 8
  61. # This replaces the startup script and checks MyISAM tables if needed
  62. # the first time they are touched
  63. myisam-recover = BACKUP
  64. #max_connections = 100
  65. #table_cache = 64
  66. #thread_concurrency = 10
  67. #
  68. # * Query Cache Configuration
  69. #
  70. query_cache_limit = 1M
  71. query_cache_size = 16M
  72. #
  73. # * Logging and Replication
  74. #
  75. # Both location gets rotated by the cronjob.
  76. # Be aware that this log type is a performance killer.
  77. # As of 5.1 you can enable the log at runtime!
  78. #general_log_file = /var/log/mysql/mysql.log
  79. #general_log = 1
  80. #
  81. # Error log - should be very few entries.
  82. #
  83. log_error = /var/log/mysql/error.log
  84. #
  85. # Here you can see queries with especially long duration
  86. #log_slow_queries = /var/log/mysql/mysql-slow.log
  87. #long_query_time = 2
  88. #log-queries-not-using-indexes
  89. #
  90. # The following can be used as easy to replay backup logs or for replication.
  91. # note: if you are setting up a replication slave, see README.Debian about
  92. # other settings you may need to change.
  93. #server-id = 1
  94. #log_bin = /var/log/mysql/mysql-bin.log
  95. expire_logs_days = 10
  96. max_binlog_size = 100M
  97. #binlog_do_db = include_database_name
  98. #binlog_ignore_db = include_database_name
  99. #
  100. # * InnoDB
  101. #
  102. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  103. # Read the manual for more InnoDB related options. There are many!
  104. #
  105. # * Security Features
  106. #
  107. # Read the manual, too, if you want chroot!
  108. # chroot = /var/lib/mysql/
  109. #
  110. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  111. #
  112. # ssl-ca=/etc/mysql/cacert.pem
  113. # ssl-cert=/etc/mysql/server-cert.pem
  114. # ssl-key=/etc/mysql/server-key.pem
  115.  
  116.  
  117.  
  118. [mysqldump]
  119. quick
  120. quote-names
  121. max_allowed_packet = 16M
  122.  
  123. [mysql]
  124. #no-auto-rehash # faster start of mysql but no tab completition
  125.  
  126. [isamchk]
  127. key_buffer = 16M
  128.  
  129. #
  130. # * IMPORTANT: Additional settings that can override those from this file!
  131. # The files must end with '.cnf', otherwise they'll be ignored.
  132. #
  133. !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement