Configuration file-mysql non-installed version cannot be started to report error 1067

Source: Internet
Author: User
Check the configuration file on the Internet. My. ini is copied from my_small.ini. Added only the mysql field basedirD: mysql-5.5.24-winx64datadirD: mysql-5.5.24-winx64datacharacter-set-serverutf8client field default-character-setutf8 and cmd started with administrator identity during installation. Is there an impact ??? Error log: 1402179: 59: 30 [Note] P... configuration file mysql

Check the configuration file on the Internet.
My. ini is copied from my_small.ini.
Added only
Mysql field
Basedir = D:/mysql-5.5.24-winx64
Datadir = D:/mysql-5.5.24-winx64/data
Character-set-server = utf8
Client field
Default-character-set = utf8

In addition, cmd is started as an administrator during installation. Is there an impact ???

Error log:
140217 9:59:30 [Note] Plugin 'Federated 'is disabled.
140217 9:59:30 InnoDB: The InnoDB memory heap is disabled
140217 9:59:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140217 9:59:30 InnoDB: Compressed tables use zlib 1.2.3
140217 9:59:30 InnoDB: Initializing buffer pool, size = 128.0 M
140217 9:59:30 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file. \ ibdata1 did not exist:
InnoDB: a new database to be created!
140217 9:59:30 InnoDB: Setting file. \ ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140217 9:59:30 InnoDB: Log file. \ ib_logfile0 did not exist: new to be created
InnoDB: Setting log file. \ ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
140217 9:59:30 InnoDB: Log file. \ ib_logfile1 did not exist: new to be created
InnoDB: Setting log file. \ ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment (s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140217 9:59:31 InnoDB: Waiting for the background threads to start
140217 9:59:32 InnoDB: 1.1.8 started; log sequence number 0
140217 9:59:32 [ERROR] MySQL: unknown variable 'default-character-set = gbk'
140217 9:59:32 [ERROR] Aborting

140217 9:59:32 InnoDB: Starting shutdown...
140217 9:59:33 InnoDB: Shutdown completed; log sequence number 1595675
140217 9:59:33 [Note] MySQL: Shutdown complete

Various types of information cannot be solved. Please help me.
Additional: What's amazing is why unknown variable 'default-character-set = gbk'
I didn't set default-character-set = gbk at all, and set default-character-set = tutf8.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.