Linux does not have the My.cnf file solution, is completely my own whole, a lot of tutorials are nonsense (Zhuan)

Http://blog.csdn.net/jspping/article/details/40400691?utm_source=tuicool&utm_medium=referral

******************************************************************************

I read a lot about Linux without my.cnf blog, what is RMP install no my.cnf file Ah, and then what two methods Ah, I have no words, if you know will not check the information, you dare not take charge of the point? Tell me the details. Some say it is useful to copy a. cnf file from/usr/share/mysql to/etc? Profile data not to others, copy a yarn? Copy who will!

MY.CNF configuration file:

[Java]View PlainCopy

2. # for advice The change settings
4. # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
6. # * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
8. # * * * default location during install, and would be replaced if you
10. # * * * * Upgrade to a newer version of MySQL.
12. [Mysqld]
14. #innodb
16. # Remove Leading
18. # and set to the amount of RAM for the most important data
20. # Cache in MySQL.  Start at 70% of all RAM for dedicated server, else 10%.
22. Innodb_buffer_pool_size = 4000M
24. innodb_additional_mem_pool_size=60m
26. Innodb_data_home_dir=
28. Innodb_date_file_path=ibdata1:20m:autoextend
30. Innodb_log_group_home_dir=/var/log/innodb_log
32. innodb_log_files_in_group=2
34. innodb_log_file_size=30m
36. innodb_log_buffer_size=3m
38. Innodb_doublewrite=on
40. innodb_open_file=
42. Innodb_file_per_table=on
44. innodb_max_dirty_page_pct=
46. back_log=
48. interactive_timeout=3600
50. key_buffer_size=10m
52. max_allow_packet=40440
54. max_connections=
56. max_tmp_tables=
58. query_cache_size=10m
60. sor_buffer_size=10m
62. Table_open_cache=
66. # Remove Leading
68. # to turn on a very important data integrity option:logging
70. # Changes to the binary log between backups.
72. #lob_bin
74. Log_bin=on
76. Log_bin_basename=/var/lib/mysql/mysqld-bin
78. #
80. # Remove Leading # To set options mainly useful for reporting servers.
82. # The server defaults is faster for transactions and fast selects.
84. # Adjust sizes as needed, experiment to find the optimal values.
86. Join_buffer_size = 128M
88. Sort_buffer_size = 2M
90. Read_rnd_buffer_size = 2M
92. Datadir=/var/lib/mysql
94. Socket=/var/lib/mysql/mysql.sock
96. Character_set_server=utf8
98. #init_connect =' SET NAMES UTF8 '
100. # Disabling Symbolic-links is recommended to prevent assorted security risks
102. symbolic-links=0
106. # Recommended in standard MySQL setup
108. Sql_mode=no_engine_substitution,strict_trans_tables
110. #general_log
112. General_log=on
114. General_log_file=/var/lib/mysql/localhost.log
116. #slow_query_log
118. Slow_query_log=on
120. Slow_query_log_file=/var/lib/mysql/localhost-slow.log
122. Slow_launch_time=2
126. [Mysqld_safe]
128. Log-error=/var/log/mysqld.log
130. Pid-file=/var/run/mysqld/mysqld.pid

If the above file is configured, perform MySQL login, throw xxxx.line Such an exception, go to /usr/share/mysql below to copy a. cnf file header to replace the above MY.CNF header code, if you want to copy a to/ etc, named My.cnf, then put the above copy, version information and some details of the file

Specific path configuration, and parameter configuration see your own installation situation

I replaced these sentences with the/USR/SHARE/MYSQL/MY-DEFAULT.CNF header file:

[Plain]View PlainCopy

1. # for advice The change settings
2. # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
3. # * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
4. # * * * default location during install, and would be replaced if you
5. # * * * * Upgrade to a newer version of MySQL.
7. [Mysqld]

Then [MYSQLLD] below all is copy above, starting with the # number on line 7th of the configuration file above, can resolve similar Fatal Error in defaults handling. Program aborted or XXXX line xxxx error problem, according to the specific situation of your server specific analysis, my is based on my configured as the benchmark

Once configured, MySQL can log in normally to view and start the log:

[Plain]View PlainCopy

2. Mysql> Show variables like ' log_% ';
4. +----------------------------------------+------------------------------------+
6. | variable_name | Value |
8. +----------------------------------------+------------------------------------+
10. | Log_bin | OFF |
12. |                                    Log_bin_basename | |
14. |                                    Log_bin_index | |
16. | log_bin_trust_function_creators | OFF |
18. | log_bin_use_v1_row_events | OFF |
20. | Log_error | /var/lib/mysql/ay140615022008z.err |
22. | Log_output | FILE |
24. | log_queries_not_using_indexes | OFF |
26. | Log_slave_updates | OFF |
28. | log_throttle_queries_not_using_indexes | 0 |
30. | log_warnings | 1 |
32. +----------------------------------------+------------------------------------+
34. Rows in Set (0.01 sec)
38. Mysql> Show variables like ' Log_bin ';
40. +---------------+-------+
42. | variable_name | Value |
44. +---------------+-------+
46. | Log_bin | OFF |
48. +---------------+-------+
50. 1 row in Set (0.00 sec)

[Plain]View PlainCopy

1. Mysql> select version ();
2. +-----------+
3. | Version () |
4. +-----------+
5. | 5.6.10 |
6. +-----------+
7. 1 row in Set (0.02 sec)

Need to open can set their own, hope can help everyone, less go fruitless!

Linux does not have the My.cnf file solution, is completely my own whole, a lot of tutorials are nonsense (Zhuan)