How to solve MySQL "Failed to read auto-increment value from storage engine" problem when installing Wordpress?

Question

PHP

I ran into a problem while installing Wordpress. There is Ubuntu-server + ISPConfig 3 version. When I try to install, I get an error:

WordPress database error: [Failed to read auto-increment value from storage engine]

in the error log displays:

[Thu Sep 25 04:46:56.041541 2014] [:error] [pid 2103] [client ********] FastCGI: server "/var/www/clients/client1/web13/cgi-bin/php5-fcgi-*-80-domain.ru" stderr: PHP message: \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Failed to read auto-increment value from storage engine \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('sidebars_widgets', 'a:5:{s:19:\\"wp_inactive_widgets\\";a:0:{}s:9:\\"sidebar-1\\";a:6:{i:0;s:8:\\"search-2\\";i:1;s:14:\\"recent-posts-2\\";i:2;s:17:\\"recent-comments-2\\";i:3;s:10:\\"archives-2\\";i:4;s:12:\\"categories-2\\";i:5;s:6:\\"meta-2\\";}s:9:\\"sidebar-2\\";a:0:{}s:9:\\"sidebar-3\\";a:0:{}s:13:\\"array_version\\";i:3;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`), \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 wp_install, wp_install_defaults, update_option, add_option, referer: http://domain.ru/wp-admin/install.php?language=ru_RU

wandered on the mysql forums, and did not receive an answer. Advised to reinstall - reinstalled (apt-get install -reinstall mysql-server). Did not help.

Answer 1

The problem is 100% at the MySQL level, WordPress has nothing to do with it at all. A simple reinstall doesn't really help. I have not been working with regular MySQL for a long time, I advise you to do the same - install MariaDB 10 (and you will need the php-mysqlnd module).
1. Here we select our version of Ubuntu and MariaDB, add the received data to the repo list
2. Remove MySQL
3. Install MariaDB and php-mysqlnd
4. Do mysql_secure_install
5. Profit