当我进入 Xampp 控制面板并按下 MySQL 的“执行”时，它拒绝运行。这是一个完全准确且干净/全新的安装。我正在运行 10.10。以下是错误日志：
110414 18:43:52 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110414 18:43:52 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110414 18:43:52 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110414 18:43:52 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110414 18:43:53 InnoDB: Started; log sequence number 0 0
110414 18:43:53 InnoDB: Starting shutdown...
110414 18:43:58 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:43:58 [Note] Plugin 'FEDERATED' is disabled.
110414 18:43:58 InnoDB: Started; log sequence number 0 44233
110414 18:43:58 InnoDB: Starting shutdown...
110414 18:44:03 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:44:03 [Note] Plugin 'FEDERATED' is disabled.
110414 18:44:04 InnoDB: Started; log sequence number 0 44233
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds
to
your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD
column
Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
110414 18:44:04 [ERROR] Aborting
110414 18:44:04 InnoDB: Starting shutdown...
110414 18:44:09 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:44:09 [Note] /usr/sbin/mysqld: Shutdown complete
110414 18:44:09 [Note] Plugin 'FEDERATED' is disabled.
110414 18:44:09 InnoDB: Started; log sequence number 0 44233
110414 18:44:09 InnoDB: Starting shutdown...
110414 18:44:14 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:44:14 [Note] Plugin 'FEDERATED' is disabled.
110414 18:44:15 InnoDB: Started; log sequence number 0 44233
ERROR: 1050 Table 'plugin' already exists
110414 18:44:15 [ERROR] Aborting
110414 18:44:15 InnoDB: Starting shutdown...
110414 18:44:20 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:44:20 [Note] /usr/sbin/mysqld: Shutdown complete
110414 18:44:21 [Note] Plugin 'FEDERATED' is disabled.
110414 18:44:21 InnoDB: Started; log sequence number 0 44233
110414 18:44:21 [Note] Event Scheduler: Loaded 0 events
110414 18:44:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.49-1ubuntu8.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306
(Ubuntu)
110414 18:56:29 [Note] /usr/sbin/mysqld: Normal shutdown
110414 18:56:29 [Note] Event Scheduler: Purging the queue. 0 events
110414 18:56:32 InnoDB: Starting shutdown...
110414 18:56:47 InnoDB: Shutdown completed; log sequence number 0 44233
110414 18:56:47 [Note] /usr/sbin/mysqld: Shutdown complete
110414 18:57:39 [Note] Plugin 'FEDERATED' is disabled.
110414 18:57:42 InnoDB: Started; log sequence number 0 44233
110414 18:57:42 [Note] Event Scheduler: Loaded 0 events
110414 18:57:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.49-1ubuntu8.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306
(Ubuntu)
110414 19:21:14 [Note] /usr/sbin/mysqld: Normal shutdown
110414 19:21:15 [Note] Event Scheduler: Purging the queue. 0 events
110414 19:21:17 InnoDB: Starting shutdown...
110414 19:21:18 InnoDB: Shutdown completed; log sequence number 0 44233
110414 19:21:18 [Note] /usr/sbin/mysqld: Shutdown complete
110414 19:23:40 [Note] Plugin 'FEDERATED' is disabled.
110414 19:23:40 InnoDB: Started; log sequence number 0 44233
110414 19:23:41 [Note] Event Scheduler: Loaded 0 events
110414 19:23:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.49-1ubuntu8.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306
(Ubuntu)
110414 19:25:40 [Note] /usr/sbin/mysqld: Normal shutdown
110414 19:25:40 [Note] Event Scheduler: Purging the queue. 0 events
110414 19:25:40 InnoDB: Starting shutdown...
110414 19:25:41 InnoDB: Shutdown completed; log sequence number 0 44233
110414 19:25:41 [Note] /usr/sbin/mysqld: Shutdown complete
110414 19:26:26 [Note] Plugin 'FEDERATED' is disabled.
110414 19:26:27 InnoDB: Started; log sequence number 0 44233
110414 19:26:27 [Note] Event Scheduler: Loaded 0 events
110414 19:26:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.49-1ubuntu8.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
答案1
尝试运行常规 MySQL（通过 Synaptic 获得）。实际上，在 Ubuntu 中运行 XAMPP 并没有太多好处，因为您可以轻松地在机器上安装组件并轻松获得相同或增强的功能。
@jgbelacqua 给出了一个 UTF-8 问题链接，并建议删除 UTF-8 引用。我没有仔细阅读他的链接，不知道它是否建议使用其他字符集，但如果是这样，那就是坏建议。MySQL 当然支持 UTF-8，而且有很多很好的理由说明你也应该使用它。如果 XAMPP 附带的 MySQL 版本无法处理这个问题，那么 XAMPP 就有缺陷，应该放弃。
答案2
为什么不安装 LAMP 服务器？xampp 漏洞很多，我在每个平台上都遇到了问题。最新版本的 MySql 存在严重问题，根本无法运行！
做就是了
sudo apt-get install php5 php5-mysql phpmyadmin mysql-server-5.1 apache2
你就完成了。