Solution to the problem of crash when opening the command line window after installing MySQL 5.7

Solution to the problem of crash when opening the command line window after installing MySQL 5.7

Preface

I recently installed MySQL 5.7 and found a problem. The command line window would crash when I opened it. Later I found out that it was due to this problem.

If you cannot find the my.ini file in the MySQL installation directory, please continue reading

Workaround

Return to the desktop, find --MySQL 5.7 cammand line client in the Start menu and right-click to open the file location

Properties - Check the full path in "Target". Here I have "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.7\my.ini" "-uroot" "-p"

Check whether there is a my.ini file in the red path. If not, it is placed in the C:\ProgramData\MySQL\MySQL Server 5.7 path. Just copy my.ini over.

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support for 123WORDPRESS.COM.

You may also be interested in:
  • Mycli is a must-have tool for MySQL command line enthusiasts
  • Mysql classic high-level/command line operation (quick) (recommended)
  • C# implements MySQL command line backup and recovery
  • 18 common commands in MySQL command line
  • Summary of several ways to execute SQL in the MySQL command line
  • Add a field to the table in the MySQL command line (field name, whether it is empty, default value)
  • A brief introduction to the command line tool mycli for operating MySQL database

<<:  How to install golang under linux

>>:  Summary of the use of element's form elements

Recommend

How to implement data persistence using the vuex third-party package

Purpose: Allow the state data managed in vuex to ...

How to preview pdf file using pdfjs in vue

Table of contents Preface think Library directory...

5 ways to migrate from MySQL to ClickHouse

Data migration needs to be imported from MySQL to...

Summary of CSS3 practical methods (recommended)

1. Rounded border: CSS CodeCopy content to clipbo...

Implementing CommonJS modularity in browsers without compilation/server

Table of contents introduction 1. What is one-cli...

Two examples of using icons in Vue3

Table of contents 1. Use SVG 2. Use fontAwesome 3...

Sharing some details about MySQL indexes

A few days ago, a colleague asked me a question a...

Detailed analysis of compiling and installing vsFTP 3.0.3

Vulnerability Details VSFTP is a set of FTP serve...

Detailed explanation of Nginx http resource request limit (three methods)

Prerequisite: nginx needs to have the ngx_http_li...

Docker installs Redis and introduces the visual client for operation

1 Introduction Redis is a high-performance NoSQL ...

Ubuntu 16.04 installation tutorial under VMware 12

This article shares with you the installation tut...

Div exceeds hidden text and hides the CSS code beyond the div part

Before hiding: After hiding: CSS: Copy code The co...