When MySql is started in windows 7, the following error occurs: Table 'mysql. In in 'doesn' t exist.

Source: Internet
Author: User


When MySql is started in windows 7, the error Table 'mysql. plugin 'doesn' t exist solution: 64-bit Windows 7, install mysql5.27 _ win64, and customize the installation to D:/database/mysql. In the last step of initialization, the configuration file is always "not responded ". End the process and manually create my. INI file [client] port = 3335 [mysql] default-character-set = utf8 [mysqld] # The TCP/IP Port the MySQL Server will listen onport = 3335 basedir = "D: /database/mysql/"datadir =" D:/database/data/"character-set-server = utf8default-storage-engine = INNODB # Set the SQL mode to strictsql-mode =" STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, export "www.2cto.com max_connections = 100query_cache_size = 8Mtable_cache = 256tmp_table_size = bytes = 8 bytes = 256 K # *** INNODB Specific options *** quota = "D: /database/InnoDB/"tables = 1innodb_log_buffer_size = bytes = 15Minnodb_log_file_size = bytes = 10 www.2cto.com after writing the configuration file, I try to start mysqld directly in cmd, but it always fails, you can see the error log by time as the file name in D:/database/data/. There are two Table 'mysql. plugin 'doesn' t exist .................................. ............. [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host 'doesn' t exist has searched for many solutions on the Internet, but failed to solve my problem one by one. Later I saw another article: http://www.bkjia.com/database/201209/158224.html This article does not solve this problem directly, but it has inspired me to try to initialize the table in this way, but prompts that I do not have a mysql table !!! In this article, it is clear that "... insert "use mysql;" at the beginning of each file ;"...... "I followed this method, but it prompts that there is no mysql table! Www.2cto.com I went back to the mysql installation directory and checked it carefully. There was a data directory (D:/database/mysql/data) under the installation directory ), there is a mysql folder, which is the default database data storage location. Since I have modified the data storage location, can I directly copy all the files under this data file to D:/database/data? So I put all the files in the default data storage path D:/database/mysql/data in the mysql installation directory into D:/database/data/, and started mysqld again! I really don't know about the mysql database. The installation was successful before. For the first time I encountered this problem, mark it.

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.