mysql-5.6.14-winx64 配置版 配置出现错误

TimZhou 发布于 2013/10/19 18:50
阅读 1K+
收藏 0

my.ini  内容如下:

[WinMySQLAdmin]
Server=C:/Program Files/MySQL/bin/mysqld.exe

[client]
no-beep

# pipe
# socket=mysql
port=3306

[mysql]

 

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

explicit_defaults_for_timestamp = TRUE

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 2G

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.

basedir="C:\Program Files\MySQL\"
datadir="C:\Program Files\MySQL\data"
server="C:\Program Files\MySQL\bin\mysqld.exe"
port=3306
server_id=1

general-log=0
general_log_file="mysql_general.log"
slow-query-log=1
slow_query_log_file="mysql_slow_query.log"
long_query_time=10

log-error="mysql_error_log.err"


default-storage-engine=INNODB
max_connections=1024
query_cache_size=128M
key_buffer_size=128M
innodb_flush_log_at_trx_commit=1
innodb_thread_concurrency=128
innodb_autoextend_increment=128M
tmp_table_size=128M


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
character-set-server=utf8

 

 

 

错误日志:

 

2013-10-19 12:38:57 6948 [Note] Plugin 'FEDERATED' is disabled.
2013-10-19 12:38:57 6948 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-19 12:38:57 6948 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-19 12:38:57 6948 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-19 12:38:57 6948 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-19 12:38:57 6948 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-10-19 12:38:57 6948 [Note] InnoDB: Completed initialization of buffer pool
2013-10-19 12:38:57 6948 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-19 12:38:57 6948 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-19 12:38:58 6948 [Note] InnoDB: Waiting for purge to start
2013-10-19 12:38:58 6948 [Note] InnoDB: 5.6.14 started; log sequence number 1625977
2013-10-19 12:38:58 6948 [ERROR] mysqld: unknown option '-c'
2013-10-19 12:38:58 6948 [ERROR] Aborting

2013-10-19 12:38:58 6948 [Note] Binlog end
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'partition'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_METRICS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_CMP'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'INNODB_TRX'
2013-10-19 12:38:58 6948 [Note] Shutting down plugin 'InnoDB'
2013-10-19 12:38:58 6948 [Note] InnoDB: FTS optimize thread exiting.
2013-10-19 12:38:58 6948 [Note] InnoDB: Starting shutdown...
2013-10-19 12:38:59 6948 [Note] InnoDB: Shutdown completed; log sequence number 1625987
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'BLACKHOLE'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'ARCHIVE'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'MRG_MYISAM'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'MyISAM'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'MEMORY'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'CSV'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'sha256_password'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'mysql_old_password'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'mysql_native_password'
2013-10-19 12:38:59 6948 [Note] Shutting down plugin 'binlog'
2013-10-19 12:38:59 6948 [Note] mysqld: Shutdown complete

2013-10-19 12:45:55 9260 [Note] Plugin 'FEDERATED' is disabled.
2013-10-19 12:45:55 9260 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-19 12:45:55 9260 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-19 12:45:55 9260 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-19 12:45:55 9260 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-19 12:45:55 9260 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-10-19 12:45:55 9260 [Note] InnoDB: Completed initialization of buffer pool
2013-10-19 12:45:55 9260 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-19 12:45:55 9260 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-19 12:45:55 9260 [Note] InnoDB: Waiting for purge to start
2013-10-19 12:45:55 9260 [Note] InnoDB: 5.6.14 started; log sequence number 1625987
2013-10-19 12:45:55 9260 [ERROR] mysqld: unknown option '-c'
2013-10-19 12:45:55 9260 [ERROR] Aborting

2013-10-19 12:45:55 9260 [Note] Binlog end
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'partition'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_METRICS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_CMP'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'INNODB_TRX'
2013-10-19 12:45:55 9260 [Note] Shutting down plugin 'InnoDB'
2013-10-19 12:45:55 9260 [Note] InnoDB: FTS optimize thread exiting.
2013-10-19 12:45:55 9260 [Note] InnoDB: Starting shutdown...
2013-10-19 12:45:57 9260 [Note] InnoDB: Shutdown completed; log sequence number 1625997
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'BLACKHOLE'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'ARCHIVE'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'MRG_MYISAM'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'MyISAM'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'MEMORY'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'CSV'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'sha256_password'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'mysql_old_password'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'mysql_native_password'
2013-10-19 12:45:57 9260 [Note] Shutting down plugin 'binlog'
2013-10-19 12:45:57 9260 [Note] mysqld: Shutdown complete

 

 

 

加载中
0
Tuesday
Tuesday

server_id=1

character-set-server=utf8

[client]
no-beep

先删除... 你这配置在哪抄的? 怎么感觉怪怪的, 建议看看默认压缩包中的配置文件.

 

0
TimZhou
TimZhou

引用来自“Tuesday”的答案

server_id=1

character-set-server=utf8

[client]
no-beep

先删除... 你这配置在哪抄的? 怎么感觉怪怪的, 建议看看默认压缩包中的配置文件.

 

在网上找了N个配置方法 各种错误,最后实在是崩溃了,去官网下了个msi版的.非常感谢您的回答!
0
Tuesday
Tuesday

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
port=3306
basedir="D:/xampps/mysql/"
datadir="D:/xampps/mysql/data/"
tmpdir="D:/xampps/mysql/data/"
socket = "D:/xampps/mysql/data/mysql.sock"
log-error="D:/xampps/mysql/data/mysql_error.log"

#server_id = 2
#skip-locking

max_connections=1000
query_cache_size=32M
table_open_cache=256
query_cache_size=15M

tmp_table_size=32M
thread_cache_size=8

innodb_data_home_dir="D:/xampps/mysql/data/"
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit =1

innodb_log_buffer_size=128M
innodb_buffer_pool_size=128M
innodb_log_file_size=10M
innodb_thread_concurrency=16

join_buffer_size = 128M
sort_buffer_size = 32M
read_rnd_buffer_size = 32M

max_allowed_packet = 32M

explicit_defaults_for_timestamp=true
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]
default-character-set=utf8

 

参考一下. 可用于mysql 5.7.12

0
TimZhou
TimZhou

引用来自“Tuesday”的答案

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
port=3306
basedir="D:/xampps/mysql/"
datadir="D:/xampps/mysql/data/"
tmpdir="D:/xampps/mysql/data/"
socket = "D:/xampps/mysql/data/mysql.sock"
log-error="D:/xampps/mysql/data/mysql_error.log"

#server_id = 2
#skip-locking

max_connections=1000
query_cache_size=32M
table_open_cache=256
query_cache_size=15M

tmp_table_size=32M
thread_cache_size=8

innodb_data_home_dir="D:/xampps/mysql/data/"
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit =1

innodb_log_buffer_size=128M
innodb_buffer_pool_size=128M
innodb_log_file_size=10M
innodb_thread_concurrency=16

join_buffer_size = 128M
sort_buffer_size = 32M
read_rnd_buffer_size = 32M

max_allowed_packet = 32M

explicit_defaults_for_timestamp=true
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]
default-character-set=utf8

 

参考一下. 可用于mysql 5.7.12

谢谢!

返回顶部
顶部