Home  >  Article  >  Database  >  navicat 1146 error

navicat 1146 error

angryTom
angryTomOriginal
2019-08-07 14:10:508990browse

navicat 1146 error

A 1146 error occurred when opening mysql-front to enter the database. Baidu later said that this error was caused by the lack of the mysql library, so I just needed to complete the corresponding files. However, I did not have a backup myself. There is one online at CSDN, but downloading requires points, so I thought I could only reinstall it once? , later I remembered that there is no built-in data library after version 6.x, and it can only be generated through initialization. That is, uninstall and reinstall.

Recommended tutorial: MySQL introductory video tutorial

##Recovery steps:

1. Execute

net stop mysql,Stop mysql service

2. Execute

mysqld -remove,Remove service

3. Execute

mysqld -install, install the service

4. Execute

mysqld --initialize-insecure, initialize

5. Execute

net start mysql, start mysql service

The above is the detailed content of navicat 1146 error. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn