Mysql startup failure error 1067

Source: Internet
Author: User

Mysql startup failure error 1067 after Mysql is installed, restart the computer and find that the service cannot be started for the second time. The prompt is as follows: ---------------------- the MySQL service cannot be started. System error. System Error 1067 occurs. The process stops unexpectedly. ------------------ Check the error log in the directory F: \ ProgramData \ MySQL Server 5.5 \ data. The following content is displayed: 130825 20:47:50 [Note] Plugin 'federated 'is disabled.130825 20:47:50 InnoDB: the InnoDB memory heap is disabled130825 20:47:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions130825 20:47:50 InnoDB: Compressed tables use zlib runtime 20:47:50 InnoDB: Error: unable to create temporary file; errno: 2130825 20:47:50 [ERROR] Plugin 'innodb' init function returned error.130825 20:47:50 [ERROR] Plugin 'innodb' registry as a storage engine failed.130825 20:47:50 [ERROR] Unknown/unsupported storage engine: INNODB130825 20:47:50 [ERROR] Aborting, where the core prompt is this, the temporary file cannot be created: 130825 20:47:50 InnoDB: Error: unable to create temporary file; errno: 2 SO view my. in the ini [mysqld] section, add: # Your Own temporary file directory tmpdir = "temporary directory "------ --------------- The reason is that after I have installed the system, I modified the configuration of the temporary directory of the system and directed it to a ramdisk partition (memory partition disk). After the partition is shut down, the data will disappear. The temporary file directory is automatically created only when mysql is installed, so the database can be started properly after installation. After the restart (ramdisk partition), the directory does not exist, and Mysql does not create this temporary file directory when starting the service, so an error is reported.

Related Article

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.