27
4
i installed xampp version 3.2.1 on my laptop and mysql was working fine on it before but suddenly mysql stopped working while apache and others were working.
when i click on start mysql it displays this error
i use windows 10
我在笔记本电脑上安装了Xampp 3.2.1版，之前MySQL在它上面运行得很好，但突然MySQL停止运行，而阿帕奇和其他公司都在运行。当我点击开始MySQL时，它显示这个错误我使用Windows 10
个人中心
文章发布
退出8:52:32 AM [mysql] Status change detected: running
8:52:40 AM [mysql] Status change detected: stopped
8:52:40 AM [mysql] Error: MySQL shutdown unexpectedly.
8:52:40 AM [mysql] This may be due to a blocked port, missing dependencies,
8:52:40 AM [mysql] improper privileges, a crash, or a shutdown by another method.
8:52:40 AM [mysql] Press the Logs button to view error logs and check
8:52:40 AM [mysql] the Windows Event Viewer for more clues
8:52:40 AM [mysql] If you need more help, copy and post this
8:52:40 AM [mysql] entire log window on the forums
then i checked the log file and this is what i found there
然后我检查了日志文件，这是我在那里发现的
`
`
2018-06-23 08:52:32 2354 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
180623 8:52:32 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180623 8:52:32 [Note] InnoDB: The InnoDB memory heap is disabled
180623 8:52:32 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
180623 8:52:32 [Note] InnoDB: Memory barrier is not used
180623 8:52:32 [Note] InnoDB: Compressed tables use zlib 1.2.3
180623 8:52:32 [Note] InnoDB: Not using CPU crc32 instructions
180623 8:52:32 [Note] InnoDB: Initializing buffer pool, size = 16.0M
180623 8:52:32 [Note] InnoDB: Completed initialization of buffer pool
180623 8:52:32 [Note] InnoDB: Highest supported file format is Barracuda.
180623 8:52:32 [Note] InnoDB: 128 rollback segment(s) are active.
180623 8:52:32 [Note] InnoDB: Waiting for purge to start
180623 8:52:33 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1600924
180623 8:52:33 [Note] Plugin 'FEEDBACK' is disabled.
180623 8:52:33 [Note] Server socket created on IP: '::'.
180623 8:52:33 [Warning] 'db' entry 'size of datafile is: 1907 should be: 1760
180409 15:17:15 [error] mysql.db: got error: 0 when reading datafile at record: 3
180409 15:17:15 [error] got an error from unknown thread, ha _myisam.cc:952
180409 15:17:15 [Warning] Recove@80409 15:17:15 [Warning] Checking table: '.\mysql\db'
180409 15:17:15 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
180409 15:17:15 [ERROR] mysql.db:' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
180623 8:52:33 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
180623 8:52:33 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
180623 8:52:33 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
180623 8:52:33 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180623 8:52:33 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
180623 8:52:33 [Note] Started replication for '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
180623 8:52:33 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
180623 8:52:33 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-180401@002018@003a51@003a15@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@[email protected]' position: 4
180623 8:52:33 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
180623 8:52:33 [ERROR] Failed to open the relay log '.\mysql-relay-bin-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@[email protected]' (relay_log_pos 4)
180623 8:52:33 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
180623 8:52:33 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
180623 8:52:33 [ERROR] Could not find target log during relay log initialization
180623 8:52:33 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
180623 8:52:33 [ERROR] Initialized Master_info from 'master-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@[email protected]' failed
180623 8:52:33 [Warning] Reading of some Master_info entries failed
180623 8:52:33 [ERROR] Failed to initialize multi master structures
180623 8:52:33 [ERROR] Aborting
180623 8:52:33 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Error reading relay log event: slave SQL thread was killed
180623 8:52:33 [Note] InnoDB: FTS optimize thread exiting.
180623 8:52:33 [Note] InnoDB: Starting shutdown...
180623 8:52:35 [Note] InnoDB: Shutdown completed; log sequence number 1600934
180623 8:52:35 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete`
"Missing system table mysql.roles_mapping; please run mysql_upgrade to create it" - maybe you need to run mysql_upgrade?
“MISSING SYSTEM TABLE MYSING_ROLES_MAPPING；请运行MYSQL_UPGRADE以创建它”--也许您需要运行MYSQL_UPGRADE？
how can i run mysql_upgrade
如何运行MySQL_Upgrade
This command must be in your mysql installation.
此命令必须位于您的MySQL安装中。
Deleting all files (no folders!) in the /mysql/data folder, except /mysql/data/my.ini and /data/ibdata1 helped in my case.
删除所有文件(无文件夹！)在/mysql/data文件夹中，除了/mysql/data/my.ini和/data/ibdata1对我有帮助之外。
Deleting all master-* files and multi-master.info worked for me.
删除所有master-*文件和多master.info对我起作用了。
Copying files and folders from C:\xampp\mysql\backup to C:\xampp\mysql\data
and removing all my database folders worked for me.
But first try without deleting your database files.
将文件和文件夹从C：\xampp\MySQL\Backup复制到C：\xampp\MySQL\Data，并删除我所有的数据库文件夹。但在不删除数据库文件的情况下先尝试。
Delete mysql.pid file.
you can delete also other master-* files
删除mysql.pid文件。您还可以删除其他master-*文件
Go to C:\xampp\mysql\data and delete all master files.multi-mastermaster-version
转到C：\xampp\MySQL\Data并删除所有主文件。多母版母版
Thank you! Worked for me too, but I have no idea what caused it.
谢谢!对我也有效，但我不知道是什么原因造成的。
Thanks this worked for me. It would be great if you could elaborate what's happened though
谢谢，这对我很管用。如果你能详细说明发生了什么，那就太好了
27
4
0
目前我正在构建相当大的网络系统，我需要强大的 SQL 数据库解决方案。我选择 Mysql 而不是 Postgres，因为一些任务需要只读(MyISAM 引擎)而其他任务需要大量写入(InnoDB)。
我在 mysql 中使用如下命令。当它显示表格数据时，它被格式化为一个非常干净的表格，间距均匀且 |作为列分隔符。 SELECT * FROM TABLE_NAME; 当我从 CLI 运行命令时，如下
我知道这个问题之前已经被问过好几次了，我已经解决了很多问题，但到目前为止没有任何效果。 MySQL 试图将自身安装到的目录 (usr/local/mysql) 肯定有问题。关于我的错误的奇怪之处在于我
以下是我的 SQL 数据结构，我正在尝试如下两个查询: Select Wrk_ID, Wrk_LastName, Skill_Desc from Worker, Skill where
我们有一个本地 mysql 服务器(不在公共(public)域上)，并希望将该服务器复制到我们拥有的 google 云 sql 实例。我的问题是:1.这可能吗？2.我们的本地服务器只能在本地网络上访问
我有一个表(test_table)，其中一些字段值(例如字段 A、B 和 C)是从外部应用程序插入的，还有一个字段(字段 D)，我想从现有表(store_table)插入其值，但在插入前者(A、B 和
我想创建一个 AWS RDS 实例，然后使用 terraform 管理数据库用户。因此，首先，我创建了一个 RDS 实例，然后使用创建的 RDS 实例初始化 mysql 提供程序，以进一步将其用于用户
当用户在我的网站上注册时，他们会在我的一个数据库中创建自己的表格。该表存储用户发布的所有帖子。我还想做的是也为他们生成自己的 MySql 用户——该用户仅有权从他们的表中读取、写入和删除。 创建它应该
我有一个关于 ColdFusion 和 Mysql 的问题。我有两个表:PRODUCT 和 PRODUCT_CAT。我想列出包含一些标记为:IS_EXTRANET=1 的特殊产品的类别。所以我写了这个
我想获取 recipes_id 列的值，以获取包含 ingredient_id 的 2,17 和 26 条目的值。 假设 ingredient_id 2 丢失则不获取记录。 我已经尝试过 IN 运算符
在 Ubuntu 中，我通常安装两者，但 MySQL 的客户端和服务器之间有什么区别。 作为奖励，当一个新语句提到它需要 MySQL 5.x 时，它是指客户端、服务器还是两者兼而有之。例如这个链接ht
我重新访问了我的数据库并注意到我有一些 INT 类型的主键。 这还不够独特，所以我想我会有一个指导。 我来自微软 sql 背景，在 ssms 中你可以 选择类型为“uniqeidentifier”并自
我的系统上有 MySQL，我正在尝试确定它是 Oracle MySQL 还是 MySQL。 Oracle MySQL 有区别吗: http://www.oracle.com/us/products/m
我是在生产 MySQL 中运行的应用程序的新维护者。之前的维护者已经离开，留下的文档很少，而且联系不上了。 我面临的问题是执行以下请求大约需要 10 秒: SELECT COUNT(*) FROM `
我有两个位于不同机器上的 MySQL 数据库。我想自动将数据从一台服务器传输到另一台服务器。比方说，我希望每天早上 4:00 进行数据传输。 可以吗？是否有任何 MySQL 内置功能可以让我们做到这一
有什么方法可以使用 jdbc 查询位于 mysql 根目录之外的目录中的 mysql 表，还是必须将它们移动到 mysql 根目录内的数据库文件夹中？我在 Google 上搜索时没有找到任何东西。 最
我在 mysql 数据库中有两个表。成员和 ClassNumbers。两个表都有一个付费年份字段，都有一个代码字段。我想用代码数字表中的值更新成员表中的付费年份，其中成员中的代码与 ClassNumb
情况:我有 2 台服务器，其中一台当前托管一个实时 WordPress 站点，我希望能够将该站点转移到另一台服务器，以防第一台服务器出现故障。传输源文件很容易；传输数据库是我需要弄清楚如何做的。两台服
Phpmyadmin 有一个功能是“复制数据库到”..有没有mysql查询来写这个函数？类似于将 db A 复制到新的 db B。 最佳答案 首先创建复制数据库: CREATE DATABASE du
我有一个使用 mySQL 作为后端的库存软件。我已经在我的计算机上对其进行了测试，并且运行良好。 当我在计算机上安装我的软件时，我必须执行以下步骤: 安装 mySQL 服务器 将用户名指定为“root
我是一名优秀的程序员,十分优秀！