Guest User

Untitled

a guest
Jun 21st, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.98 KB | None | 0 0
  1. # apt-get update && apt-get upgrade
  2. # groupadd mysql
  3. # useradd -r -g mysql mysql
  4. # apt-get install libaio1
  5. # wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.12-debian6.0-x86_64.deb
  6. # dpkg -i mysql-5.6.12-debian6.0-x86_64.deb
  7. # cd /usr/local
  8. # ln -s /opt/mysql/server-5.6 mysql
  9. # cd mysql
  10. # scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql
  11. # rm /opt/mysql/server-5.6/my.cnf
  12. # ln -s /var/ini/my.cnf /opt/mysql/server-5.6/my.cnf
  13. # cp support-files/mysql.server /etc/init.d/mysql
  14. # service mysql start
  15.  
  16. root@Debian-70-wheezy-64-minimal /usr/local/mysql # service mysql start
  17. /opt/mysql/server-5.6/bin/my_print_defaults: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - No such file or directory)
  18. Fatal error in defaults handling. Program aborted
  19. Starting MySQL
  20. .[....] The server quit without updating PID file (/opt/mysql/server-5.6/data/De[FAIL70-wheezy-64-minimal.pid). ... failed!
  21.  
  22. root@Debian-70-wheezy-64-minimal ~ # updatedb
  23. root@Debian-70-wheezy-64-minimal ~ # locate .err
  24. /var/log/mail.err
  25. /var/log/news/news.err
  26.  
  27. #
  28. # The MySQL database server configuration file.
  29. #
  30. # You can copy this to one of:
  31. # - "/etc/mysql/my.cnf" to set global options,
  32. # - "~/.my.cnf" to set user-specific options.
  33. #
  34. # One can use all long options that the program supports.
  35. # Run program with --help to get a list of available options and with
  36. # --print-defaults to see which it would actually understand and use.
  37. #
  38. # For explanations see
  39. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  40.  
  41. # This will be passed to all mysql clients
  42. # It has been reported that passwords should be enclosed with ticks/quotes
  43. # escpecially if they contain "#" chars...
  44. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  45. [client]
  46. port = 3306
  47. socket = /var/run/mysqld/mysqld.sock
  48.  
  49. # Here is entries for some specific programs
  50. # The following values assume you have at least 32M ram
  51.  
  52. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  53. [mysqld_safe]
  54. socket = /var/run/mysqld/mysqld.sock
  55. nice = 0
  56.  
  57. [mysqld]
  58. #
  59. # * Basic Settings
  60. #
  61. user = mysql
  62. pid-file = /var/run/mysqld/mysqld.pid
  63. socket = /var/run/mysqld/mysqld.sock
  64. port = 3306
  65. basedir = /usr/local/mysql
  66. datadir = /var/lib/mysql
  67. tmpdir = /tmp
  68. lc-messages-dir = /opt/mysql/server-5.6/share/english
  69. skip-external-locking
  70. #
  71. # Instead of skip-networking the default is now to listen only on
  72. # localhost which is more compatible and is not less secure.
  73. bind-address = 127.0.0.1
  74. #
  75. # * Fine Tuning
  76. #
  77. key_buffer = 16M
  78. max_allowed_packet = 16M
  79. thread_stack = 192K
  80. thread_cache_size = 8
  81. # This replaces the startup script and checks MyISAM tables if needed
  82. # the first time they are touched
  83. myisam-recover = BACKUP
  84. #max_connections = 100
  85. #table_cache = 64
  86. #thread_concurrency = 10
  87. #
  88. # * Query Cache Configuration
  89. #
  90. query_cache_limit = 1M
  91. query_cache_size = 16M
  92. #
  93. # * Logging and Replication
  94. #
  95. # Both location gets rotated by the cronjob.
  96. # Be aware that this log type is a performance killer.
  97. # As of 5.1 you can enable the log at runtime!
  98. #general_log_file = /var/log/mysql/mysql.log
  99. #general_log = 1
  100. #
  101. # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
  102. #
  103. # Here you can see queries with especially long duration
  104. #log_slow_queries = /var/log/mysql/mysql-slow.log
  105. #long_query_time = 2
  106. #log-queries-not-using-indexes
  107. #
  108. # The following can be used as easy to replay backup logs or for replication.
  109. # note: if you are setting up a replication slave, see README.Debian about
  110. # other settings you may need to change.
  111. #server-id = 1
  112. #log_bin = /var/log/mysql/mysql-bin.log
  113. expire_logs_days = 10
  114. max_binlog_size = 100M
  115. #binlog_do_db = include_database_name
  116. #binlog_ignore_db = include_database_name
  117. #
  118. # * InnoDB
  119. #
  120. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  121. # Read the manual for more InnoDB related options. There are many!
  122. #
  123. # * Security Features
  124. #
  125. # Read the manual, too, if you want chroot!
  126. # chroot = /var/lib/mysql/
  127. #
  128. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  129. #
  130. # ssl-ca=/etc/mysql/cacert.pem
  131. # ssl-cert=/etc/mysql/server-cert.pem
  132. # ssl-key=/etc/mysql/server-key.pem
  133.  
  134.  
  135.  
  136. [mysqldump]
  137. quick
  138. quote-names
  139. max_allowed_packet = 16M
  140.  
  141. [mysql]
  142. #no-auto-rehash # faster start of mysql but no tab completition
  143.  
  144. [isamchk]
  145. key_buffer = 16M
  146.  
  147. #
  148. # * IMPORTANT: Additional settings that can override those from this file!
  149. # The files must end with '.cnf', otherwise they'll be ignored.
  150. #
  151. !includedir /etc/mysql/conf.d/
  152.  
  153. root@Debian-70-wheezy-64-minimal ~ # mysql -u root
  154. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  155.  
  156. mysql_install_db
  157.  
  158. /opt/mysql/server-5.6/bin/my_print_defaults: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - No such file or directory)
  159.  
  160. The server quit without updating PID file (/opt/mysql/server-5.6/data/De[FAIL70-wheezy-64-minimal.pid)
Add Comment
Please, Sign In to add comment