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

Details on overriding prototype methods in JavaScript instance objects

Table of contents In JavaScript , we can usually ...

In-depth explanation of hidden fields, a new feature of MySQL 8.0

Preface MySQL version 8.0.23 adds a new feature: ...

Detailed tutorial on installing CentOS, JDK and Hadoop on VirtualBox

Table of contents 1. Prerequisites 1.1 Supported ...

How to deal with too many Docker logs causing the disk to fill up

I have a server with multiple docker containers d...

Detailed explanation of the use of React.cloneElement

Table of contents The role of cloneElement Usage ...

Sample code for easily implementing page layout using flex layout

Without further ado, let's get straight to th...

js realizes horizontal and vertical sliders

Recently, when I was doing a practice project, I ...

JavaScript uses canvas to draw coordinates and lines

This article shares the specific code of using ca...

Several ways to submit HTML forms_PowerNode Java Academy

Method 1: Submit via the submit button <!DOCTY...

After docker run, the status is always Exited

add -it docker run -it -name test -d nginx:latest...

How to create, start, and stop a Docker container

1. A container is an independently running applic...

Building FastDFS file system in Docker (multi-image tutorial)

Table of contents About FastDFS 1. Search for ima...

Cross-database association query method in MySQL

Business scenario: querying tables in different d...