How to solve odbc error 193 in mysql

Solution: 1. Use "mysqld --install" to obtain the mysql installation directory; 2. According to the mysql installation directory, search for an empty file named mysqld in the directory and delete it. The reason for this error is that the computer's default mysql execution path is different from the path you configured.

The operating environment of this tutorial: windows10 system, mysql8.0.20 version, Dell G3 computer.

How to solve odbc error 193 in mysql

Installed MySQL8.0.20 and used net start mysql to start and reported an error

Now that we have reached this step Make sure MySQL has been installed successfully, that is: use the mysqld --install command

and Service successfully installed appears, which means the installation is successful. If it doesn't work, try a few more times.Remember that you must open CMD as an administrator.

The above 193 error occurs because there may be an empty mysqld file under your MySQL installation directory, just delete it

Solution:

1 , enter again: mysqld --install command, the installation directory will appear.

2. Go to this directory and search for the mysqld file. There should be an empty file (0KB), just delete it.

Start again, successful!

Recommended learning:mysql video tutorial

The above is the detailed content of How to solve odbc error 193 in mysql. For more information, please follow other related articles on the PHP Chinese website!