Error: Found option without preceding group inconfig file: E: \ mysql - 5.5.54 - winx64 \ mysql - 5.5.54 - winx64 \ my ini at line: 1
Fatal error defaults in handling. The Program aborted
And my my. Ini file format is basedir="E: \ mysql - 5.5.54 - winx64 \ mysql - 5.5.54 - winx64"
Datadir="E: \ mysql - 5.5.54 - winx64 \ mysql - 5.5.54 - winx64 \ data"
# Example MySQL config file for small systems.
#
# This is for a system with little memory (& lt;=64 m) where MySQL is only 2
# the from time to time and it 's important that the mysqld daemon
# doesn 't use much resources.
#
# MySQL designed look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "-- help" option.
# The following options will be passed to all MySQL clients
[client]
Default - character - set GBK=
# password=your_password
Port=3306
The socket=/TMP/mysql. The sock
# Here follows entries for some specific designed
# The MySQL server
[mysqld]
Default - character - set GBK=
Port=3306
The socket=/TMP/mysql. The sock
Skip - external - locking
Key_buffer_size=16 k
Max_allowed_packet=1 m
Table_open_cache=4
Sort_buffer_size=64 k
Read_buffer_size=256 k
Read_rnd_buffer_size=256 k
Net_buffer_length=2 k
Thread_stack=128 k
# Don 't listen on a TCP/IP port at all. This can be a security enhancement,
# if all the processes that need to connect to mysqld run on the same host.
# All interaction with the mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
Enable - named - # (using the "pipe" option) will render mysqld useless!
#
# the skip - networking
Server - id=1
# Uncomment the following if you want to log updates
# the log - bin=mysql - bin
# binary logging format - mixed it
# binlog_format=mixed
# Causes updates to a non - transactional engines using the statement format to be
# written directly to the binary log. Before using this option, make sure that
# there are no dependencies between transactional and non - transactional
# tables to the as in the statement inserts INTO t_myisam SELECT * FROM
# t_innodb; Otherwise, the slaves may diverge from the master.
# binlog_direct_non_transactional_updates=TRUE
# Uncomment the following if you are using InnoDB tables
# innodb_data_home_dir=C: \ \ mysql \ \ data \ \
# innodb_data_file_path=ibdata1:10 m: autoextend
# innodb_log_group_home_dir=C: \ \ mysql \ \ data \ \
# You can set.. _buffer_pool_size up to 50-80%
# of RAM but beware of setting the memory usage is too high,
# innodb_buffer_pool_size=16 m
# innodb_additional_mem_pool_size=2 m
# Set.. _log_file_size to 25% of buffer pool size
# innodb_log_file_size=5 m
# innodb_log_buffer_size=8 m
# innodb_flush_log_at_trx_commit=1
# innodb_lock_wait_timeout=50
[the mysqldump]
The quick
Max_allowed_packet=16 m
[mysql]
No - auto - rehash
# Remove the next comment character if you are not familiar with SQL
# safe - updates
[myisamchk]
Key_buffer_size=8 m
Sort_buffer_size=8 m
[mysqlhotcopy]
Interactive - timeout
Excuse me what is wrong
CodePudding user response:
Baidu about the error message, it is possible that the path is wrong