MySQL 1067 troubleshooting on x64 system _ MySQL

MySQL 1067 problem solving on x64 system bitsCN.com

MYSQL was used in a recent project, because I had done it before, so I didn't think much about it. I just finished the next step. On the official website, I decided to launch an installer (5.26), modified the default location and configuration, followed by next, and finally started the configuration, mysql installer stops at attempting to start service.

Think about the system crash (the aliyun server, 1 GB memory, server 2008R2, not very smooth) and restart.

Then cmd "net start mysql56

Error 1067 displayed

So the nightmare started ......

First, do you think the installation is not successful? please try again. So uninstall and install again. The problem persists. The configuration option is not displayed after each installation. I figured out if there was a problem. I flipped through the installation log.

System Error: "Error 1918. Error installing ODBC driver Mysql ODBC 5.2 ANSI Driver

This is the problem...

Consult the materials (http://www.cnblogs.com/rangeon/p/3410459.html) and copy a new name. Mysql installer installs the x86 version.

Finally, odbc is over.

Then I thought that there was no problem, so I had to reinstall it. the configuration page still could not be displayed, and the mysql56 service could not be found in services. msc.

Manually.

Go to the bin folder in the mysql installation directory.

Execute mysqld -- install MySQL56 -- defaults-file = "{installation directory}/mydefault. ini"

The service is successfully installed.

Net start mysql56, then 1067.

View mydefault. ini

# 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]# 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 = 128M# 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.# server_id = .....# basedir=# datadir=# port =# 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

Basedir, datadir, and port are not written. fill in the corresponding path.

Still not working. I found a copy of my. ini configuration on the Internet and posted it for your reference.

[client]no-beepport=3307[mysql]default-character-set=utf8[mysqld]port=3307basedir="C:/Program Files/MySQL/MySQL Server 5.6/"datadir="C:/Program Files/MySQL/MySQL Server 5.6/data/"character-set-server=utf8default-storage-engine=INNODBsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"log-error="NAS.err"max_connections=100query_cache_size=0query_cache_type=0table_open_cache=2000innodb_buffer_pool_size=10Minnodb_log_file_size=48Minnodb_concurrency_tickets=5000innodb_stats_on_metadata=0innodb_file_per_table=1flush_time=0

Note: The default mysql port is 3306. because this port is occupied by my system, it is changed to 3307. Log-error = "nas. err" is a log file generated under data. If an error occurs, check this file. if the configuration file is incorrect

InnoDB: Assertion failure in thread xxxx in file ut0mem. cc line 105

InnoDB: Failing assertion: ret |! Assert_on_error

In addition, please configure innodb_buffer_pool_size on your own. The original configuration is 256 MB. because the memory is small, the system error 1455 is directly displayed, and the page file is insufficient. please configure it as needed.

BitsCN.com