MySQL compact version installs and avoids 1055 errors and msvcp120.dll loss

Source: Internet
Author: User
Tags compact

MySQL compact version installs and avoids 1055 errors and msvcp120.dll loss

The installation of the MySQL compact version is quick and easy, with 5.7 and the latest version 8 installed in roughly the same way.
You may encounter a 1055 error when using GROUP by grouping.
Additionally, you may experience msvcp120.dll loss during installation. (See problems that may be encountered)

Unzip add environment variable add my.ini file

In the MySQL root directory, which is the same directory as the Bin folder, create the My.ini

[mysql]# 设置mysql客户端默认字符集default-character-set=utf8[mysqld]#设置3306端口port = 3306# 设置mysql的安装目录basedir=C:\mysql-5.7.22-winx64# 设置mysql数据库的数据的存放目录datadir=C:\mysql-5.7.22-winx64\data# 允许最大连接数max_connections=200# 服务端使用的字符集默认为8比特编码的latin1字符集character-set-server=utf8# 创建新表时将使用的默认存储引擎default-storage-engine=INNODB

Basedir and DataDir, please modify according to your actual installation directory, focusing on
If you encounter a 1055 error, add the last
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Different computer sql_mode may not be the same, the last mention.

Initializing the database

Permissions are important to open Cmd.exe with administrator privileges
.\mysqld.exe --initialize --user=mysql --console
2018-07-16T04:34:04.664182Z 1 [Note] A temporary password is generated for [email protected]: -h1JoJrrAwXz

Where '-H1JOJRRAWXZ ' is the initial password, with no spaces

The last row shows the password.

Installation Services

.\mysqld.exe --install mysql

Service successfully installed.

Start the service

net start mysql

mysql 服务正在启动 .mysql 服务已经启动成功。
Log in and modify the initialization password
PS C:\Windows\system32> mysql -u root -pEnter password: ************mysql> set password for [email protected]=password(‘你的密码‘);Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
A possible problem.

If you need to reload, administrator privileges to execute Cmd.exe

net stop mysqlmysqld.exe --remove删除解压后的所有文件再次上述操作

If you are prompted to lose msvcp120.dll when executing the command line, or if memory is wrong, or no response,
Internet search ' DirectX Repair tool ' can be used to fill most DLLs.

MySQL compact version installs and avoids 1055 errors and msvcp120.dll loss

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.