Question

MySQL(Percona 5.6)将不开始。

我曾多次发生这一错误。我每次都不得不拆除MySQL的数据目录,并重新安装MySQL。

是否有另一种办法解决MySQL? (具体地说,数据没有被冲走?)

/var/log/mysql/error.log

150214 16:36:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-02-14 16:36:40 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-02-14 16:36:40 0 [Warning]  THREAD_CONCURRENCY  is deprecated and will be removed in a future release.
2015-02-14 16:36:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-02-14 16:36:40 1018 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2015-02-14 16:36:40 1018 [Note] Plugin  FEDERATED  is disabled.
/usr/sbin/mysqld: Incorrect file format  plugin 
2015-02-14 16:36:40 1018 [ERROR] Can t open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-02-14 16:36:40 1018 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-14 16:36:40 1018 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-14 16:36:40 1018 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-02-14 16:36:40 1018 [Note] InnoDB: Memory barrier is not used
2015-02-14 16:36:40 1018 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-02-14 16:36:40 1018 [Note] InnoDB: Using Linux native AIO
2015-02-14 16:36:40 1018 [Note] InnoDB: Using CPU crc32 instructions
2015-02-14 16:36:40 1018 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2015-02-14 16:36:40 1018 [Note] InnoDB: Completed initialization of buffer pool
2015-02-14 16:36:40 1018 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-14 16:36:40 1018 [Note] InnoDB: The log sequence numbers 714340126 and 714340126 in ibdata files do not match the log sequence number 716513090 in the ib_logfiles!
2015-02-14 16:36:40 1018 [Note] InnoDB: Database was not shutdown normally!
2015-02-14 16:36:40 1018 [Note] InnoDB: Starting crash recovery.
2015-02-14 16:36:40 1018 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-14 16:36:40 1018 [Note] InnoDB: Restoring possible half-written data pages 
2015-02-14 16:36:40 1018 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 292596, file name binlog.000056
2015-02-14 16:36:40 1018 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-14 16:36:40 1018 [Note] InnoDB: Waiting for purge to start
2015-02-14 16:36:40 1018 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.21-70.1 started; log sequence number 716513090
2015-02-14 16:36:40 1018 [Note] Recovering after a crash using binlog
2015-02-14 16:36:40 1018 [Note] Starting crash recovery...
2015-02-14 16:36:40 1018 [Note] Crash recovery finished.
2015-02-14 16:36:40 1018 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-02-14 16:36:40 1018 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-02-14 16:36:40 1018 [Note] Server hostname (bind-address):  * ; port: 3306
2015-02-14 16:36:40 1018 [Note] IPv6 is available.
2015-02-14 16:36:40 1018 [Note]   -  ::  resolves to  :: ;
2015-02-14 16:36:40 1018 [Note] Server socket created on IP:  :: .
2015-02-14 16:36:40 1018 [ERROR] Fatal error: Can t open and lock privilege tables: Incorrect file format  user 
150214 16:36:40 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended

Answer 1

由于约翰把我放在正确的轨道上,我有几条其他hoo子可以跳到我的系统。希望有助于人们。

这是一个腐败的特权表。可能是升级或电力故障所致。我的系统是开放式的。简单地重新插入并不固定,必须删除MySQL的所有痕迹,然后重新加入。

关闭MySQL的所有事件

$ systemctl stop mysql.service
$ pkill -9 mysqld

起始服务器绕过特权系统

$ sudo mysqld_safe --user=root --skip-grant-tables

启动MySQL指挥线工具

$ mysql

收到

ERROR 2002 (HY000): Can t connect to local MySQL server through socket  /var/run/mysqld/mysqld.sock  (2)

我的原木——安全正在别处。予以赔偿。

$ sudo find / -type s

Mine was in /var/run/mysql/ Edit the socket line in my.cnf, making a note of your existing socket setting. My line became

socket=/var/run/mysql/mysql.sock

Return to 关闭MySQL的所有事件 (the top of these instructions). Follow them through to 启动MySQL指挥线工具 . Hopefully you can open mysql successfully. From mysql command line.

mysql> use mysql
mysql> repair table user use_frm;
mysql> exit

关闭MySQL的所有事件

$ systemctl stop mysql.service
$ pkill -9 mysqld

重新接手我的笔记,将记票线退回到原来的位置。

我不得不在我的神话数据目录中重新获得2份档案许可。

$ chown mysql:mysql server2.err
$ chown mysql:mysql server2.pid

启用MySQL服务器

$ systemctl start mysql.service

然后,我用另一个表格(db)得出同样的原始错误。

[ERROR] Fatal error: Can t open and lock privilege  tables: Incorrect file format  db

在确定所有特权表之前,必须重复上述程序多次改变修理指挥。

mysql> repair table db use_frm;

Answer 2

我用answer 页: 1

你必须修理你的东道桌子。为此,发布以下指令,从服务器开始绕过特权系统:

在一个终端站,运行

$ sudo mysqld --skip-grant-tables

开放另一个终点站,执行这些指挥

$ mysql
mysql> use mysql
mysql> repair table host use_frm;
mysql> exit

恢复我的服务

$ sudo service mysql restart

Answer 3

页: 1 www.un.org/Depts/DGACM/index_french.htm

首先,从<条形码>mysql-container开始使用一个新的cker集装箱。 (同一位你曾与亚洲开发银行写过。)

$ docker run --rm -it -v <named_volume>:/var/lib/mysql mysql:<tag> /bin/bash

This will launch a new container with the correct named volume (or mounted volume) mounted in the container and drop you into a shell as root. The mysqld-Daemon will refuse to launch as root though, so we ll run it as the mysql-user:

$ whoami
root
$ which mysqld
/usr/sbin/mysqld
$ su mysql
$ whoami
mysql
$ /usr/sbin/mysqld --skip-grant-tables
....

我们现在要管理这辆车,我们把车从一个新的终点站连接起来。

$ docker ps 
CONTAINER ID [...]
abc123 [...]
$ docker exec -it abc123 /bin/bash
# We re on the container now!
$ whoami
root
$ mysql
...

And continue from there. When you re done, leave the container on the second terminal via exit. The terminal running mysqld will not respond to CMD+C, so we ll stop the container via Docker:

$ docker ps
CONTAINER ID [...]
abc123 [...]
$ docker stop abc123

Answer 4

2. 解决“租赁错误: • 开放和锁定特权表: 在Windows XAMPP中,没有校正的文档格式。

Navigate to your XAMPP MySQL location. By default, it is located at C:xamppmysqlin, but it may differ based on your installation.

Open Command Prompt from this location (you can type cmd in addressbar. cmd location will be current folder directory .here it will be C:xamppmysqlin).

:

Execute the following command:

mysqld.exe --skip-grant-tables

——速成表格方案用于启动MySQL服务器,而不装上赠款表。补助金表是MySQL储存用户特权信息的地方,例如用户可以查阅哪些数据库以及他们能够从事哪些业务。

一旦执行法典,你就可以自动启动Xamp的地板。你们可以在青少年中执行我的q。

Next, execute:

mysql.exe

Once in the MySQL command-line interface, type:

use mysql;

This command selects the default MySQL database where user privileges are stored.

Then, run:

repair table db use_frm;

该指挥部用手法修理了我方ql数据库中的 d。

Finally, exit the MySQL command-line interface:

exit;

我的我的SQL特权现在应当得到修缮,你应该能够操作XAMPP而不遇到错误。

友情链接