When MySql is started in Windows 7, the following error occurs: Table 'MySQL. plugin 'doesn' texist _ mysql.
Source: Internet
Author: User
When MySql is started in Windows 7, the error Table bitsCN.com is returned.
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 "max_connections = 100query_cache_size = 8Mtable_cache = 256tmp_table_size = bytes = 8 bytes = 256 K # *** INNODB Specific options *** innodb_data_home_dir =" d: /database/InnoDB/"started = bytes = 1innodb_log_buffer_size = bytes = 15Minnodb_log_file_size = 10Minnodb_thread_concurrency = 10 after writing the configuration file, I tried to start mysqld directly under cmd, but always failed, 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:///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! I went back to the mysql installation directory and checked it carefully. there is a data directory (D:/database/mysql/data) under the installation directory, which contains a mysql folder, this 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. BitsCN.com
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.