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.
Run mysqld -- install MySQL56 -- defaults-file = "{installation directory} \ mydefault. ini"
The service is successfully installed.
Net start mysql56, then 1067.
View mydefault. ini
5.6,70% of total RAM for dedicated server, else 10=,====,====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.
=3307==3307="C:\Program Files\MySQL\MySQL Server 5.6\"="C:\Program Files\MySQL\MySQL Server 5.6\data\"==="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"="NAS.err"=100=0=0=2000===5000=0=1=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.