mysql 5.7 ibdata1_MySQL5.7.28 data file 'ibdata1' must be writable

问题1) The innodb_system data file 'ibdata1' must be writable

2020-02-13T04:27:33.434903Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be

writable

2020-02-13T04:27:33.434927Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be

writable

2020-02-13T04:27:33.434933Z 0 [ERROR] InnoDB: Plugin initialization aborted with error

Generic error

2020-02-13T04:27:33.735295Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

2020-02-13T04:27:33.735329Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE

failed.

2020-02-13T04:27:33.735334Z 0 [ERROR] Failed to initialize builtin plugins.

2020-02-13T04:27:33.735338Z 0 [ERROR] Aborting

[root@host-172-16-61-102 lib]# ls -la |grep mysql

drwxr-xr-x.  6 mysql          mysql          4096 2月  12 17:15 mysql

2)Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

2020-02-13T04:37:06.961052Z 0 [ERROR] Fatal error: Can't open and lock privilege tables:

Table 'mysql.user' doesn't exist

2020-02-13T04:37:06.961072Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time

zones structures or failed to remove temporary table files.

2020-02-13T04:37:06.961138Z 0 [ERROR] Aborting

2020-02-15T06:58:32.669156Z 0 [ERROR] Can't open the mysql.plugin table. Please run

mysql_upgrade to create it.

解决方案

进行数据库初始化